Question: Write the following queries in SQL select statements. a) For each department, retrieve the departments name, the department managers name, the departments locations, and the

Write the following queries in SQL select statements.

a) For each department, retrieve the departments name, the department managers name, the departments locations, and the names of the projects controlled by the department.

b) Retrieve the number and name of each department that controls at least one project that is in the same location (Plocation) as the departments location (Dlocation). Write this query without using a quantifier, i.e., write using only joins.

c) Retrieve the number and name of each department that does not control any project that is in the same location (Plocation) as the departments location (Dlocation).

Write the following queries in SQL select statements. a) For each department,

Figure 5.7 Referential integrity constraints displayed on the COMPANY relational database schema EMPLOYEE Fname |Minit Lname SenBdate Address S ex SalarySuper ssn Dno DEPARTMENT Dname Dnumber Mgr ssn Mgr start date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pumber Plocation Dnum WORKS ON Essn Po Hours DEPENDENT Essn Dependent name Sex BdateRelationship

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 relational schema. An employee can work in more than one department; the pct_time field of the Works relation shows the percentage of time that a given employee works in a...

Consider the following relational schema. An employee can work in more than one department; also, the percentTime field of the Works relations shows the percentage of time that a given employee works...

Normal 1No Spac.. Heading1 Heading 2 Heading 4 Title Subtitle Subtle Em.... Emphasis Intense E...Stron Styles Consider the following relational schema. An employee can work in more than one...

Write the following queries in SQL. 1. Consider the following database schema describing students enrolled in sections of classes at a university. student (sid*, sname, sex, age, year, gpa) Year is a...

Task 2 (50 points): Consider the following relational schema. An employee can work in more than one department; also, the percentTime field of the Works relations shows the percentage of time that a...

Consider the following database schema (primary keys are bolded and underlined): Employees(elD; integer, eName: string, age: integer, salary: real) Works(elD: integer, dName: string, startedDate:...

Choose the following ethical dilemma to read and analyze, applying the American Counseling Associations (ACA) Decision-Making Model, and write a paper on it. A Practitioners Guide to Ethical Decision...

Harkness purchased a calculator from BBL Calculator Company on a sale or return basis on February1. No time for return was specified. On August 5, Harkness returned the calculator, claiming that he...

Which of the following are reasons corporations may issue preferred stock? Multiple select question. Preferred stock is less risky than debt. Preferred stock will always have greater tax advantages...

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...

Developing new accounts with leads generated by existing customers and relationships with media and industry associations as well as through cold calling, emailing, and online prospecting.

Finding and scheduling appointments with new prospective clients.

1. Did you work with quantitative data in your college courses or at a prior job? What did you do with the data?