to be maintained as a nested table of course details. For each course, the following details are to be
cno, cname, credits all of which are

simple attributes.

You may assume suitable types for all the simple attributes.


song language CDATA# REQUIRED>

a. Consider the following the relations: FACULTY relation with attributes FNO, (7)
NAME DOB, SALARY, DINUM and DEPARTMENT relation with attributes
DNO, DNAME, DLOCATION, HOD. All attributes are predefined basic types,
which you may suitably assume. FNO and DNO are the primary keys of
FACULTY and DEPARTMENT relations. DNUM is a foreign key that identifies
the deparhnent to which an faculty belongs. HOD is a foreign key identifying the
faculty who is acting as the Elead of Department. Write required declarations in
ORACLE to connect these tables using object references.

b. How do structured, semi-structured and unstructured data differ? (3)

a. Identify the any Ovo different DTDs that can match the following XML (3)
document: SA?xyz<

b. Use the DTD below to answer the following queries. Assume that all undeclared(7)
elements are of type PCDATA:
i) Names of English or Malayalam songs (use XPath) 11) Names of
songs by a singers who sang in the year 2018 (use XPath) iii) List
names of songs and corresponding langages (use XQuery)