Question: Given the following relations and referential integrity rules, draw an ER diagram on the blank page provided. Write your completed answer on the page provided

Given the following relations and referential integrity rules, draw an ER diagram on the blank page provided. Write your completed answer on the page provided for this problem (I will only grade work done on the proper answer sheets provided). You do not need to write in the primary keys and attributes, just the entity names! Be sure to mark every assumption individually. Assumptions cannot be made in contradiction to the given relations and foreign key constraints. (Primary keys are underlined, foreign keys are bold). Show each assumption with a capital A inside a circle:

Alcyone (AlcyoneID, MayoID, AlcyoneAttrib)

FOREIGN KEY MayoID REFERENCES Alcyone(AlcyoneID)

NULL ALLOWED, ON DELETE SET NULL

Asterope (AsteropeID, ElectraID, AsteropeAttrib)

FOREIGN KEY ElectraID REFERENCES Electra(ElectraID)

NOT NULL, ON DELETE RESTRICT

Celaeno (CelaenoID, CelaenoAttrib)

FOREIGN KEY CelaenoID REFERENCES Alcyone(AlcyoneID)

NOT NULL, ON DELETE CASCADE

Electra (ElectraID, ElectraAttrib)

Maia (MaiaID, MaiaAttrib)

FOREIGN KEY MaiaID REFERENCES Alcyone(AlcyoneID)

NOT NULL, ON DELETE CASCADE

Merope (MeropeID, AsteropeID, MeropeAttrib)

FOREIGN KEY AsteropeID REFERENCES Asterope(AsteropeID)

NOT NULL, ON DELETE CASCADE

Pleione (PleioneID, AsteropeID, AlcyoneID, PleioneAttrib)

FOREIGN KEY AsteropeID REFERENCES Asterope(AsteropeID)

NOT NULL, ON DELETE RESTRICT

FOREIGN KEY AlcyoneID REFERENCES Alcyone(AlcyoneID)

NOT NULL, ON DELETE RESTRICT

Taygete (TaygeteID, MaiaID, TaygeteAttrib)

FOREIGN KEY MaiaID REFERENCES Maia(MaiaID)

NULL ALLOWED, ON DELETE SET NULL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!