Running head: DATABASE SYSTEMDatabase SystemsName of the Student:Name of the University:Author Note
1DATABASE SYSTEMTask 1For the first task the business rules that are to be considered are:Manufacture Code is used for the identification of the manufacturerEach and every type is produced by only a single manufacturerThe following ER Diagram has been constructed using the provided business rules.The main entity is the Manufacturer, TypeThe attributes within the entity are:Manufacturer (Manufacturer_No (primary key), Company_Name, City, Street, PostCode,Phone_number, Account_number)Type (TypeNo (primary key), Type, Purpose, manufacturerNo (foreign key))Task 2For Task 2 an additional business rule provided by the company is:
2DATABASE SYSTEMEach every model that is produced should be a part of the Type. From the above consideration the following ER diagram has been developed.The main entities of this ERD are Model, Type and manufacturerThe main attributes of the entity are:Manufacturer (Manufacturer_No (primary key), Company_Name, City, Street, PostCode,Phone_number, Account_number)Type (TypeNo (primary key), Type, Purpose, manufacturerNo (foreign key))Model (ModelNo (primary key), length, engine, Beam, Recommended_Retail_Price,Retail_Price, Dry_Weight, TypeNo (forgien key))Task 3The business rule described for the next composition of diagram are:Only a single type of model should be produced by a single warehouse.
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Introduction to Database Systemslg...
|10
|1030
|259
Dataset System - Assignmentlg...
|7
|685
|67
Dataset System Assignment Samplelg...
|7
|716
|37
ITECH 1006- Database Management Systemslg...
|10
|1155
|228
ITECH 1006 - Assignment On Database Management Systemslg...