-
Notifications
You must be signed in to change notification settings - Fork 3
Data Modelling Design Process
The first step in database architecture is to decide the data requirements of the users. A process called normalization
can help us to develop data model. To review data and data requirements with user perspective, the entity
and attribute
must be defined.
Entity: An entity is something about which information is known. It represents or describes something of interest to the user, such as person, a place, or a thing. Example of entities can be Transporter, Inspector etc.
Attribute: An attribute provides detailed information about an entity. it helps one to identify, describe, or clarify the entity by providing a value for some quantifiable characteristic or trait. Example, Transporter name, Truck License Plate# etc.
-
As a staring point, determine the data requirements from the available forms to create the
entity/attribute list
. -
Cleaning up the
entity/attribute list
Before beginning the normalization process, the initial entity/attribute list must be checked for errors or oversights. The following four problem types can be considered to cleaning the entity/attribute list
- Problem Type 1 - Synonyms
- Problem Type 2 - Homonyms
- Problem Type 3 - Redundant Information
- Problem Type 4 - Mutually Exclusive Data
-
Now that a
clean entity/attribute list
exists in which an attribute has one and only one name as well as a unique meaning, the normalization process begin.Normalization
is the process of analyzing the dependencies between attributes within entities. -
Normalization Steps includes -
- First Normal Form(1NF)(according to book "A Practical Guide to Database Design (Second Edition) by Rex Hogan):
An entity is in 1NF if 1. All entities must have a key, composed of an attribute or combination of attributes which uniquely identify one occurrence of the entity. 2. For any single occurrence of an entity, each attribute must have one and only one value.
- Second Normal Form(2NF)(according to book "A Practical Guide to Database Design (Second Edition) by Rex Hogan):
For 2NF, each non key attribute must depend on the key and all parts of the key.
- Third Normal Form(3NF):
For an entity to be in 3NF, each non-key attribute must relate to the key, the whole key, and nothing but the key.
- First Normal Form(1NF)(according to book "A Practical Guide to Database Design (Second Edition) by Rex Hogan):
-
Creating a Relational Data Model based on 3NF.
Using the above process, we can create error-free and detailed data model of an application. After creating the data model, it is easier to implement database for our application.
Deliverables pages (see website)
- Progress Update and Project Requirement Questions Oct 5, 2020
- Progress Update Meeting Oct 29, 2020
- Progress Update Meeting and USM-related questions Nov 11, 2020
- Mentor Progress Update Meeting Nov 25, 2020
- Livestock Services Saskatchewan Project Meeting Dec 3, 2020
- Team and Instructor, Mentor, and Faculty Meeting Minutes
- Sprint 0
- Sprint 1
- Sprint 1 Retrospective
- Sprint 2
- Sprint 2 Retrospective
- Sprint 3
- Sprint 3 Retrospective
- Sprint 4
- Sprint 4 Retrospective
- Sprint 5
- Sprint 5 Retrospective
- Sprint 6
- Sprint 6 Retrospective
- Sprint 7
- Sprint 8
- Sprint 7/8 Retrospective
- Sprint 9
- Sprint 10
- Animal Record Transport Template Breakdown
- Transfer of Care Document Breakdown
- FWR Document Breakdown
- Contingency Plan Breakdown
- C4-Model for Client-Server Architecture
- Data Modelling Design Process
- Guide to GUI Prototyping Structure