Management and information system help
FFx5526
howtocreateadatamodel.pptxHow to Create a Data Model
Dr. Kim Troboy
MGMT 4013
Fall 2014
1
Agenda
Build a simplified data model that will
Be efficient.
Support database integrity.
Enforce management policies and business rules.
Add Entity/Relationship diagrams (ERD).
Normalize the data model.
See the accompanying Word document for the procedure to create a data model (with explanatory notes and examples).
What follows next is an example data modeling process.
2
First Part of the Process
Identify all entities .
Describe each entity (attributes).
Set property values for each attribute.
Designate an attribute as an identifier.
3
First Part of the Process
4
Second Part of the Process
Identify direct relationships.
Make sure you can link those relationships.
Describe those relationships.
5
Second Part of the Process
6
Last Part of the Process
Normalize the model.
Remove derived attributes.
Move attributes that are in the wrong entity.
Remove any many-to-many relationships.
7
Removing Many-to-Many Relationships
8
Review Design
Does it meet all requirements?
Is everything fully described?
Take one last look at the normalization steps.
9
That is the process for creating a data model.
Next are a few tips on implementing the model in Access
10
Implement Data Model in Access
11
Implement Data Model in Access
12
Implement Data Model in Access
13
Implement Data Model in Access
14
Conclusion
Now see what you can do to finish the model and implementation.
Check the Course Schedule for the due dates.
Let me know if you have any questions.
Keep me posted on how you are doing. I might consider a 24-hour extension on the due dates.
15
