Untitled

Consider the relational schema shown in below Figure.

employee(person_name, street, city)

works(person_name, company_name, salary)
company(company_name, city)
manages(person_name,manager_name)
Give a schema definition in SQLcorresponding to the 
relational schema, but using references to express foreign￾key relationships.
3 3 1 1,2
2. Give the DTD for an XML representation of the following 
nested-relational schema:
Emp = (ename, ChildrenSetsetof(Children), 
SkillsSetsetof(Skills))
Children = (name, Birthday)
Birthday = (day, month, year)
Skills = (type, ExamsSetsetof(Exams))
Exams = (year, city)