1.1 Convert the following ER diagram into relational model. The referential integrity constraints must be identified...

 

Transcribed Image Text:

1.1 Convert the following ER diagram into relational model. The referential integrity constraints must be identified in the relational model. Name SECRETARY D.O.B. Department Salary EMPLOYEE ISA TECHNICIAN PERSON ISA Specialization FRESHMAN GPA SOPHOMORE Major SSN STUDENT ISA StartDate Major SENIOR JUNIOR Advisor Major Convert the following ER diagrams into relational models. The referential integrity constraints must be identified in the relational model. city name DOB stadium Team belongs num name host shirtNum. guest Plaver isMain Start Year DoB role. plays Match inMatch Referee ExpYears Sub name Match-Player time date Host-score numGoals guest-score ID RedFlag YellowFlag 1.1 Convert the following ER diagram into relational model. The referential integrity constraints must be identified in the relational model. Name SECRETARY D.O.B. Department Salary EMPLOYEE ISA TECHNICIAN PERSON ISA Specialization FRESHMAN GPA SOPHOMORE Major SSN STUDENT ISA StartDate Major SENIOR JUNIOR Advisor Major Convert the following ER diagrams into relational models. The referential integrity constraints must be identified in the relational model. city name DOB stadium Team belongs num name host shirtNum. guest Plaver isMain Start Year DoB role. plays Match inMatch Referee ExpYears Sub name Match-Player time date Host-score numGoals guest-score ID RedFlag YellowFlag

Answer rating: 100% (QA)

To convert ER diagrams into relational models we must identify entities relationships and their attributes Furthermore for each relationship we need t... View the full answer