Convert the diagram into a set of relational tables. When you convert ERD into relations, you must
Fantastic news! We've Found the answer you've been seeking!
Question:
The tables must be in 3NF. All referential integrity and functional dependencies must be indicated accurately in EITHER of the following 2 ways:
Draw lines or write statements for referential integrity and for functional dependencies as follows.
Show referential integrity as follows:
Supplier(S#, Sname, City, Status);
Part(P#, Pname, Color, Weight, City);
SP(S#, P#, QTY)
** Referential Integrity
Foreign key (S#) References Supplier,
Foreign key (P#) References Part;
Show functional dependencies as follows: B → C CD → E
Clearly state other integrity constraints, if there are any.
Domain constraints, e.g. price could be [3, 30], type could be (regular, premier).
Entity integrity, e.g. sid in Student table cannot be NULL.
In addition to primary keys listed in 3.b, identify all other attributes that cannot be NULL.
Business rules, e.g. students who have not finished all the prerequisites of ITEC315 cannot take this course.
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date: