Vidyalelo
Database · Q29

Data Modeling with ER Model

Programming · Database · question 29

Q29

When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships.

A.
True
Answer
B.
False

Answer: Option A

Solution

Answer: Option A
Solution:
The answer is A: True.
Here's why:
Think of building a house:
1. First, you decide what rooms you need (entities) - like kitchen, bedroom, bathroom.
2. Then, you decide what each room will have (attributes) - like kitchen has a sink, stove, refrigerator. Bedroom has a bed, wardrobe.
3. Finally, you decide how the rooms connect (relationships) - like the kitchen is next to the dining room, the bedroom is upstairs.
Similarly, in database design:
* Entities are like the main objects you want to store information about (e.g., Customer, Product, Order).
* Attributes are the properties of those objects (e.g., Customer has Name, Address, Phone Number).
* Relationships show how these objects relate to each other (e.g., a Customer places an Order).
So, identifying entities, then attributes, then relationships is a fundamental and correct approach in database design using ER models.