DEVRY CIS 336 Week 7 Group Project Task 5 .pdf
Original filename: DEVRY CIS 336 Week 7 Group Project Task 5.pdf
This PDF 1.5 document has been generated by Microsoft® Office Word 2007, and has been sent on pdf-archive.com on 07/03/2017 at 04:26, from IP address 43.224.x.x.
The current document download page has been viewed 115 times.
File size: 201 KB (4 pages).
Privacy: public file
Download original PDF file
DEVRY CIS 336 Week 7 Group Project Task 5
Check this A+ tutorial guideline at
Develop the queries to support each of the
reports that are required by Ms. Smith. It is
expected that the information returned by the
queries is adequate to be used in the
reporting process. Make sure your output
contains enough information! The following is
a recommendation and the MINIMUM amount
of data you should have access to:
Customer Table: A minimum of 12 customers
(this will allow several channels to have more
than one customer selecting it as a favorite
channel) Billing Table: Records to support the
above customers Program Table: A minimum
of 25 programs (your program guide should
have enough programs for various channels
to support the program guide report) Other
tables: A sufficient amount of data to support
the above when reports are run.
Create a heading of REPORTING STATEMENTS
as a comment at the bottom of your group
project database script file. Add the six report
queries to this area. In instances where you
are asked to allow for user input, please
specify an appropriate value based upon the
data in your script. For example, Report 1 is a
DATE driven report; therefore, you should use
a single date in your WHERE clause to display
the information. Task 5 is the final task for the
project and is designed to demonstrate that
you have adequately satisfied the
requirements of the project. The following is
what you are to submit for Task 5:
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.
For more classes visit