Course: Fundemantals Database (IT403)

Converting an ER into relations

Purpose

The purpose of this assignment is to help you learn more about converting an ER diagram.

Action Items

Discuss with your friends the conversion of the following ER diagram into relational tables, along with all appropriate constraints.

Take one entity/relationship from the ER and proof the resulting relations.

Note: You have first to check the discussed entities/relation in the discussion board and then choose a new one (not yet discussed).

Justify whenever you ignore entities attributes, add attributes from outside the entities or create tables other than the entities (e.g. from the relationship set).

Hiring date Company Staff Wife Staff Name DOBirth Address (Phone Number Age0 Comp Name Address Work Married Task Child Task Name Descripton Perform Has Child Name Hiring date Company Staff Wife Staff Name DOBirth Address (Phone Number Age0 Comp Name Address Work Married Task Child Task Name Descripton Perform Has Child Name