Richland College Creation and Design of MySQL Schema Objects Program

Apps : MySQLworkbenchch 8.0.

Data Normalization

Objectives

• Creation and Design of MySQL Schema Objects
• Design and create normalized databases
• Create and modify tables using appropriate data types and indexing
• Describe and create table constraints enforcing data integrity

Requirements

• Identify a real world application that would require a database. This could be a business, an organization or a specific area within a business or organization (i.e. human resources, payables and receivables, etc.)
• Identify 2-3 major entities involved in the application. For example, if you were doing a college scheduling application, the entities might be students, classes and instructors.
• For each entity, identify the information about the entities (data fields) that would be needed. You should have about 5-10 fields for each entity.
• Using the identified entities and data fields, go through the data normalization process to identify the tables that would be needed for a relational database.
• Assign valid SQL fieldnames to each field.
• Identify a primary key for each table.
• Identify the foreign keys that would be needed.
• Use the data modeling utilities in the workbench to create a new EER diagram for your database and submit that.
• Save the file as -eer-diagram.mwb and submit for grading by clicking on the assignment link.
• Add a detailed description of the business model the database will serve in the comment section of the assignment subm

Lecture Resources

MySQL Database Design Article

https://bhcwebdev.com/articles.php?articleID=115

Database design is a formal process with specific critical rules to ensure a well-formed data structure that can be maintained without causing data errors and anomalies.

MySQL Sample Database Design – College Classes Article

https://bhcwebdev.com/articles.php?articleID=116

A database designed to support class enrollments at a college.

MySQL Sample Database Design – Marina Services Article

https://bhcwebdev.com/articles.php?articleID=117

A database to support a marina services company.

Instructor Notes

Instructor remark from previous submission : You provided no explanation of what kind of organization this is for or what the goals of the database will be. I don’t understand what these tables represent or what data you will attempt to save and for what purpose.Please resubmit with a clear explanation of purpose.