Ask a question from expert

Ask now

Term Project ERD

7 Pages684 Words295 Views
   

Added on  2019-10-18

Term Project ERD

   Added on 2019-10-18

BookmarkShareRelated Documents
Student 09 OCTOBER, 2016TERM PROJECT WEEK 5
Term Project ERD_1
ContentsTRANSLATION METHOD........................................................................................................................2DRAFT ERD.............................................................................................................................................3RELATIONAL SCHEMA............................................................................................................................3DATA DICTIONARY.................................................................................................................................41 | P a g e
Term Project ERD_2
TRANSLATION METHODThe translation method used on ERD was ‘mapped translation method’. In this method, a table is created for each entity. Although the entities may be weak or strong but a table is needed to define and declare the attributes of the entities. Then, the primary keys are added toeach table to identify each record and as shown in the ER diagram. Further we, map the relationship between entities into the tables using foreign keys. These foreign keys act as a bridge between the entities that have transformed into the table. Along with this we also add all the attributes that we had defined in the ERD into the table as columns. This entire processis called mapped translation because one by one each part is mapped and then translated into another form for use in the database. Its advantages are:1.The multi-values attributes in the ERD can be transformed into atomic attributes in the relational table.2.Translation is easy rather than directly converting to the SQL.3.Redundancy present in the ER diagram can be removed easily via it.4.Constraints can be enforced after translation, which is not possible in the ER diagram5.The actual physical storage requirements are reduced by applying this method.6.Multiple tables can be easily joined without any hasslesIts disadvantages are:1.Requires cost and expertise2.Increased number of attributes while making the ERD atomic.2 | P a g e
Term Project ERD_3

End of preview

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

Related Documents
Draft SQL Implementation Assignment
|12
|1254
|190

Database Management System Assignment 2022
|32
|6949
|24

Employee Database: ER Diagram, Table Commands, Sample Data, SQL Queries
|15
|704
|88

Database Design and Implementation for Fashion Outlet
|33
|5708
|93

Enterprise Rules - Hospital Management System
|22
|1437
|45

Show the ER diagram for your database.
|5
|510
|454