Richland College Creation and Design of MySQL Schema Objects Program

Question Description

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

Grading Rubric
Criteria	Points
Identified 2-3 entities with 5-10 fields each	15 points
Database normalized appropriately	30 points
Data fields assigned valid names	10 points
Identify a primary key for each table and foreign keys as needed	10 points
Create an EER diagram	15 points
Provide a description of the business the database will serve.	20 points
Total	100 points

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.



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.