BSc IT Sem I 2022 2023 2023 FUNDAMENTAL OF DATABASE MANAGEMENT SYSTEMS Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt any three. (15M)
   • a. Write a short note on relational model
   • b. Explain the various functions of database administrator
   • c. Explain the following with example:
   • i. Super key
   • v. Foreign key
   • d. Write a short note on storage manager component of database system
   • e. Explain the following relational algebra with example:
   • i. Projection
   • f. Explain 2-tier database architecture
2. Q2 Attempt any three. (15M)
   • a. Define the following with respect to ER model:
   • a. Entity
   • b. Attributes
   • c. Relationship
   • d. Entity type
   • e. Role name
   • b. Explain various types of attributes with suitable example
   • c. Explain the concept of Generalization with example
   • d. State and explain Codd’s 12 rules
   • e. Explain various types of cardinalities with proper example
   • f. A college database needs to store information about students (identified by stud_id, with stud_nm, stud_add and phone as attributes), instructors (identified by with inst_nm and dept as attributes), and course (identified by course_id, with course_nm and credits as attributes). Students enrolls for the course; an instructor manages each student; each instructor is the member of the course. Draw an ER
3. Q3 Attempt any three. (15M)
   • a. Explain lossless join dependency, b, What is normalization? Explain
   • c. What is the need for normalization?
   • d. Explain lossy join dependency
   • e. Explain functional dependency in normalization {. Ihe company has several regular customers. Company makes some products Customer places order for the products and the particular order is fulfilled by the company. Consider the un-normalized data given in the table, normalize the data using INF and explain the same VCD/ SEM-I DBMS 75 MARKS 2%HRS cust_add | description order_no
4. Q4 Attempt any three. (15M)
   • a. Solve the queries based on following table:
   • i. Create table Customer with proper constraints
   • ii. Display details of customers living in city Mumbai, Hyderabad or Jaipur
   • iii. Find out total number of customers in each city
   • iv. Display customer whose name has ‘e’ as second letter
   • v. column ‘Salary’ of type integer to customer table
   • b. Explain various datatypes used in SQL
   • c. What is trigger? Create a trigger on Customer table, when an update is made on Salary of customers living in Assam and Delhi
   • d. Solve the queries based on following tables :
   • i. Create table Book with proper constraints
   • ii. Create check constraint on Book table where price should not be below 250
   • iii. Find out the book written by ‘James Groff and published by ‘Microsoft
   • iv. the average price of all books published by ‘Himalaya’
   • v. Delete all records of author
   • e. Write a short note on Views
   • f. What is indexing? Explain its types. Explain creating and removing indexing
5. Q5 Attempt any three. (15M)
   • a. What is transaction? Explain ACID properties of transaction
   • b. Explain the concept of conflict serializability
   • c. Explain states of transaction
   • d. What is deadlock? Explain deadlock recovery
   • e. Explain shadow copy technique
   • f. Explain the Write-Ahead Log Protocol

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