Question

Need assistance with this question. Please show detailed steps.

For each of the following (parts a through g) E-R diagrams: L. Transform the diagram to a relational schema that shows referential integrity constraints (see the following figure for an example of such a schema - underlined items are primary keys, dotted underlines refer to foreign keys, while the arrows indicate direction from foreign to primary) CUSTOMER CustomerlD CustomerName ORDER OrderlD OrderDate CustomerlD ORDER LINE OrderlD rd OrderedQuantity PRODUCT roductD ProductDescription

Answer 1

Relational Schema :-

1.Customer (CustomerID,CustomerName,CustomerAdress,CustomerCity,CustomerState,CustomerPostalCode)

2. Order(OrderID,OrderDate,CustomerID) // CustomerID is referred from Primary key CustomerID of Customer Relation

3. Product(ProductID,ProductDescription,ProductFinish,ProductStandardPrice,ProductLineID)

4. OrderLine(OrderID,ProductID,OrderedQuantity) //OrderID is refeered from primary key of Order relation and ProductID is referred from the primary key of Product Relation.

-> All primary keys are underlined.

-> All Foriegn keys are explained above.

-> Everything numbered is relation with relation name and the various attributes that define a particular relation.