logo

Relational Database Assignment

5 Pages538 Words84 Views
   

Added on  2020-03-16

Relational Database Assignment

   Added on 2020-03-16

ShareRelated Documents
Running head: RELATIONAL DATABASERelational DatabaseName of the Student: Name of the University:Author Note
Relational Database Assignment_1
1RELATIONAL DATABASE1.Approach for the modelling ExerciseFor the modelling exercise the entities are to be identified from provided case study and alsoattributes for each of the entities are identified for the solution. After the identification of theentities it is also very important to identify the primary keys that were identified for the entitiesin the system. After the identification of the entities the ER Diagram of the system is designed.In addition to this, the Relation schema are also designed for the systems. The main entities thatare identified in the system are vehicles, clients, salesperson, manufacturer and sale. In additionto this, the main primary key identified for each of the entities are vehiclesId, ClientsId,SalespersonId, ManufacturerId and SaleId. After the relational schema that are designed thetables that were defined in the relation schema are being normalized to the third normal formaand also the relational schema is being reconstructed. After the reconstruction of the tables of thedatabase the actual database is being implemented using MySQL. After the implementation ofthe database are completed the data are inserted into the database and it is saved. The databasewould be ready where the queries can be run to fetch the data.2.ER Diagram
Relational Database Assignment_2

End of preview

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

Related Documents
A Model Description: Jo Bloggs Auto Traders
|4
|815
|451

Entity–relationship Model | Assignment
|5
|697
|16