Question: I need help with this database question 10.21 Answer the following questions based on the company logical database sehema EMPLOYEE Fname Minit Lname Bdate Address

I need help with this database question

10.21 Answer the following questions based on the company logical database sehema EMPLOYEE Fname Minit Lname Bdate Address SexSa Super ssnDno DEPARTMENT Mgr san Mar start date DEPT LOCATIONS PROJECT WORKS ON ena Hours DEPENDENT name Sex Bdate Relationship (a) Explain primary key constraint, and show an example based on the company database (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 ON B 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) Modify the query to list employees who work on any of the projects controlled by department number5 e)

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!

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 | Minit Lname Bdate Address Sex SalarySupersan Dno...

I need help writing the sql statment for number 1. Q.1J Answer the following questons baedon the company database schema shown belom EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary...

Need some help with this practice assignment, use the below images (Relational Model) to complete questions. Purpose: How to get familiar with the Relational Model basics. 1. (3.11 Elmasri-6e) -...

Part 2: DDL Instructions: Using the guidance and instructions given in the module download and install the appropriate version of PostgreSQL for your system. Familiarize yourself with the pgAdmin web...

Instructions: Using the guidance and instructions given in the module download and install the appropriate version of PostgreSQL for your system. Familiarize yourself with the pgAdmin web interface....

[Q.1] Answer the following questions based on company conceptual schema in ER diagram. 1. List regular entity types in the company conceptual schema. 2. List a weak entity type and its identifying...

oracle sql statement help. I will upvote a clear, detailed response. Thank you!! more joins (inner and outer), subqueries and other SQL issues You are suggested to adopt a user friendly prefix string...

Check below all the correct statements about the COMPANY database (schema and state) i n the file Assignment1_Figures.pdf 1. delete from EMPLOYEE where Lname= 'Smith' violates a foreign key...

Question 3 Design a generalization specialization hierarchy for a motor-vehicle sales company. The compuny sells motoreycles, passenger cars, vans, and buses. Assume that there are the two categories...

What special abuse does the AICPA address in its statement of position on the allocation of fund-raising costs? What general criteria does it establish as to when common costs of materials and...

After reading about economic predictions, Debbie Gibson (see Problem 8-16) has assigned the probability that the economy will be strong, average, and weak at 0.2, 0.35, and 0.45, respectively. (a)...

A machine costing $ 3 , 0 0 0 must be replaced at the end of 8 years. The resale value of the machine at the time of replacement is $ 6 0 0 . At what annual discount rate ( compounded annually )...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

A recent trend in the funeral home industry is for mortuaries to have websites from which friends and family members of the deceased can send e-mail or electronic greeting cards. The URL for the...

Teamwork. Brians Food Service is expanding its catering division. It needs an additional enclosed truck with a refrigeration unit; several propane ovens to keep food warm; and storage shelves and...

Technology. You have searched the Web and found several vendors who offer business promotional merchandise at unit prices your new business can afford. Each of the websites speaks of quantity...