Ask a question from expert

Ask now

Database Systems - Assignment

10 Pages881 Words187 Views
   

Added on  2021-04-16

Database Systems - Assignment

   Added on 2021-04-16

BookmarkShareRelated Documents
Running head: DATABASE SYSTEMDatabase SystemsName of the Student:Name of the University:Author Note
Database Systems -  Assignment_1
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:
Database Systems -  Assignment_2
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.
Database Systems -  Assignment_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Introduction to Database Systems
|10
|1030
|259

Dataset System - Assignment
|7
|685
|67

Dataset System Assignment Sample
|7
|716
|37

ITECH 1006- Database Management Systems
|10
|1155
|228

ITECH 1006 - Assignment On Database Management Systems
|12
|1416
|588

CQ Insurance Database Diagram
|6
|635
|103