Assignment For DBMS 4 Semester CSE - A Rules
Assignment For DBMS 4 Semester CSE - A Rules
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?
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.
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.
10. Describe the different types of Fragmentation used for Distributed Databases.