Consider the database schema Emp = (ename, set of(Children), setof(Skills)) Children = (name, Birthday) Birthday = (day,

Question:

Consider the database schema Emp = (ename, set of(Children), setof(Skills)) Children = (name, Birthday) Birthday = (day, month, year) Skills = (type, set of(Exams)) Exams = (year, city) Assume that attributes of type set of(Children), set of(Skills), and setof(Exams), have attribute names ChildrenSet, SkillsSet, and ExamsSet, respectively. Suppose the database contains a relation emp (Emp).Write the following queries in SQL: 1999 (with the extensions described in this chapter).

a. Find the names of all employees who have a child who has a birthday in March.

b. Find those employees who took an examination for the skill type “typing” in the city “Dayton”.

c. List all skill types in the relation emp.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database System Concepts

ISBN: 978-0072554816

4th Edition

Authors: Henry F. Korth, S. Sudarshan

Question Posted: