Bsc CSIT Semester 4 – Database Management System – Unit 3: Data Modeling Using the Entity-Relational Model (6 Hrs.)

What is difference between Entities and Entity sets? Explain with example.

What are the components of ER diagram? Explain the function of various symbols use in ER diagram. Construct an ER diagram to store data in a library of your college.

Explain Relationship and Relationship sets with example.

What is entities and its types? How do we reduce different types of entities and relationships of ER diagram into Tables? Explain with assuming different types of entities and relations.

Explain aggregation with example.

What is conceptual data model? Explain different types of attributes used in ER diagram.

What do you mean by entity type and entity set? Construct an ER diagram for an airline ticket booking system where customers buy airline tickets online. The system should provide discounts on the basis of number of tickets bought. It should also keep records of buyers on the basis of number of times buyer visits the system. It should also filter the unwanted visitors to manage traffic congestion.