MED ICT ICTED 525 Advanced Database Management System 2080

Subjective

Master / Education/2nd Semester

2080 (New Course)

Full Marks: 40

ICT.Ed.525 Advanced Database Management System

Time: 3 hrs.

Attempt all questions

Group "B"

1. Explain the process of EER to relational mapping with an example.

2. What is join in database management system? Explain different types of outer join with example.

OR

Consider the following table definitions and complete the questions below:

Sailors (sid: integer, sname: string, rating: integer, age: real)

Boats (bid: integer, bname: string, color: string)

Reserves(sid: integer, bid: integer, day: date)

a. Find all sailors with a rating above 7

b. Find the names of sailors 'Who have reserved boat number 103.

c. Find all sids of sailors who have a rating of 10 or reserved boat 104.

d. Find the names of sailors who have reserved boat 103

4

5. What do you mean by integrity constraint? Explain domain andreferential integrity.

6. Differentiate between attributes and elements in XML? List some of the important attributes used in specifying elements in XML schema.