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
