Question: 1. Given the following relations and referential integrity rules, draw an ER diagram on the following blank page. Make assumptions where necessary but be sure

1. Given the following relations and referential

1. Given the following relations and referential integrity rules, draw an ER diagram on the following blank page. Make assumptions where necessary but be sure to list any assumptions made. Show each assumption with a capital A inside a circle. Assumptions cannot be made in contradiction to the given relations and foreign key constraints. (Primary keys are underlined, foreign keys are bold). ENTITY1(e1pk, elnkal, elnka2) ENTITY2e2pk, e2nkal, e2nka2, elpk) Foreign Key elpk references ENTITY1(e1pk) Not Null On Delete Restrict ENTITY3(e1pk e4pk, e3nkal) Foreign Key elpk references ENTITY1(e1pk) Not Null On Delete Restrict Foreign Key e4pk references ENTITY4(e4pk) Not Null On Delete Restrict ENTITY4e4pk, e4nkal, e4nka2) ENTITYS(e5pk, enka1) Foreign Key eSpk references ENTITY4(e4pk) Not Null On Delete Cascade ENTITY6(e6pk, enkal) Foreign Key e Epk references ENTITY4(e4pk) Not Null, On Delete Cascade ENTITY7(e7pk, e7nkai, e5pk) Foreign Key eSpk references ENTITYS(e5pk) Null Allowed, On Delete Restrict 1. Given the following relations and referential integrity rules, draw an ER diagram on the following blank page. Make assumptions where necessary but be sure to list any assumptions made. Show each assumption with a capital A inside a circle. Assumptions cannot be made in contradiction to the given relations and foreign key constraints. (Primary keys are underlined, foreign keys are bold). ENTITY1(e1pk, elnkal, elnka2) ENTITY2e2pk, e2nkal, e2nka2, elpk) Foreign Key elpk references ENTITY1(e1pk) Not Null On Delete Restrict ENTITY3(e1pk e4pk, e3nkal) Foreign Key elpk references ENTITY1(e1pk) Not Null On Delete Restrict Foreign Key e4pk references ENTITY4(e4pk) Not Null On Delete Restrict ENTITY4e4pk, e4nkal, e4nka2) ENTITYS(e5pk, enka1) Foreign Key eSpk references ENTITY4(e4pk) Not Null On Delete Cascade ENTITY6(e6pk, enkal) Foreign Key e Epk references ENTITY4(e4pk) Not Null, On Delete Cascade ENTITY7(e7pk, e7nkai, e5pk) Foreign Key eSpk references ENTITYS(e5pk) Null Allowed, On Delete Restrict

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!

Q:

1. Given the following relations and referential integrity rules, draw an ER diagram on the following blank page. Make assumptions where necessary but be sure to list any assumptions made. Show each...

Q:

Given the following relations and referential integrity rules, draw an ER diagram on the following blank page. Make assumptions where necessary but be sure to list any assumptions made. Show each...

Q:

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...

Q:

Submission Guidelines Prepare the list of entities and their corresponding attributes in Word, and draw the E-R diagram in Visio. Description of Homework For the problem below, List all necessary...

Q:

Submission Guidelines Prepare the list of entities and their corresponding attributes in Word, and draw the E-R diagram in Visio. Description of Homework For the problem below, List all necessary...

Q:

Submission Guidelines Prepare the list of entities and their corresponding attributes in Word, and draw the E-R diagram in Visio. Description of Homework For the problem below, List all necessary...

Q:

Submission Guidelines Prepare the list of entities and their corresponding attributes in Word, and draw the E-R diagram in Visio. Description of Homework For the problem below, List all necessary...

Q:

Submission Guidelines Prepare the list of entities and their corresponding attributes in Word, and draw the E-R diagram in Visio. Description of Homework For the problem below, List all necessary...

Q:

Submission Guidelines Prepare the list of entities and their corresponding attributes in Word, and draw the E-R diagram in Visio. Description of Homework For the problem below, List all necessary...

Q:

This is my college Database coursework. I have a problem regarding making the erd diagrams and normalization(UNF, 1NF, 2NF, 3NF). I hope you would help me in making this along with the final erd...

Q:

Odysseus is quite different from the "epic" heroes that predate him -- the Sumerian Gilgamesh or even the Greek Achilles, for example -- he is not all muscles and no brain, and he is fully human on...

Q:

Using the parameters for the U.S.-ROW sugar model detailed in Section 7 .2, create a figure that plots U.S. social welfare on the vertical axis against the tariff level on the horizontal axis. Using...

Q:

he primary difference between a financial forecast and a financial projection is the nature of the assumptions used to generate the reports. the level of auditor involvement. the extent of the...

Q:

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...