0% found this document useful (0 votes)
75 views2 pages

Assignment For DBMS 4 Semester CSE - A Rules

This document outlines an assignment for a database management systems course. It provides 10 questions on topics related to DBMS including traditional file processing systems, data modeling, database design, concurrency control, recovery, and distributed databases. Students are instructed to answer the questions in a 25+ page handwritten assignment submitted by a deadline while following formatting guidelines.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
75 views2 pages

Assignment For DBMS 4 Semester CSE - A Rules

This document outlines an assignment for a database management systems course. It provides 10 questions on topics related to DBMS including traditional file processing systems, data modeling, database design, concurrency control, recovery, and distributed databases. Students are instructed to answer the questions in a 25+ page handwritten assignment submitted by a deadline while following formatting guidelines.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Assignment for DBMS

4th Semester CSE – A

Rules:
1. Must be handwritten on standard A4 paper using color pens as needed (25 Pages minimum)
2. Cover page with Name, Roll Number, SIC Number must be there
3. Diagrams should be neatly drawn and properly labeled
4. Assignment must be submitted in hard copy form latest by 30/06/2022
5. The style of writing, additional study/research and information from different books, clarity of
writing, and efforts given in writing the assignment shall determine the marks.
6. If two assignments are found to be same, then the marks will be shared.

Questions:
1. What is a traditional file processing system? What are its disadvantages?

2. Write Short Notes on:


a. Data Abstraction and 3-Schema Architecture
b. Database Languages
c. Database Users
d. Database Constraints
e. Roles of DBA

3. An automobile showroom deals with cars manufactured by different manufacturers like Maruti,
Hyundai, Mahindra etc. They need to record manufacturer, model, car-type
(hatchback/sedan/suv/muv) fuel-type (diesel/petrol/CNG), year of mfr, Engine Power, Color,
No. of Airbags, Tyre size, Seating Capacity, etc., for each car. Every car is sold to one customer
by a sales person (an employee). They want to store customer’s details in the database. For
each sale, the date of sale, base price, tax applied, cost of accessories, discount etc. must be
stored. There are various other employees such as front-desk, mechanics, supervisor, manager
etc. in the showroom. Employee details including salary, designation, date of joining etc. are to
be recorded. Customers come to the showroom to get their cars serviced, for which they first
book a date & time, and then their car is serviced by a mechanic. The details of works done,
spare parts used for each service, and labor charges etc. are to be recorded. Design the
database of the showroom and prepare its ER Diagram. Then convert the ER Diagram into
Relational Model.

4. Write an essay on Functional Dependency and Normalization with suitable examples.


5. Describe Lock-based Concurrency Control mechanism and its side effects.

6. Describe the different approaches of deadlock prevention.

7. The following key values are inserted in this order: 8, 6, 5, 3, 12, 9, 2, 7, 11, 4, 10. Construct the
following in step-by-step manner:
a. B-Tree
b. B+ Tree

8. Describe the Log-based Recovery mechanism in detail. What is a Checkpoint and how does it
help during the recovery process.

9. Write notes on the following:


a. Multi-valued Dependency
b. Inference Rules for FD and MVD
c. Conflict Serializability & View Serializability
d. Timestamp-based Ordering Protocol
e. Wait-Die and Wound-Wait scheme for Deadlock Prevention

10. Describe the different types of Fragmentation used for Distributed Databases.

-------------- XXXX ------------

You might also like