Module 3 - SLP Normalization and SQL DDL Statements
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.
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 reduces data dependency and redundancy, where the larger tables are broken into smaller tables and linked based on their relationships (Allen & Terry, 2005). The unnormalized relation is converted to the 1NF, 2NF and the 3NF, to avoid the repetition of information. Care is exercised when decomposing the relations as the components ought to be combined to get the original relation without losing information (Chopra, 2010). There is a need to refine table to link the inventory and the sales down by further breaking down the original tables to link the relationships of the related data.
The added- customer data
Product IDTrans CodeCustomer IDUnits Sold422 (credit card)426934028934250255192461 (check)65983482109624014269140133142422653924624456140155191Both the inventory and sales information of the books ad CDSs will still be maintained, but the product and customer data will be updated as this makes it easier to keep track of the changes being made. Since the aim of the normalization process is to eliminate the redundant tables and attributes this helps to simplify the tables and eliminate repetition. This is necessary since redundant information wastes space and causes problems when updating to inert, delete or even modify the anomalies (Raman, 2007). In the inventory data and sales data table, the product ID was utilized to identify the items, and the table decomposition takes into account further details of this table. ...
π Other Visitors are Viewing These APA Coursework Samples:
- Module 3 SLP: IT Project Roles, Responsibilities, Staffing3 pages/β825 words | 6 Sources | APA | IT & Computer Science | Coursework |
- Module 3 Case: Database Normalization, Employee table2 pages/β550 words | 6 Sources | APA | IT & Computer Science | Coursework |
- Module 2 Case: IT Organizations, Projects and Life Cycles4 pages/β1100 words | 8 Sources | APA | IT & Computer Science | Coursework |
- Module 2 Case: Entity Relationship Model Database Design2 pages/β550 words | 6 Sources | APA | IT & Computer Science | Coursework |
- Improving Database Design Through Relationship Modeling1 page/β275 words | 5 Sources | APA | IT & Computer Science | Coursework |
- CSC316 Assignment: Database Systems I Module 1 Discussions2 pages/β550 words | 6 Sources | APA | IT & Computer Science | Coursework |
- Module 2 SLP: IT Organizations, Projects and Life Cycles2 pages/β550 words | 2 Sources | APA | IT & Computer Science | Coursework |