- Home
- Table of Contents
- Statement of Authenticity
- Personal Mission Statement
- Elevator Speech
- Education
- Resume
- Work Samples
- Professional Development and Training
- Letters of Reference
- Reference List
- Awards and Accomplishments
- Volunteer History
- Professional Affiliations
- Career Pathing
- DeVry University Computer
MiniQuest Database Design and Implementation Project
Table 4: Sample Supplier Listing of programs for NBC
MiniQuest Project Documentation - Click to download
Case Project Objective:
The project for CIS336 was designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project was team centered and each team was responsible for designing, developing, and demonstrating the functionality of a database created
based on a defined set of business specifications. At the end of the session, each project team submitted the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project were covered first during
the week or weeks prior to a deliverable, and each task deliverable in the project was supported through the exercises and labs done in the course. Using the Oracle SQL*Plus editor, we were asked to develop a database for a fictional company called MiniQuest based on our data model.
The completed Data Model included: An ERD, created using Microsoft Visio, showing all tables, related attributes, and the primary and foreign keys. This diagram also showed both the relationship and cardinality of the relationship using accepted notation. A Data Dictionary (or meta data chart), using Microsoft Excel, showing a minimum of the table name, columns, data types, length, and constraints.
We then developed the CREATE TABLE statements required to create your database tables, included the DROP TABLE statements at the top of our file so that we could reuse the file and included the wording CASCADE CONSTRAINTS PURGE as part of each DROP TABLE statement, so that the order of the DROP statements would not matter. In addition, we also developed the SQL statements to INSERT records into the database. The complete script file included DROP, CREATE, INSERT, SELECT, and UPDATE statements and the queries we developed to support each of the reports that were required.
Reports that were needed for the project:
Report 1 – A list of the programs on all channels for a specific day showing the channel number, supplier, package, program name, rating code, and show time. This will be similar to a program guide, only not package specific. This is a date-driven report, therefore it should only display programs for a single date specified.
Report 2 – A sample program guide showing the channel number, show time, program name, and rating description. For the purposes of this project, your report should be package ID specific (based on a given package ID) and you only need to demonstrate a single package ID. Your report should include all channels associated with the specified package.
Report 3 – A list of all new customers signed up on a specific day. This should show enough details about the customer, including favorite channel, address, and minimal billing details. This report is to be date driven, so you will need to specify a date in your query.
Report 4 – A list of all the customers made inactive on a specific date. This should show enough details about the customer to allow contact with the customer, the reason he or she was made inactive, and the user who made them inactive. Again, keep in mind that this is a date driven report.
Report 5 – A list of each channel (both channel name and channel number) and a count of the number of customers who picked that channel as a favorite channel.
Report 6 – A summary of sales for any given day, categorized by package type (i.e., the total sales written on the specified day for each package subscribed to by customers, not bills paid). This report should give
details about each package type, the package price, the number of packages sold, and then the total sales amount for that package. Once again, remember that this is going to be a date driven report.