CIS 336 Devry Course-Shoptutorial
3 views | +0 today
Follow
Your new post is loading...
Your new post is loading...
Scooped by Huntermichael
Scoop.it!

CIS 336 Week 5 Group Project Task 3 (Devry) - ShopTutorial.com

CIS 336 Week 5 Group Project Task 3 (Devry) - ShopTutorial.com | CIS 336 Devry Course-Shoptutorial | Scoop.it
CIS 336 Week 5 Group Project Task 3 (Devry) | Develop the SQL statements to insert records into the database. You should ensure that the data .
Huntermichael's insight:

For more course tutorials visit

www.shoptutorial.com

Product Description

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 co

more...
No comment yet.
Scooped by Huntermichael
Scoop.it!

CIS 336 Week 1 iLab 1 Devry University (Devry) - ShopTutorial.com

CIS 336 Week 1 iLab 1 Devry University (Devry) - ShopTutorial.com | CIS 336 Devry Course-Shoptutorial | Scoop.it
CIS 336 Week 1 iLab 1 Devry University (Devry) | L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining.
Huntermichael's insight:
For more course tutorials visit www.shoptutorial.comProduct Description

L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining one of the key components of a data model; the relationship diagram (RD). In this lab, you will draw a relationship diagram for two of the steps shown. Keep in mind when you are trying to decide which side of the relationship should be the "one" side and which should be the "many" that you must first decide which side has the primary key, or unique identifier. Once you have decided the primary key of the relationship, you have identified the "one" side of the relationship. Note that for an RD, the foreign key "many" side of the relationship points to the primary key "one" side. The "one" side should have the arrowhead point of the connecting line. This is different than an entity/relationship diagram (ERD) that we will draw next week, where the "many" side has crow's feet. This will familiarize you with how to set up MS Visio to draw database diagrams. Steps 1 - 3 below use the Customer, Order, and Employee tables of a simplified Order Entry database. The Customer table records clients who have placed orders. The Order table contains the basic facts about customer orders. The Employee table contains facts about employees who take orders. The primary keys of the tables are CustNo for Customer, EmpNo for Employee, and OrdNo for Order. The following are the TABLE definitions for the first three tables showing the PRIMARY KEY constraints. TABLE Customer has the following attributes CustNo NUMBER(5) CustFirstName VARCHAR2(20) CustLastName VARCHAR2(30) CustCity VARCHAR2(30) CustState CHAR(2) 

more...
No comment yet.
Scooped by Huntermichael
Scoop.it!

CIS 336 Entire Course (Devry) - ShopTutorial.com

CIS 336 Entire Course (Devry) - ShopTutorial.com | CIS 336 Devry Course-Shoptutorial | Scoop.it
CIS 336 Entire Course (Devry) | CIS 336 Entire Course: Devry University
Huntermichael's insight:

For more course tutorials visit

www.shoptutorial.com

 

Product Description

CIS 336 Week 1 iLab 1 Devry University (Devry)

CIS 336 Week 2 iLab 2 Devry University (Devry)

CIS 336 Week 3 iLab 3 Devry University (Devry)

CIS 336 Week 4 iLab 4 Devry University (Devry)

CIS 336 Week 5 iLab 5 Devry University (Devry)

CIS 336 Week 6 iLab 6 Devry University (Devry)

CIS 336 Week 7 iLab 7 Devry University (Devry)

CIS 336: All iLabs Week 1 to Week 7: Devry University (Devry)

CIS 336 Quiz 1 (Devry)

CIS 336 Quiz 2 (Devry)

CIS 336 Quiz 3 (Devry)

CIS 336 Quiz 4 (Devry)

CIS 336 Quiz 5 (Devry)

CIS 336 Week 3 Group Project Task 1 Data Model (Devry)

CIS 336 Week 4 Group Project Task 2 (Devry)

CIS 336 Week 5 Group Project Task 3 (Devry)

CIS 336 Week 6 Group Project Task 4 (Devry)

CIS 336 Week 7 Group Project Task 5 (Devry)

 

 

 
more...
No comment yet.
Scooped by Huntermichael
Scoop.it!

CIS 336 Week 3 Group Project Task 1 Data (Devry) - ShopTutorial.com

CIS 336 Week 3 Group Project Task 1 Data (Devry) - ShopTutorial.com | CIS 336 Devry Course-Shoptutorial | Scoop.it
CIS 336 Week 3 Group Project Task 1 Data Model (Devry) | Present a detailed data model for the project scenario. You can create your data model using.
Huntermichael's insight:
For more course tutorials visit www.shoptutorial.comProduct Description

Present a detailed data model for the project scenario. You can create your data model using Microsoft Visio, which you will have access to through iLab and Microsoft Excel, which comes with Microsoft Office. Other tools may be used as long as the output is legible and conforms to standard format. (i.e. I will not be able to grade the data model if I cannot tell what it is supposed to be!). Your data model should include a minimum of an ERD and metadata chart (data dictionary).

A key component to every task submission is the team responsibilities document. This document should outline the contributions that each member of the team made to completing the task deliverable. There is a sample document in the Doc Sharing tab that can be used, or each team can come up with their own design. As stated in the syllabus, although this is a team project, each member will also be graded on their involvement in the project. This assessment needs to be honest and accurate in describing the individual members’ activities for the task.

Deliverables for this task:

A completed Data Model to include: An ERD, showing all tables, related attributes, and the primary and foreign keys. This diagram must show both the relationship and cardinality of the relationship using accepted notation. A Data Dictionary (or meta data chart) showing a minimum of the table name, columns, data types, length, and constraints. Team member responsibilities document outlining contributions by team members to this deliverable. 

 
more...
No comment yet.
Scooped by Huntermichael
Scoop.it!

CIS 336 Final Exam 4 (Devry) - ShopTutorial.com

CIS 336 Final Exam 4 (Devry) - ShopTutorial.com | CIS 336 Devry Course-Shoptutorial | Scoop.it
CIS 336 Final Exam 4 (Devry) | (TCO 7) For every order, list the order number, order date, part number, part description, and item class for each part .
Huntermichael's insight:

For more course tutorials visit

www.shoptutorial.com

 

Product Description

1. (TCO 7) For every order, list the order number, order date, part number, part description, and item class for each part that makes up the order.

2. (TCO 8) Write a query that will display the customer number, last name, and first name for every customer I whose first name begins with the letter "D".

2. (TCO 8) Write a query that will display the earliest date an order was placed.

3. (TCO 7) Using the BETWEEN operator, write a query that will list all details about all orders that were placed during the period of September 3rd thru September 5th of 1998.

5. (TCO 7) Write a query that will list the customer first and last name and the sales rep commission rate using JOIN ON. 

 
more...
No comment yet.