Database Management System (DBMS) — Winter 2024

What is Generalization? Discuss super class and sub class with an example.

What is Cardinality ratio? Explain each type of cardinality relation with an example of each.

Define and discuss primary key and foreign keys with an example.

What is attribute of an entity? Discuss different types of attributes in brief.

What is Normalization? Discuss 3rd NF in brief.

Discuss Super key and Candidate key keys with an example.

What is Referential integrity? Explain it with an example.

Identify the following functional dependencies for relation Ris in which normal form. If it is not in 3rd NF, then normalize it to 3rd NF. R (A, B, C, D, E, F) ABC -> D ABD -> E CD -> F CDF -> B BF -> D Page 1 of

CASE STUDY: Library Management System Introduction: Alibrary management system (LMS) is a crucial component of any educational institution or community space. It helps in efficiently managing library resources, tracking borrowing and returning of books, and providing various services to patrons. Consider the case of a university library implementing an LMS to streamline its operations. Scenario: The university library, with a vast collection of books, periodicals, and digital resources, decides to upgrade its manual system to a computerized library management system. The system aims to automate processes such as book circulation, cataloging, and inventory management. Additionally, it should provide users with online access to the library catalog and facilitate reservations and renewals. Functional Requirements: 1. User Management: The system should allow librarians to add, delete, and update user information, including students, faculty, and staff. Each user should have a unique identifier and borrowing privileges based on their membership type. 2. Catalog Management: Librarians should be able to add new books to the catalog, update existing entries, and remove obsolete ones. Each book entry should include details such as title, author, ISBN, publication year, genre, and availability status. 3. Circulation Management: The system should facilitate the borrowing and returning of books by users. It should maintain a record of borrowed books, due dates, and fine calculations for overdue items. Users should be able to check their borrowing history and renew items online if they are not overdue. 4. Search and Reservation: Users should be able to search the library catalog by title, author, genre, or ISBN. They should also be able to reserve available books online and receive notifications when the reserved items are ready for pickup.

Explain the importance of a database management system (DBMS) in the context of a library management system. How does a DBMS facilitate efficient data storage, retrieval, and manipulation for library operations?

Discuss the normalization process in the design of the library database schema. Identify and explain at least two normalization forms applicable to the library management system case study.

Draw an ER diagram for the school management system.

Convert the ER-Diagram into relational model and prepare data- dictionary for Library management system. Page 2 of