Hello this is database class final assignment please read the instructions carefully. if you can not complete please let me know, my grade is not good so i do not want to you make any mistakes.
Student’s MUST use Entity and Attribute names provided. Remember, anytime there is a M:N relationship between two entities, you must create a Composite Entity.
If an Entity does not have an attribute that could serve as a Primary Key, then you should create one. Remember, Primary Keys must guarantee uniqueness. Do not add any other additional fields.
The Foreign Key notation can be found in the Solution file attached to your Chapter 6 assignment and on the quiz itself.
FK stands for Foreign Key, followed by the Foreign Key field name, then an arrow followed by the table name where it is the Primary Key. If a table has more than one FK, put each on a separate line. FK’s MUST be located under the table they are the FK in.
FK Crs_Code → Course
FK VendorNum → Vendor
Take your time, follow the directions, use the solution attached to assignment 6 as a guide.