0
956views
Database Management Systems Question Paper - Dec 18 - Information Technology (Semester 3) - Mumbai University (MU)
1 Answer
0
4views

Database Management Systems - Dec 18

Information Technology (Semester 3)

Total marks: 80
Total time: 3 Hours
INSTRUCTIONS
(1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Draw neat diagrams wherever necessary.

1.a. Justify the term data independence.
(5 marks) 00

1.b. Explain weak entity with example.
(5 marks) 00

1.c. Explain programming with JDBC.
(5 marks) 00

1.d. List aggregate functions and justify the need of any two aggregate functions.
(5 marks) 00

2.a. With reference to figure-1 list and explain the attributes, keys, relationship types.
(10 marks) 00

2.b. Explain illustrate relational algebra with example.
(10 marks) 00

3.a. Explain functions and procedures in SQL with suitable example.
(10 marks) 00

3.b. Illustrate sparse and dense indexing with suitable example.
(10 marks) 00

4.a. Describe /list the steps/rules of ER-to-relational mapping and use the same to map the ER diagram shown in figure-1 to relational database schema.
(10 marks) 00

4.b. Use the relational database schema of Qu-4 a) and write the following queries.

  1. Retrieve the birth date and address of the employee(s) whose name is 'Vaidehi Chavan'.
  2. Retrieve the name and address of all employees who work for the 'Research' department.
  3. For every project located in 'Mumbai', list the project number, the controlling department number, and the department manager's last name, address, and birth date.
  4. Retrieve a list of employees and the projects they are working on, ordered by department and, within each department, ordered alphabetically by last name, first name.

(10 marks) 00

5.a. Explain event condition action (ECA) model with suitable example.
(10 marks) 00

5.b. Illustrate the need of normalisation? Explain all forms with an example.
(10 marks) 00

Attempt the following.

6.a. Functional Dependencies.
(5 marks) 00

6.b. Operation on files.
(5 marks) 00

6.c. Foreign key.
(5 marks) 00

6.d. Views in SQL.
(5 marks) 00

enter image description here

Please log in to add an answer.