Computer Science Homework Solutions
Problem
#194514

Identification of keys and ER model

Hi,

I need assistance to the enclosed problem please.

Regards,


1. Suppose that you are using the database composed of the two tables shown in Figure Q3.12.
a. Identify the primary keys.
b. Identify the foreign keys.
c. Draw the entity relationship model.

FIGURE Q3.12 The Ch03_Theater Database Tables

Attached file(s):
Attachments
Question-2.doc  View File
Solution
What is this?
By OTA - Overall OTA Rating
Anupama Vashisht, MSc - 5/5
Purchase Cost Now
$2.19 CAD (was ~$19.95)
Included in Download
  • Plain text response
  • Attached file(s):
    • Solution16.doc
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Database-entity integrity - Hi, I require assistance to the enclosed problem please. I need to draw the entity relationship diagram to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN. Regards,
  • Databases-ERD diagram requirement - Hi, I need assistance to the enclosed problem. Regards, Problem: Draw the entity relationship diagram for this database. Reference Figures: TABLE PRIMARY KEY FOREIGN KEY(S) TRUCK BA ...
  • Entity relationship diagram - Hi, I need assistance to the enclosed problem please. Regards, 1. Draw the entity relationship diagram for the relationship between EMPLOYEE and JOB. Employee EMP_CODE | EMP_LNAME | ...
  • Databases - Identification of super key and secondary key - Hi, I need assistance to the enclosed problem. Regards, 1) For each table, identify a superkey and a secondary key. TABLE SUPERKEY SECONDARY KEY TRUCK BASE TYPE Reference Figures ...
  • Databases - Identification of candidate key - Hi, I need assistance to the enclosed problem. Regards, Do the tables exhibit referential integrity? Answer Yes or No, and then explain your answer. Write NA (Not Applicable) if the table does ...
Browse