About this document

ER Model to Relational Model Conversion Guide by Javeria Abbasi is a document available to read on EtoBox.

This lab focuses on converting an entity relationship (ER) model to a relational model using a 9-step algorithm. The algorithm maps entity types, relationships, attributes and other concepts from the ER model to tables and columns in a relational database. As an example, an ER model of a company is converted to relations for the Company, Staff, Child, Spouse and Phone entities and their relationships. Students are asked to convert an ER model of the US Congress to relations and provide the data definition l

Author

Javeria Abbasi

Language

EN