Show, by giving a DTD, how to represent the non-1NF books relation from Section 29.1, using XML. Consider the schema: Emp = (ename, ChildrenSet setof(Children), SkillsSet setof(Skills)) Children =...



Show, by giving a DTD, how to represent the non-1NF books relation from


Section 29.1, using XML.



Consider the schema:


Emp = (ename, ChildrenSet setof(Children), SkillsSet setof(Skills))


Children = (name, Birthday)


Birthday = (day, month, year)


Skills = (type, ExamsSet setof(Exams))


Exams = (year, city)


Write the following queries in XQuery:


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



May 19, 2022
SOLUTION.PDF

Get Answer To This Question

Submit New Assignment

Copy and Paste Your Assignment Here