Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Draw an ER diagram for the order-entry database from above information 12.4. use ER diagaram to derive an appropriate set of base relvar definitions. NOTE
Draw an ER diagram for the order-entry database from above information 12.4. use ER diagaram to derive an appropriate set of base relvar definitions.
NOTE : The standard notations of E/R diagram and relational table mapping rules should be followed.
A database used in an order-entry system is to contain information about customer 12.4 and orders. The following information is to be included: s, items, For each customer: Customer number (unique) "Ship-to" addresses (several per customer) Balance - - - Credit limit Discount For each order: - Heading information: Customer number Ship-to address Date of order Detail lines (several per order): Item number Quantity ordered - For each item: Item number (unique) - Manufacturing plants Quantity on hand at each plant Stock danger level for each plant " Item description For internal processing reasons, a "quantity outstanding" value is associated with each detail line of dered and is progressively reduced to zero as partial shipments are made. Again, design a database for this data. As in the previ- ous exercise, state any assumptions you make regarding dependencies. say one nercent or lessStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started