Question

Write down the rules for converting E-R diagram to relations with example.​

Answer 1

E-R Diagrams

• Need to convert E-R model diagrams to an

implementation schema

• Easy to map E-R diagrams to relational model,

and then to SQL

– Significant overlap between E-R model and relational

model

– Biggest difference is E-R composite/multivalued

attributes, vs. relational model atomic attributes

• Three components of conversion process:

– Specify schema of relation itself

– Specify primary key on the relation

– Specify any foreign key references to other relations