CMUL Developing a Database Environment Paper

Choose one of the following categories to start developing a database environment that consist of your own mock up design.

1. IMDB

2. Airlines

3. Dealership

4. Brewery

5. LinkedIn

6. TripAdvisor

Create your initial mockup design. Should include a minimum of 7 tables.

Save the .mwb file. Create a power point presentation that includes your plan for your final project in the course. This database environment starts with a design model. Present the following;

1. Schema Design (Screenshot)

2. Talk about how the environment is linked together

3. Provide a summary of why your schema will be beneficial to the organization

Present in class at the start of class next week.

Database Management &
Applications
Author: Jeff Seaman
Data Model
11/1/2021
Development Process| Point Park University
3
What is a data model?
Organizes data elements and standardizes how the data
elements relate to one another.
Used to define requirements for a project and helps
develop the business processes for the project.
11/1/2021
Databases| Point Park University
4
Example of a design model
11/1/2021
Databases| Point Park University
5
Talk through the
diagram in MySQL
Workbench
11/1/2021
Databases| Point Park University
6
Data Modeling Levels
Physical Model
Schema or framework for how data is physically stored in a database
Conceptual Model
Identifies the high level, user view of data
Logical Data Model:
Sits between the physical and conceptual levels and allows for the logical
representation of data to be separate from its physical storage.
11/1/2021
Databases| Point Park University
7
Data Models
Made up of entities, which are the objects or concepts we want to track data
About, and they become the tables in the database.
11/1/2021
Databases| Point Park University
8
Relationships in a database
Relationships between entities can be
1. one-to-one
2. one-to-many
3. many-to-many
11/1/2021
Databases| Point Park University
9
One-To-Many Relationship
Products and vendors shows a one-to-many-relationship.
A single vendor makes many products. This relationship is the
most common type
11/1/2021
Databases| Point Park University
10
One-To-One Relationship
Commonly used with parents and children are being utilized.
Example here: A single book title should be associated with a
single product ID number, and vice versa.
11/1/2021
Databases| Point Park University
11
Many-to-Many Relationship
When multiple instances of one entity are related to multiple instances of
another entity.
11/1/2021
Databases| Point Park University
12
Data integrity
11/1/2021
Development Process| Point Park University
13
Enforce Data Integrity
Important to trust the data sets are accurate and reliable.
Two rules in maintaining data integrity
1. Entity Integrity
2. Referential Integrity
11/1/2021
Database Management| Point Park University
14
Enforce Data Integrity
1. All entities should have a primary key
2. The values of all primary keys must be unique
11/1/2021
Database Management| Point Park University
15
Enforce Data Integrity
1. The value of a primary key cannot be null
11/1/2021
Database Management| Point Park University
16
Normalizing
11/1/2021
Development Process| Point Park University
17
Normalization
Normalization is the process by which is a structuring of data so that
each entity only has one theme or topic.
11/1/2021
Database Management| Point Park University
18
11/1/2021
Database Management| Point Park University
19
Normalization
There are different levels of normalization, starting at first normal form
and going up to the sixth normal form.
3NF (Third Normal Form) is the most common. It has no transitive
dependency for non-prime attributes as well as it is in the second
normal form.
Example:
1. X is a super key
2. Y is a prime attribute ( each element of Y is part of the some
candidate key)
11/1/2021
Database Management| Point Park University
20
Normalization
11/1/2021
Database Management| Point Park University
21
Thank You!
11/1/2021
Database Management| Point Park University
22
QUESTIONS
11/1/2021
Database Management| Point Park University
23