We're Open
+44 7340 9595 39
+44 20 3239 6980

Module 3 - SLP Normalization and SQL DDL Statements

Information



  • Post Date 2018-11-05T12:07:47+00:00
  • Post Category Essays

No Plagiarism Guarantee - 100% Custom Written

Order Details

Module 3 - SLP Normalization and SQL DDL Statements

Module 3 - SLP Normalization and SQL DDL Statements

INSTRUCTIONS:

Module 3 - SLP
NORMALIZATION AND SQL DDL STATEMENTS
SLP Assignment Overview
Developing a Database System: Improving Database Design
Improving Database Design through Normalization
Continue improving the bookstore database (tables) you designed. Here are your tasks:
Normalize the tables from the previous module. Discuss 1NF, 2NF and 3NF, and whether you believe your tables satisfy each level of normal forms. If all your tables have satisfied the 3NF, explain the reason.
Drop the tables no longer needed, and create tables as required in your new design, using SQL in DBMS.
Include the SQL statements and screenshots of your new tables in the paper.
SLP Assignment Expectations
Normalize tables in a database design.
Be able to create and drop tables using SQL.
Communicate effectively with your audience.

CONTENT:

Module 3 - SLP Normalization and SQL DDL Statements Name Trident University Date After identifying the preliminary design of the table, I normalized the database to structure the tables. Since there is a need to update and create new records normalizing the database will improve the database. Under the 1NF (first normal form) the cells in the table contained one value, while the 2NF highlights the attributes being directly dependent on the primary key (Allen & Terry, 2005). Since there is emphasis on removing the redundancies in the inventory and sales data the modified data has eliminated deficiencies. Using the 3NF the non-key column is independent of the other columns and the normalization process then r

...

Price: £ 99

100% Plagiarism Free & Custom Written, Tailored to your instructions