Sales Order Database: DB Construction Solution

Developing a Database System: Improving Database Design

Improving Database Design through Normalization

Continue improving the bookstore database (tables) you designed. Here are your tasks:

  1. 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.
  2. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

  • File Format: MS-Word .docx
  • Page Count: 9
  • Word Count: 778
  • Figures Included: Yes
  • DB Used: Oracle
  • Version: 11g