Scribd
Upload
34 views4 pages

DBMS Lab Assignment 2 Deep Patoliya

The document contains an assignment on DBMS Lab by Deep Patoliya, focusing on EER diagrams and their significance in representing complex databases. It explains concepts such as generalization, specialization, and aggregation, detailing how these can be converted into relational models. Additionally, it includes implementation questions related to drawing EER for a library management system and converting EER to relational models.

Uploaded by

Deep Patoliya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
34 views4 pages

DBMS Lab Assignment 2 Deep Patoliya

The document contains an assignment on DBMS Lab by Deep Patoliya, focusing on EER diagrams and their significance in representing complex databases. It explains concepts such as generalization, specialization, and aggregation, detailing how these can be converted into relational models. Additionally, it includes implementation questions related to drawing EER for a library management system and converting EER to relational models.

Uploaded by

Deep Patoliya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Name: Deep Patoliya

PRN: 19070122124
Class: CS - B3

DBMS LAB
ASSIGNMENT - 2

THEORY QUESTIONS:
Q.1 Explain the need of EER diagrams
Ans: The reasons are as follows:

  Represents requirements and complexities of complex databases. 


 It is a diagrammatic technique for displaying the Sub Class and Super Class;
Specialization and Generalization; Union or Category; Aggregation etc
 It defines an explained relationship between entities and its sub entities.
 EER is a high-level data model that incorporates the extensions to the original ER
model. Enhanced ERD are high level models that represent the requirements and
complexities of complex database.
 Represents relationship between a whole object and its component

Q.2 Explain in detail Generalization, specialization and Aggregation and how do we convert
them into relational model

Ans:
Generalization is a bottom-up approach in which two lower-level entities combine to form a
higher-level entity. In generalization, the higher-level entity can also combine with other
lower-level entity to make further higher-level entity.
Specialization is opposite to Generalization. It is a top-down approach in which one
higher level entity can be broken down into two lower-level entities. In specialization,
some higher-level entities may not have lower-level entity sets at all.

Aggregation is a process when relation between two entities is treated as a single entity.
Implementation Questions:
Q.1 Draw the EER for SIU library management and convert into relational model
Q.2 Convert following EER to relational model

You might also like