Chat with us, powered by LiveChat Jamie2.docx - STUDENT SOLUTION USA

13 hours ago

Jamie Cabbagestalk

RE: Week 6 Discussion

Top of Form

1. Primary Keys

2. Logical Database model which entails the characteristics and subjects

3. Conceptual Database model which entails information regarding the relationships associated with the entities and their attributes

4. Normalize the database

When constructing a database model one needs to create a table for unique identifiers. A data model design needs to be created prior to its creation. One needs to establish the purpose of the model in order to design an efficient data model. After establishing a purpose, the entities/objects of that model should be identified. Once that process is complete, attributes can be connected to their corresponding entities within the model. At this point, one can then form relationships such as one-to-one, one-to-many, and many-to-many to list a few. An example of one-to-many, a person who goes shopping at a mall, and that one person make multiple transactions. After this point, one can normalize the database.

Each of these steps is subject to risk. If one does not have a thorough understanding of the purpose of the data model, then the design of the model may not have the components that the data model needs. This may cause the data model to become insufficient for that person or business. The next risk is one not properly defining what the entities are and their attributes. These factors wican cause incorrect relationshipsnto be made. The final risk is one failing to normalize the database, this may cause the database to become harder to modify. To mitigate these issues one should thoroughly define all components of the diagram,and research the purpose and needs for the diagram before designing the diagram model. Also in efforts to mitigate possible risk, it is important that one check the attributes and relationships that are made for any possible errors. Finally, one needs to ensure that he/she normalizes the data model.

Yasar, Kinza.October 2022.Primary Keyword.

Bottom of Form

error: Content is protected !!