6400Spring19Team07

Repository for Team 07 Project submissions for CS 6400, Spring19.

Project Description:

The purpose of this project is to analyze, specify, design, and implement a data warehouse for an up-and-coming computer and electronics store called S&E’s Technology Superstore. The project will proceed in three phases as outlined in the Classical Methodology for Database Development: Analysis & Specification, Design, and Implementation & Testing. The system will be implemented using a Database Management System (DBMS) that supports standard SQL queries.

Overall Summary of Repository Layout

• This repository contains the code from Team07 for Phase1, Phase2 and Phase3.
• Phase 1 includes
  • the Extended Entity Relationship (EER) map for the S&E Store,
  • the Information Flow Diagram, and
  • a detailed Report with data types, task decomposition, and abstract code.
• Phase 2 includes
  • the updated EER map
  • the EER to Relational Database table mapping
  • full schema of the Relational Database with all tables and constraints
  • and a report which has translated Phase1 abstract code into SQL queries
• Phase 3 contains all the implementation code for this project
  • Please review its corresponding README.md file.

Authors

• Omer Ansari
• Kevin Elmer
• Richard Levine
• Anthony Song