Figuer:
-Assuming that we do not use the rule(s)that avoid null values in tables,converting the ERD diagram to a relational database will produce the following number of tables:
A) 3
B) 4
C) 5
D) 6

Question

Figuer: 
-Assuming that we do not use the rule(s)that avoid null values in tables,converting the ERD diagram to a relational database will produce the following number of tables:
A) 3 
B) 4 
C) 5 
D) 6

Quizplus · Accepted Answer

Converting the given ERD to a relational database without using the rule(s) that avoid null values will produce the following tables:
1. TB4814: with attributes Part #, Description, Price, and Material
2. TB4814 Supplier: with attributes Supplier # and Supplier Name
3. TB4814 Inventory: with attributes Transaction #, Transaction Date, Purchase order #, Receipt #, Units received, Unit cost, and Supplier #
4. TB4814 Customer Order: with attributes Order #, Order Date, Customer #, and Units ordered
5. TB4814 Shipment: with attributes Shipment #, Shipment Date, Customer Order #, and Units shipped
Thus, there will be a total of 5 tables.

Figuer: -Assuming That We Do Not Use the Rule(s)that Avoid Null