data normalization competenciesLab 8: Data Normalization Competencies 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 would 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. This is a pretty good video that shows how to use the modeling tools in MySQL workbench to build your database.He starts in the modeling portion of the software. This can be reached in the workbench by using the FILE menu. Select File – > New Model to get started.