PDF Archive

Easily share your PDF documents with your contacts, on the Web and Social Networks.

Share a file Manage my documents Convert Recover PDF Search Help Contact



DEVRY CIS 336 Week 5 Group Project Task 3 .pdf



Original filename: DEVRY CIS 336 Week 5 Group Project Task 3.pdf
Author: LENOVO

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:25, from IP address 43.224.x.x. The current document download page has been viewed 115 times.
File size: 205 KB (3 pages).
Privacy: public file




Download original PDF file









Document preview


DEVRY CIS 336 Week 5 Group Project Task 3
Check this A+ tutorial guideline at
http://www.cis336entirecourse.com/cis-336devry/cis-336-week-5-group-project-task-3
Develop the SQL statements to insert records
into the database. You should ensure that the
data in the database is sufficient to allow for
each of the reports requested by Ms. Smith to
be tested. You need to show a minimum of
three insert queries for each database table
that you have created. Some tables will
obviously require more to ensure that all of
the required data is in the database (i.e., the
packages table, program table, etc). To submit
this task, add a comment heading called
INSERT STATEMENTS to your corrected SQL
script from Task 2. Add your INSERT
statements for each table after this heading.
Keep in mind that you will need to insert data
into the tables in the same order that the
tables were created. This will minimize any

integrity constraint errors you might
encounter. Keep in mind also that any values
being inserted into a field defined as a foreign
key field must first exist in a previous table’s
primary key field. Save the file as
TEAM_X_TASK3.TXT, where X is your team
identifier. After testing your statements to
verify that your data will insert into your
tables, create a spooled output file with the
SET ECHO ON session command set for
submitting.
Note – Although you are only required to have
three records per table in most of your tables
for this deliverable, you will need a
considerable amount of data in your tables for
the final project.
After testing and verifying that all of your
create statements work, create a spooled
output file with the SET ECHO ON session
command set so that your code and the
results will show.
Deliverables for this task:

Any revisions of task 2 based on feedback
from your instructor. Task 3 comprised of the
script file containing DROP TABLE, CREATE
TABLE, and INSERT statements, and the
output file showing that it works. Team
member responsibilities document outlining
contributions by team members to this
deliverable.

For more classes visit

www.cis336entirecourse.com


DEVRY CIS 336 Week 5 Group Project Task 3.pdf - page 1/3
DEVRY CIS 336 Week 5 Group Project Task 3.pdf - page 2/3
DEVRY CIS 336 Week 5 Group Project Task 3.pdf - page 3/3

Related documents


PDF Document devry cis 336 week 5 group project task 3
PDF Document devry cis 336 week 5 group
PDF Document devry cis 336 week 6 group project
PDF Document devry cis 336 week 6 group project task 4
PDF Document devry cis 336 week 4 group project task 2
PDF Document devry cis 336 week 4 group


Related keywords