BSc CS Sem 2 October 2023 October 2023 Database Systems Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Solve any four. 20 marks
   • a. What is Database? What are advantages of DBMS?
   • b. Write a short note on aggregate functions used in MySQL
   • c. State and explain types of attributes with their notation
   • d. State and explain types of levels of abstraction in database management system
   • e. Construct ER diagram for airline reservation system
   • f. What do you mean by primary key and foreign key constraint? Discuss with suitable
2. Q2 Solve any four. 20 marks
   • a. Write a short note on nested sub queries
   • b. Explain any 5 string operation with algebraic query
   • c. What do you mean by join? Explain left and outer join with suitable example
   • d. Explain math function with example
   • e. Explain following operations of relational algebra with algebraic query example
   • a) Projection b) Join
   • f. Explain relational constraints — 1) Null Constraint 2) Check Constraint
3. Q3 Solve any four. 20 marks
   • a. Explain security mechanism in detail
   • b. What is normalization? Explain its two types with example in detail
   • c. Write query for a) Granting Select privileges to a User in a table
   • b) Revoking more than privileges to a user in a table
   • c) Granting privilege to all users in table
   • d. What are different threads to the database?
   • e. Explain a) Creating view from single table
   • b) Creating view from multiple table
   • f. What are Privileges? Explain System privileges and Object Privileges
4. Q4 Solve any five. 15 marks
   • a. Write create table query for a) create table b)insert 3 records c) truncate table
   • b. Define following terms a)Simple Attribute b)Composite Attributes c) Multivalued Attribute
   • c. Explain following operations. A) Selection B) Projection operation
   • d. Explain union, intersection and cross product
   • e. What do you mean by functional dependency?
   • f. What are views? What are its types? Date: -06/10/2023 Total Marks: - 75 Time: -02.00 pm to 04.30 pm
5. Q1 Solve any four. 20 marks
   • a. What is Database? What are advantages of DBMS?
   • b. How do you backup and restore database in MySQL?
   • c. State and explain types of attributes with their notation
   • d. State and explain types of levels of abstraction in database management system
   • e. Construct ER diagram for library management system
   • f. Explain relational model
6. Q2 Solve any four. 20 marks
   • a. Write a short note on nested sub queries
   • b. Explain following string operation with algebraic query
   • c. What do you mean by join? Explain left and outer join with suitable example
   • d. Explain math function with example
   • e. Explain IN and Exists sub queries with example
   • f. Explain relational constraints — 1) Null Constraint 2) Check Constraint
7. Q3 Solve any four. 20 marks
   • a. Explain security mechanism in detail
   • b. What is normalization? Explain its two types with example in detail
   • c. What is process of Creating and Dropping user in MySQL?
   • d. What are different threads to the database?
   • e. What do you mean by privileges with respect to databases? How to grant and revoke
   • f. Explain any 5 Date function used in MySQL with example
8. Q4 Solve any five. 15 marks
   • a. Write create table query for student table insert 5 records and update | record
   • b. Define following terms a)Simple Attribute b)Composite Attributes c) Multivalue Attribute
   • c. Explain following operations. A) Selection B) Projection operation
   • d. Explain union, intersection and cross minus operation with example
   • e. What do you mean by functional dependency?
   • f. What are views? What are its types?

Read from the scan above, so a character or two may differ. The scan is the original.