3

b. Show the INFORMIX SQL statement to insert a student with name ‘Leena’, age 23, (2) roll

no 102, email [email protected] who is expected to graduate in 2016, in the table created
in quesaon 7.9.

c. Write a note on RDF. (3)
8. a. Write a note on Object identifiers. (2)

b. Consider the ODMG diagram below and answer express the queries that follow (5) inOQL.
Assume that persistent names CS referring to computer science department and GRAD
referring to graduate studentsfrom mechanical departrnent exist.

ರಾ

1. |

FACULTY

GRAD STUDENT

On_Commitiee_of भ

i. Name and salary of faculty from CS departnent li. Advisors of
graduate students in Mechanical Departnent

c. What do you meant by well-formed and valid XML documents? (3)

9. a. Outline the methods in OODMBS make objects persistent. (3) 0. Consider the following
reladons: EMPLOYEE with attributes ENO, NAME, (4)

ADDRESS, DOB,AGE, SALARY, DNUM and DEPARTMENT with attributes DNO,
DNAME, DLOCATION, DPHONE, MGRENO. All the attributes are of pre-defined
basic types, which you may suitably assume. ENO and DNO are primary keys of
EMPLOYEE and DEPARTMENT. DNUM is a foreign key that identifies the
department to which an employee belongs. MGRENO is a foreign key identifying
the employee who manages the department.

Write required declarations in ORACLE to cormect these tables using object references.

6. Showe a sample XML file corresponding to the following DTD. Undeclared elements are (3)
PCDATA. The XML file should contain enough number of employee elements that demonstrate all
the possible combination of elements according to the DTD.

CTYPEemployees[

< | ELEMENT employees (employee+)>

ELEMENT employee (name, age, address, phonenos, email)> address
(houseno | (housename, streetname))>