CIS 515: Strategic Planning for Database Systems : Database Modeling and Normalization
Study of strategic database planning, modeling, and normalization.
Michael Davis
Contributor
4.2
46
about 1 month ago
Preview (4 of 12)
Sign in to access the full document!
DATABASE MODELING AND NORMALIZATION 1
Database Modeling and Normalization
Name:
Prof:
CIS 515: Strategic Planning for Database Systems
Date:
Explain the process of developing an effective Entity Relationship Model (ERM) for a
personnel database, including key components such as entities, relationships, attributes, and
constraints. Discuss the iterative steps required for its development, the potential risks associated
with not following these steps, and the importance of time-variant data for policy enforcement
and training management. Additionally, explain the normalization process to ensure the database
is in 3NF, and illustrate the five entities necessary for sustaining the personnel database solution.
Your response should be approximately 1200-1500 words.
Database Modeling and Normalization
Name:
Prof:
CIS 515: Strategic Planning for Database Systems
Date:
Explain the process of developing an effective Entity Relationship Model (ERM) for a
personnel database, including key components such as entities, relationships, attributes, and
constraints. Discuss the iterative steps required for its development, the potential risks associated
with not following these steps, and the importance of time-variant data for policy enforcement
and training management. Additionally, explain the normalization process to ensure the database
is in 3NF, and illustrate the five entities necessary for sustaining the personnel database solution.
Your response should be approximately 1200-1500 words.
DATABASE MODELING AND NORMALIZATION 2
Steps in the development of an effective Entity Relationship Model (ERM) Diagram and
the possible iterative steps / factors
An entity relationship model or ERM is a type of graphical diagram where relationships
between entities in a database are being shown. Below here is an example diagram of ERM:
As ERM is an iterative process it needs replication of processes and procedures. There
are three main components in ERM and they are:
Entity – In ERM database designing entity can be many things. It can be somebody, can
be some place, an object or event, or even can be a concept where data is collected or saved. As
an example, if a person accepts some data information for a business, then entities would include
consumers and also their address, and orders. In database entity is labelled with a singular noun
and characterized by a rectangle.
Relationship – Relationship symbolizes link between entities and/or entity types. Simply
we can say it is the interaction among the entities. For an example, a consumer places an order,
then the word "places" highlights the relationship between the instance of a customer and the
order that the person placed. Usually relationships are being represented by a diamond shape or
just by a simple line connecting the entities.
Steps in the development of an effective Entity Relationship Model (ERM) Diagram and
the possible iterative steps / factors
An entity relationship model or ERM is a type of graphical diagram where relationships
between entities in a database are being shown. Below here is an example diagram of ERM:
As ERM is an iterative process it needs replication of processes and procedures. There
are three main components in ERM and they are:
Entity – In ERM database designing entity can be many things. It can be somebody, can
be some place, an object or event, or even can be a concept where data is collected or saved. As
an example, if a person accepts some data information for a business, then entities would include
consumers and also their address, and orders. In database entity is labelled with a singular noun
and characterized by a rectangle.
Relationship – Relationship symbolizes link between entities and/or entity types. Simply
we can say it is the interaction among the entities. For an example, a consumer places an order,
then the word "places" highlights the relationship between the instance of a customer and the
order that the person placed. Usually relationships are being represented by a diamond shape or
just by a simple line connecting the entities.
Preview Mode
Sign in to access the full document!
100%
Study Now!
XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat
Document Details
University
Bellevue University
Subject
Information Technology