Complete the following to write documentation and build a database using a normalized database schema with ERDs, and the SQL scripts for creating tables and inserting sample data. Be sure to include the following elements in your documentation and database.

• Database schema design: Design a normalized database schema for your database design concept from last week.
  • Ensure that you consider appropriate data types for attributes, primary keys, and foreign keys.
  • Apply the normalization process to your database schema.
  • Start with the unnormalized form (UNF) and proceed through the First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF).
  • Document each step and any modifications you make to achieve the desired normal form.
• SQL schema creation: Write SQL statements to create the tables for your database, including primary key constraints, foreign key constraints, and any other necessary constraints based on your normalized schema.
• Data population: Populate your tables with sample data. Include at least five records
• Queries and operations: Write SQL queries to retrieve the following information:
  • List your data based on a single key.
  • List your data based on a number of keys and criteria.
  • Search for records that contain unique characteristics in your database.
  • Calculate the total number of records given a unique characteristic.
  • Add new records.
  • Update current record.
  • Remove a record.
• Document the normalized database schema with entity-relationship diagrams and the SQL scripts for creating tables and inserting sample data