Question: can you please do this (37 points) Q1 A. Consider the following ER diagram. Write SQL statements to create the corresponding tables and capture as

can you please do this can you please do this (37 points) Q1 A. Consider the following ER diagram. Write SQL statements to create the corresponding tables and

(37 points) Q1 A. Consider the following ER diagram. Write SQL statements to create the corresponding tables and capture as many of the constraints as possible (create 2 tables only). name date ssn pid sponsor age mployee Work Project B. Assume we have the following instances for two tables Employee and Project: Project Employee pio 100 102 sponsor Computer Science Biolo Ssn name 5380 Guldu 5381Ali 5382 Jil age 30 32 27 Assume Jill and Ali work on project 100. What will be the new instances of the tables Employee and Project after running the following query? DELETE FROM Project P WHERE P.pid-'100 (35 points) Q2. Consider the following relations Student(sid: integer, sname: string, major: string, level: string, age: integer) Class(cname: string, meets at: string, room: string, fid: integer) Enrolled(sid: integer, cname: string) Faculty(fid: integer, fname: string, deptid: integer)

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!

. Consider the following ER diagram. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible. name ssn s cost Policy uyyih pname age Employee...

(30 points) Q1. A. Consider the following ER diagram. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible name ssn cost pname age Employee...

Consider the following E-R diagram, write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If cannot capture some constraints, explain why....

A. Consider the following ER diagram. Write SQL statements to create the corresponding tables and capture as many of the constraints as possible (create 2 tables only). name ssn date pid sponsor)...

A. Consider the following ER diagram. Write SQL statements to create the corresponding tables and capture as many of the constraints as possible (create 2 tables only) name date ssn pid sponsor age...

ddzess Credit card Typ Consider the above E-R diagram, write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If cannot capture some...

Consider the above E-R diagram, write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If cannot capture some constraints, explain why. Make...

Consider the Prescriptions-R-X ER diagram. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible. Assume that, if a Doctor Prescribes the same...

As the media landscape continues to change, and advertisers shift more and more of their monies into new media, there are those who predict that some traditional media like TV and newspapers may not...

Fergusons employees earn a total of $30,000 per week for a 5-day week. December 31 of Year 1 is a Tuesday. a.) Prepare the journal entry to record accrued salaries on December 31, Year 1. b.) Prepare...

6. The general ledger organizes accounting information in: a. account order. b. alphabetical order. c. random order. d. chronological order.

Intro Southwest Airlines just bought a new jet for $30,000,000. The jet falls into the 7-year MACRS category, with the following depreciation rates (half-year convention): Year 1 2 3 4 5 6 7 8 Depr....

The small company for which you work manufactures and sells camping equipment. Recently, the companys management team decided to expand its sales efforts to include e-commerce. Barbara Kramer, the...

Youre interested in learning what type of backpack is most popular among students on your campus. (Objectives 2, 3, and 6) a. Outline your data-gathering plan and share it with the class. b. Using...

Teamwork. Form teams of no more than five people. Each team will select an important current issue or problem on the campus. As directed by your instructor, do one or more of the following...