BIT 536 - 'insert interesting project name here' Part 2

The cumulative final project combines everything we learned about database systems and Oracle and turns it into one nice little project.

After submitting our design, Professor Calvaneso gave each group his data model as the base of the next part of the project.

The second part of the project involved writing SQL*Plus scripts to create the appropriate tables, fill the tables with sample data, and run sample reports (queries).

My partner, Jason G, and I worked together to create 3 scripts per the project requirements.

The first script, DDL.SQL creates the tables and constraints and spools the results to a .lst file.

The second script, POP.SQL enters sample data (yes we did cheat and use sysdate to save the time of formatting numerous sample dates) and spools the results to a .lst file.

The third script, RPT.SQL runs the reports (queries) and spools the results to a .lst file.

BIT 536 - 'insert interesting project name here' Part 1

The first part of the project involved creating a data model for a fictitious grocery store based on 'interviews' with various managers.

My partner Jason and I created this ERD in Visio and a Data Dictionary in Excel to go along with it.

BIT 536 - Database Systems

I started my first MSIS class tonight! Professor Ron Calvaneso is teaching the course.

Course Description: BIT 536 - Database Systems - 3 Credit Hours
This course covers the essential database concepts, technology, and techniques required for business database development. Concepts, tools, and technologies associated with the design,
implementation, and management of databases are presented. Topics include data models (with emphasis on E/R model and relational model), normalization, database design and implementation, database query language, transaction management, and distributed databases.