[Solved] Businessv Afolabi Ajagbe Yesterday
[Solved] Businessv Afolabi Ajagbe Yesterday
Week 6 Discussion – Logical and Physical Design
48 Unread replies48 Replies
In order to ensure optimal database performance, the logical and physical design should consider the user requirements thoroughly. Suppose you have been hired to transform a conceptual model into a logical model for a sales database.
- Describe the specific steps that you must perform in order to appropriately construct the database model.
- Speculate the risks that might present themselves for each step mentioned, and how you would avoid or mitigate those risks.
- Be sure to respond to at least one of your classmates’ posts.
reply to student below
Afolabi Ajagbe
Yesterday May 13 at 11:25am
Hello class,
When designing a database for optimal performance, there are three levels of data modeling: logical data modeling, conceptual data modeling, and physical data modeling.
The features needed in logical data modeling:
- Entity names.
- Foreign key.
- Primary key.
The features needed for conceptual data modeling:
- Entity relationships.
- Entity names.
The following steps can be used in the construction of the database model.
- Identify the entities: Identify entities such as events, people, and so on.
The risk: efficient identification of entities such as events, locations, and people has to occur.
- Identify relationships: check for relationships such as customers to sales, customers to shops, and many more.
The risk: it must be arranged in a definite order.
- Identify attributes: Check for attributes such as addresses, names, and so on.
- Define datatype for the attributes: Datatypes should be defined for the attributes that were identified.
- Normalization: Involving the 1NF, 2NF, and 3NF.
Capstone: Database modeling involves the following; domain, functionality, entities, relationships, and design.
RISKS TO AVOID;
- Avoid the analysis of the basic requirements.
- Users should be given specifications.
- Change should be examined in businessV
Afolabi Ajagbe
Yesterday May 13 at 11:25am
Hello class,
When designing a database for optimal performance, there are three levels of data modeling: logical data modeling, conceptual data modeling, and physical data modeling.
The features needed in logical data modeling:
- Entity names.
- Foreign key.
- Primary key.
The features needed for conceptual data modeling:
- Entity relationships.
- Entity names.
The following steps can be used in the construction of the database model.
- Identify the entities: Identify entities such as events, people, and so on.
The risk: efficient identification of entities such as events, locations, and people has to occur.
- Identify relationships: check for relationships such as customers to sales, customers to shops, and many more.
The risk: it must be arranged in a definite order.
- Identify attributes: Check for attributes such as addresses, names, and so on.
- Define datatype for the attributes: Datatypes should be defined for the attributes that were identified.
- Normalization: Involving the 1NF, 2NF, and 3NF.
Capstone: Database modeling involves the following; domain, functionality, entities, relationships, and design.
RISKS TO AVOID;
- Avoid the analysis of the basic requirements.
- Users should be given specifications.
- Change should be examined in business
Search entries or author Filter replies by unread
