Please assist with following assignment .
Apps :MySQLworkbench 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
- Add a detailed description of the business model the database will serve in the comment section of the assignment submission.
Upload the assignment files
- Use MySQL Workbench program to complete your assignments and save your work.
- Test the page(s) on the Workbench to make sure it displays properly.
- Save the script with the filename specified.
- Add a detailed description of the business model the database will serve in the comment section of the assignment submission.
- Attach your solution files.
- Submit the assignment.
Lecture Resources
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.
https://bhcwebdev.com/articles.php?articleID=116 A database designed to support class enrollments at a college.
https://bhcwebdev.com/articles.php?articleID=117 A database to support a marina services company.
0 comments