DBManagement-A6

CSPC-408-03 Final Project; Board Game Cafe Inventory!

1. contributors;

Alex Lark

    email; lark@chapman.edu
    git; Alex-Lark
    Chapman ID; 2421705 

Annika Brown

    email; annbrown@chapman.edu
    git; annibrown
    Chapman ID; 2428684

Savana Chou

    email; sachou@chapman.edu
    git; savanaachou
    Chapman ID; 2428859

Daisy Fernandez-Reyes

    email; fernandezreyes@champman.edu
    git: daisyb3ll
    git; 2397470

2. Project Proposal;

For this assignment we are working with our client, the owners of Drinks & Dice, a board game café. The owners have requested ww reservation and ordering system for their website. The site will be used by clients to reserve board games for their visits through our reservations tab, order drinks for their visits, manage their account information, and view their past reservations.

3. source files;

diagrams

• ER Diagram
• Database Schema
• wireframe

frontend

• account-info.html
• create-account.html
• sign-in.html
• home.html
• menu.html
• styles.css
• tabs.css

functionality

• database.py
• boardGameCafe.py
• helper.py
• database.py
• helper.py

documentation:

• README.md

database:

• BoardGameOrders.csv
• BoardGames.csv
• Customers.csv
• MenuItems.csv
• MenuOrders.csv
• Reservations.csv

slides presentation

• [slides] "https://docs.google.com/presentation/d/1qLM0IAXwZKFrY0MDF0izsz0yP4ybg4j4NlAziHqvsYs/edit?usp=sharing"

3. known runtime/compilaiton errors

4. references;

• An Introduction to Information Infrastructure II Unit 6 Backend to Database
• DML/DQL Lectures

5 .instructions (in terminal)

Installations

• pip install Flask
• pip install csv

Instructions:

• python boardGameCafe.py
• click on the link generated by the terminal
  
• it will look something like "http://127.0.0.1:5000"
• have fun going thru the site!