Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with a, b, c in Databases question. 10.21 Answer the following questions based on the company logical database sehema EMPLOYEE Fname |

I need help with a, b, c in Databases question. image text in transcribed
10.21 Answer the following questions based on the company logical database sehema EMPLOYEE Fname | Minit Lname Bdate Address Sex SalarySupersan Dno DEPARTMENT Mgr san Mar start date DEPT LOCATIONS PROJECT Dnum WORKS ON Hours DEPENDENT ent came SexBdate Relationship (a) Explain primary key constraint, and show an example based on the company database schema (b) Explain entity integrity constraint, and show an example based on the company database schema (c) Explain referential integrity constraint, and show two examples based on the company database schema. Explain the following query in English (based on company database) SELECT FNAME, LNAME, SSN FROM EMPLOYEE WHERE NOT EXISTS (SELECT FROM WORKS ONB WHERE (B.PNO IN (SELECT PNUMBER FROM PROJECT WHERE DNUMBER-5) AND NOT EXISTS (SELECT FROM WORKS ON c WHERE C.ESSN-SSN AND C.PNO B.PNO) )Modity the query to list employees who work on any of the projects controlled by department number5

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

Pro SQL Server Wait Statistics

Authors: Enrico Van De Laar

1st Edition

1484211391, 9781484211397

More Books

Students also viewed these Databases questions

Question

Why would unions target health care workers?

Answered: 1 week ago