Answer to Question #306065 in Programming & Computer Science for Christine

Question

1. What two concepts are ER modelling based on?

2. The database in Figure 8.11 is composed of two tables. Use this figure to answer questions

DIRECTOR

DIRNUM

100

101

102

DIRNAME

J.Broadway

J.Namath

W.Blake

DIRDOB

01/08/39

11/12/48

06/15/44

PLAY

PLAYNO

1001

1002

1003

1004

1005

1006

1007

PLAYNAME

Cat on a cold bare roof

Hold the mayo, pass the bread

I never promised you coffee

Silly putty goes to Texas

See no sound, hear no sight

Starstruck in Biloxi

Stranger in parrot ice

DIRNUM

102

101

102

100

101

102

101

Figure 8.11. Director and Play tables for question 2, by A. Wott.

2.1 Identify the primary key for each table. 2.2 Identify the foreign key in the PLAY table.

2.3 Identify the candidate keys in both tables.

2.4 Draw the ER model.

2.5 Does the PLAY table exhibit referential integrity? Why or why not?

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order