Database Schema Assignment Answers

Question:

Goal of the assignment is to create the beginnings of a database from given information. You are provided with the following data points about a customer and their orders: • Customer Last Name • Customer First Name • Customer Middle Name • Suffix • Phone • Email Address • First seen Date • Customer Address Street1 • Customer Address Street2 • Customer Address City • Customer Address State • Customer Address Zip • Customer Address Last Modified Date • Order Number • ProductName • List Price (MSRP) • Sell Price • Sell Date • Ship Date

Database Schema Answer and Explanation

    LastName VARCHAR(50),

    FirstName VARCHAR(50),

    FirstSeenDate DATE,

    AddressStreet1 VARCHAR(100),

    AddressLastModifiedDate DATE

);

    OrderNumber VARCHAR(20),

    ProductName VARCHAR(100),

    FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)

);