Task 3.2: Create an ER diagram You can do this in any program of your choice...

Transcribed Image Text:

Task 3.2: Create an ER diagram You can do this in any program of your choice (e.g., MS Word, draw.io (online), etc.). Task 3.3: Convert the ER Diagram into tables For this task, you are not required to implement the tables in any RDBMS. You are just required to write the schema, i.e., table name, attributes, primary keys, and foreign keys, as shown in the lectures/labs. This is a step-by-step process: 1) Create one table per entity. 2) Each attribute of the entity is represented as a column in the table. 3) Define the primary key columns (underline them) 4) Add the foreign keys (write them in italic). Task 3.2: Create an ER diagram You can do this in any program of your choice (e.g., MS Word, draw.io (online), etc.). Task 3.3: Convert the ER Diagram into tables For this task, you are not required to implement the tables in any RDBMS. You are just required to write the schema, i.e., table name, attributes, primary keys, and foreign keys, as shown in the lectures/labs. This is a step-by-step process: 1) Create one table per entity. 2) Each attribute of the entity is represented as a column in the table. 3) Define the primary key columns (underline them) 4) Add the foreign keys (write them in italic).