PART I: Follow lecture 4 and map an ER diagram into a relational model Map...

Transcribed Image Text:

PART I: Follow lecture 4 and map an ER diagram into a relational model • Map the following ER diagram to a relational model • Your model should reflect all entities, attributes, relationships and constraints accordingly • Submit your relational model to Canvas name PERSON address salary fee EMPLOYEE STUDENT thesis RESEARCH TEACHING POST GRAD UNDER GRAD Year = 4 FINAL YEAR LECTURER TUTOR SUPERVISOR project Gourseno PART II: University Database in MYSQL • Create a database and its tables and constraints based on the relational model of PART I. • You can use my slides and any other resources to complete this exercise. • A good resource can be found here • Submit the SQL statements you used to create the database and its tables (you can copy/paste directly from the mysql console). PART I: Follow lecture 4 and map an ER diagram into a relational model • Map the following ER diagram to a relational model • Your model should reflect all entities, attributes, relationships and constraints accordingly • Submit your relational model to Canvas name PERSON address salary fee EMPLOYEE STUDENT thesis RESEARCH TEACHING POST GRAD UNDER GRAD Year = 4 FINAL YEAR LECTURER TUTOR SUPERVISOR project Gourseno PART II: University Database in MYSQL • Create a database and its tables and constraints based on the relational model of PART I. • You can use my slides and any other resources to complete this exercise. • A good resource can be found here • Submit the SQL statements you used to create the database and its tables (you can copy/paste directly from the mysql console).

Answer rating: 100% (QA)

Er diagram into a relational model with university database Peoson o Name VARCHARCR0 Addoess VARCHAR ... View the full answer