nbaDatabase - Authors Daniel Lisko and Michael Chang

NBA database for DBMS Project 1 - CS 5200

Business Requirements and Logical/Conceptual Models

Business Requirements PDF

Business Requirements in Google Docs

Conceptual Model

Conceptual Model Lucid Chart

Logical Model

Logical Model Lucid Chart

Relational Schema with BCNF Proof

The BCNF proof is in the Business Requirements Document In the SCHEMA is BCNF section

Business Requirements Document Google Docs In the SCHEMA is BCNF section

SQL File w/ Table Definitions/Creation (DDL)

SQL File with Table Definitions/Creation SQL creation scripts to be ran in SQLite3

Data used to populate the Tables (DML through DB Browser Import CSV)

SQL queries used to query information from our database with test data (DML)

Various SQL query demonstrations:

• showing join of at least three tables
• subqueries
• group by with a having clause
• complex search criterion

Screenshots showing functionality of constraints

Screenshots pasted into xlsx file

Screenshots pasted into Google Sheets