Home

Welcome to the cab-project-02-1 wiki! This is the wiki for the Energy Supply Project Analysis app

This is an application that is focused on the energy supply distribution at TCNJ. We allow our users to view the difference in usage between Natural Gas/Fuel Oil and the Electric Grid. We are able to present the user with an energy efficiency analysis to help them determine if TCNJ is utilizing the energy effectively in terms of costs compared to how much of it we use and we present the fluctuation of energy usage by the season. This allows the user to see both the energy efficiency and energy reliability of the energy sources we use at TCNJ

Want more information? No worries!

We have some pretty cool things.

Stage 2a Deliverables

• Project Proposal
• Original Project Presentation

Stage 2b Deliverables

• Final Project Proposal

Stage 3 Deliverables

• Database ER Diagram
• Database Schema
• Midterm Project Report
• Midterm Slides
• Estimation of Database Size:
• Initial database size (approximate number of records): 1,430 rows if allow for just monthly comparisons, 4.3 million rows if we allow for 15-minute interval comparisons
• Types and average number of searches: Select operations with join operations to combine ENERGY_SOURCE with the energy types. 2-4 searches per user is estimated

Stage 4 Deliverables

• Step 1a: Updated Database ER Diagram
• Step 1b: Updated Database Schema
• Step 2: BCNF Tables
• Step 2: BCNF Table Explanation
• Step 3: Views for Database
• Step 4: Complete list of SQL Queries

Stage 5a Deliverables

• SQL DDL Commands
• Scripts
• CSV Data Files - Unavailable in this repo
• SQL DML Commands

Stage 5b Deliverables

• Application for Queries

Stage 6 Deliverables

• Presentation for Demo

Stage 7 Deliverables

• Presentation Slides
• Final Report