Question: Specify Primary Key for each table below, also specify foreign keys, if any. For each foreign key, please indicate that foreign key references to which

Specify Primary Key for each table below, also specify foreign keys,

Specify Primary Key for each table below, also specify foreign keys, if any. For each foreign key, please indicate that foreign key references to which table.

210 Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Fname Minit Lname San Bdate Address Sex Salary Super_ssn Dno John B Smith 1234567891965-01-09 731 Fondren, Houston, TX M 30000 333445555 Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 Alicia Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX 25000 987654321 Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX 43000 888665555 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 Joyce English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TXM 25000 987654321 James E Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL 1 F F 4 5 5 4 Dnumber DEPARTMENT Dname Research Administration Headquarters 5 Mgr_ssn 333445555 987654321 Mgr_start_date 1988-05-22 1995-01-01 1981-06-19 4 DEPT LOCATIONS Dnumber Dlocation 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston 1 888665555 WORKS ON Essn 123456789 123456789 Pro 1 Hours 32.5 7.5 Dnum 5 5 | Ono 2 PROJECT Pname ProductX Product Productz Computerization Reorganization Newbenefits 3 40.0 Pnumber Plocation 1 Bellaire 2 Sugarland 3 Houston 10 Stafford 20 Houston 30 Stafford 5 1 20.0 666884444 453453453 453453453 333445555 4 2 20.0 1 2 10.0 4 3 333445555 333445555 10 DEPENDENT Essn 333445555 10.0 10.0 10.0 30.0 10.0 20 999887777 30 Dependent name Sex Alice F Theodore Joy 999887777 333445555 333445555 10 M Bdate Relationship 1986-04-05 Daughter 1983-10-25 Son 1958-05-03 Spouse 1942-02-28 Spouse 1988-01-04 Son 10 35.0 333445555 F 987987987 907987907 30 5.0 987654321 Abner M 30 20.0 123456789 Michael M 987654321 987654321 20 15.0 123456789 Alice F 1988-12-30 1967-05-05 Daughter Spouse 888665555 20 NULL 123456789 Elizabeth F

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 Databases Questions!

Specify Primary Key for each table below, also specify foreign keys, if any. For each foreign key, please indicate that foreign key references to which table. S SNO SNAME STATUS CITY SPJ SNO PNO JNO...

CIT 170 Database Project After reading through this entire document, please watch the video on Project Design Hints. The video has additional information to assist you with your design phase. You are...

1) Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in the metadata of Assignment 1. You may need to use a combination of DROP TABLE, CREATE TABLE, and...

Consider the following relational schema: Student(stdNo, firstName, lastName, eMail) Course(code, name, credits) WhenOffered(course, semester, year, examiner) Staff(staffID, name, birth-date,...

PROJECT ONE Project One is due Monday, March 13th, 2023. For Project One I want you all to come up with a unique database (that you created). The database must have at least three tables. Do not just...

Baking business Please help Simple Database You will be designing a simple database for a small business as a team. You will not be creating a database to serve the entire business; but rather a...

Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in the metadata of Assignment 1. You may need to use a combination of DROP TABLE, CREATE TABLE, and ALTER...

Database Design: (Please make a hospital database with a conceptual schema that is an ER/EER model) Instructions: Please give all the relations (tables) in the database being designed for your own...

Can you please format the answers like the example below: This is the book we use Fundamentals of Database Systems (Subseription) Shamkant B. Navathe, Ramez Elms This is the eBook of the prin codes,...

Problem 3 (Parts a-b are 3 points each, c-fare 4 points each; 22 points total) Here are some more challenging problems to try against the banking database. a) Generate a list of all cities that...

A constant horizontal force F is applied to a lawn roller in the form of a uniform solid cylinder of radius R and mass M (Fig. P10.78). If the roller rolls without slipping on the horizontal surface,...

Classic Windows is involved in a research and development project to create a filtering window that removes the need for curtains. For the current year ended 30 June 2021 expenditure on the project...

what could point to a problem with a company's financial management

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

3. Visit the Web site www.careerjournal.com. This Wall Street Journal Web site has articles related to career issues. a. Click on the tab titled Career Strategies. Choose an article to read. b. Write...

4. Several Web sites provide guidance to working and nonworking parents: www .en-parent.com (for the entrepreneurial parent), www.wahm.com (for work-at-home moms), and www.AtHomeDad.com for...

10. What are the advantages and potential disadvantages of telecommuting for employees? For companies?