12 Data 2

C170 Data Management Foundations

Construct a normalized physical database model to represent the ordering process for Nora’s Bagel Bin by doing the following:

  • Complete the second normal form (2NF) section of the attached “Nora’s Bagel Bin Database Blueprints” document by doing the following:a. Assign each attribute from the 1NF table into the correct 2NF table.

Create a database using the attached “Jaunty Coffee Co. ERD” by doing the following:

  • Develop SQL code to create each table as specified in the attached “Jaunty Coffee Co. ERD” by doingthe following:
    a. Provide the SQL code you wrote to create all the tables.