Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1). a) After long sessions with users/managers of a production company, the data requirements were collected into structural sentences given as below. Construct the

image text in transcribed

Question 1). a) After long sessions with users/managers of a production company, the data requirements were collected into structural sentences given as below. Construct the Data Model in Oracle Barker Notations for those relational sentences. (16 Points) b) Assign unique identifiers to the entities. (4 Points) Each STOCK must be subject to one and only one FINAL PRODUCT QUALITY. Each BATCH ITEM must be an entity under one and only one ITEM. Each ITEM may be subject for one or more ORDER ITEMS. Each BATCH ITEM must be defined in one and only one BATCH. Each RAW MATERIAL QUALITY must be for one and only one ORDER ITEM. Each STOCK may be subject of one or more VOUCHERS. Each RAW MATERIAL must be for one and only one STOCK. Each RAW MATERIAL QUALITY may be sent as one or more STOCKs. Each VOUCHER must be contained in one and only one STOCK. Each BATCH may be either subject to one or more RAW MATERIALS or one or more BATCH ITEMS. Each FINAL PRODUCT QUALITY may be applied to one or more STOCKS. Each RAW MATERIAL must be defined in one and only one BATCH. Each ITEM may be produced as one and only one BATCH ITEM. Each ORDER ITEM must be defined as one and only one ITEM. Each STOCK may be in one or more RAW MATERIALS. Each ORDER ITEM may be subject for one or more RAW MATERIAL QUALITYs. Each STOCK must be for one and only one RAW MATERIAL QUALITY. Question 1). a) After long sessions with users/managers of a production company, the data requirements were collected into structural sentences given as below. Construct the Data Model in Oracle Barker Notations for those relational sentences. (16 Points) b) Assign unique identifiers to the entities. (4 Points) Each STOCK must be subject to one and only one FINAL PRODUCT QUALITY. Each BATCH ITEM must be an entity under one and only one ITEM. Each ITEM may be subject for one or more ORDER ITEMS. Each BATCH ITEM must be defined in one and only one BATCH. Each RAW MATERIAL QUALITY must be for one and only one ORDER ITEM. Each STOCK may be subject of one or more VOUCHERS. Each RAW MATERIAL must be for one and only one STOCK. Each RAW MATERIAL QUALITY may be sent as one or more STOCKs. Each VOUCHER must be contained in one and only one STOCK. Each BATCH may be either subject to one or more RAW MATERIALS or one or more BATCH ITEMS. Each FINAL PRODUCT QUALITY may be applied to one or more STOCKS. Each RAW MATERIAL must be defined in one and only one BATCH. Each ITEM may be produced as one and only one BATCH ITEM. Each ORDER ITEM must be defined as one and only one ITEM. Each STOCK may be in one or more RAW MATERIALS. Each ORDER ITEM may be subject for one or more RAW MATERIAL QUALITYs. Each STOCK must be for one and only one RAW MATERIAL QUALITY

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Put Your Data To Work 52 Tips And Techniques For Effectively Managing Your Database

Authors: Wes Trochlil

1st Edition

0880343079, 978-0880343077

More Books

Students also viewed these Databases questions

Question

How is intelligence defined?

Answered: 1 week ago