FINAL CLASS PROJECT

A significant part of your grade this semester is the delivery of a final project.
Students will be expected use their professor provided database to create, populate and query multiple tables.
Students will be responsible for designing multiple database tables, creating those tables, inserting data in those tables,
and finally performing multiple queries against those table.

Your final project is important!

• Learn about database design, table creation, connecting tables, loading tables and querying tables
• Give you the opportunity to apply what you have learned in this class.
• Although some part of the projects cannot be implemented early in the course, begin thinking about it.

Your project should at minimum include:

• The design of a normalized database for an order entry system, as follows:
  • A customer table
  • A customer address table (a customer can have multiple addresses)
  • A Customer order table (a customer can have multiple orders)
  • A customer order line item table (an order has multiple line items)
  • A product table
  • A vendor table
  • PS. A single product is supplied/provided by many vendors
  • Add whatever columns you feel are necessary to support an order entry process system.
  • Relate the tables to one another using 1:1, 1:N or N:M relationships as you see fit.

• Create and load the tables with your own (made up) data, as follows:
  • Create the above tables
  • Assign proper column data type as you see fit
  • Create primary keys and foreign keys to relate the tables to one another
  • Make up your own data, specific to each table
  • Insert data into the variaous tables
  • Tables should contain a minimum of 10 rows, and a maximum of 50-100 rows each

• Query the tables, as follows:
  • Perform 3 queries
  • Query 1 - TBD
  • Query 2 - TBD
  • Query 3 - TBD

Posting your project:

• Your project tables should be created on the professor provided individual database (with your lastname)
• You can use either the MySQL database or the Oracle database
• The tables should be fully loaded with data
• All "create table" and "insert into" SQL commands should be submitted to NYU Brightspace "Final Project"
• All SQL queries and query results screenshots should be submitted to NYU Brightspace "Final Project"