TEC 5020 Database Development and AI

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

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.