Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose you are using the database composed of the two tables shown in Figure 1 . Table Name: Director DIR _ NUM DIR _ LNAME

Suppose you are using the database composed of the two tables shown in Figure 1. Table Name: Director DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65101 Hollywoody 18-Nov-53102 Goofy 21-Jun-62 Table Name: Play PLAY_CODE PLAY_NAME 1001 Cat On a Cold, Bare Roof 1002 Hold the Mayo, Pass the Bread 1003 I Never Promised You Coffee 1004 Silly Putty Goes To Washington 1005 See No Sound, Hear No Sight 1006 Starstruck in Biloxi 1007 Stranger In Parrot Ice Figure 1 Data tables DIR_NUM 102101102100101102101 Question A: Identify the primary keys. Question B: Identify the foreign keys. Question C: Create the entity relationship model.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Internals A Deep Dive Into How Distributed Data Systems Work

Authors: Alex Petrov

1st Edition

1492040347, 978-1492040347

More Books

Students also viewed these Databases questions

Question

To realize business outcomes before and after HRM adoption.

Answered: 1 week ago