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

Question 1

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

Marks: 5

Year: 2076 Final TU

Difference between Entities and Entity Sets In the context of the Entity–Relationship (ER) Model) in DBMS, the terms Entity and Entity Set are closely related but have different meanings. --- Entity

Question 2

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.

Marks: 10

Year: 2078 Final TU

1. Components of an ER Diagram An Entity–Relationship (ER) diagram represents the logical structure of a database. The main components are: | Component | Description | |-----------|--------------| | E

Question 3

Explain Relationship and Relationship sets with example.

Marks: 5

Year: 2078 Final TU

1. Relationship A Relationship in an Entity–Relationship (ER) model is an association or link between two or more entities. It shows how entities are related to each other in a database. - A relatio

Question 4

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.

Marks: 10

Year: 2079 Final TU

1. Entities Definition: An entity is any real-world object, concept, or thing that has a distinct existence and can be uniquely identified in the database. Example: - Student(StudentID, Name, DOB)

Question 5

Explain aggregation with example.

Marks: 5

Year: 2079 Final TU

1. Definition Aggregation in DBMS is a concept used in ER modeling to represent a relationship between a relationship set and an entity set. - It is used when a relationship itself has attributes or

Question 6

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

Marks: 5

Year: 2080 Final TU

1. Conceptual Data Model Definition: A conceptual data model is a high-level representation of the database that shows what data is stored, relationships among data, and constraints, independent of

Question 7

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 basi

Marks: 10

Year: 2081 Final TU

1. Entities and Attributes Customer - CustomerID (PK), Name, Email, VisitCount, Status Ticket - TicketID (PK), FlightNo, Price, Discount, PurchaseDate Flight - FlightNo (PK), Source, Destina