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
Get step-by-step solutions from verified subject matter experts
