What are business rules ? Why are they important to a database designer? 2.what is the data dictionary's function in database design? 3. What steps are required in the development of an ER diagram?
1. What are business rules ? Why are they important to a
2.what is the data dictionary's function in database design?
3. What steps are required in the development of an ER diagram?
4. What factors are important in DBMS software selection?
8. List briefly explain four steps performed during the logical design stage.
The given questions are related to database designing which includes the business rules, entity relationships, data dictionary, logical and physical constraints.
**As per our company guidelines we are supposed to answer only the first 3 sub-parts, Kindly repost next parts in next question.
Introduction:
A business rule in the database design is a written constraint that is required to be applied in the database to make sure the specific requirement are implemented correctly in the database.
These are generally the simple English like sentences which include one or more entities and then the relationship rule between that OR a single entity and a constraint on an attribute in the entity.
Importance:
The business rules are important as these make sure that:
1. Each entity is considered in the design.
2. The relationship is mentioned for each entity.
3. This Shows how the entities are connected with each other.
4. all database facts to be stored are listed in the rules.
Example:
Consider the example of a donation company that needs to store the donations, donors. The database will have below business rules:
1. Donor will be stored based on a unique ID.
2. Donations will be stored based on a unique ID.
3. Each donor will make atleast one donation but can have many donations.
4. A donation wil be made by exactly one Donor.
5. Donation will not exist without a donor.
Step by step
Solved in 4 steps
