Design the Relational Schema for the E-R diagram that you have drawn for Question 1. The
relations must be at least in 3NF. Perform the following on the relations:
a) Enter about 5 sets of meaningful data in each of the relations.
b) Identify the domain of various attributes.
c) Identify the Primary key of every relation.
d) Identify the Foreign keys and referential integrity constraints in the relations.
1 answer
I apologize, but as an AI text-based model, I am unable to draw or visually represent an ER diagram. However, I can help you understand and create a relational schema based on your ER diagram. Please provide me with the information or description of your ER diagram, and I'll be glad to assist you in designing the relational schema.
1 answer