CIS 336 Course Future Starts / cis336dotcom

1
CIS 336 Course Future Starts / cis336.com
The Best way to predict the Future is to create
it.....To Best way....
www.cis336.com
2
CIS 336 Course Future Starts / cis336.com
CIS 336 All iLabs Week 1 to Week 7 Devry
University (Devry) For more course tutorials
visit www.cis336.com   CIS 336 All iLabs Week 1
to Week 7 Devry University
3
CIS 336 Course Future Starts / cis336.com
CIS 336 Entire Course Devry University
(Devry) For more course tutorials
visit www.cis336.com   CIS 336 Entire Course
Devry University
4
CIS 336 Course Future Starts / cis336.com
CIS 336 Final Exam 1 (Devry) For more course
tutorials visit www.cis336.com   1. (TCO 1) Most
DBMS are referred to as _____________database
management systems. (Points 4) elementallinked
hierarchicalrelational 2. (TCO 1) Data
constitutes the building blocks of _____________.
(Points 4) informationprocessing
5
CIS 336 Course Future Starts / cis336.com
CIS 336 Final Exam 2 (Devry) For more course
tutorials visit www.cis336.com   1. (TCO 1) Most
DBMS are referred to as _____________database
management systems. (Points 4) elementallinked
hierarchicalrelational 2. (TCO 1) A relational
DBMS provides protection of the
_______________________ through security,
control, and recovery facilities. (Points 4)
6
CIS 336 Course Future Starts / cis336.com
CIS 336 Final Exam 3 (Devry) For more course
tutorials visit www.cis336.com   1. (TCO 2)
Explain what physical independence means. (Points
15) 2. (TCO 8) Sally wants to query the EMP
table and determine how many of the employees
live in each of the cities the company has
factories in. She writes the following query but
it does not work. What is wrong with the way the
query is constructed?
7
CIS 336 Course Future Starts / cis336.com
CIS 336 Final Exam 4 (Devry) For more course
tutorials visit www.cis336.com   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.
8
CIS 336 Course Future Starts / cis336.com
CIS 336 Final Exam 4 Sets of Answers (Devry) For
more course tutorials visit www.cis336.com   CIS
336 Final Exam 4 Sets of Answers
9
CIS 336 Course Future Starts / cis336.com
CIS 336 Final Exam Guide For more course
tutorials visit www.cis336.com   CIS 336 Final
Exam Guide 1)Joe works for a company where the IT
department charges him for the number of CRM
login accounts that are in his department. What
type of IT funding model is his company
deploying? 2) This project cycle plan chart looks
very much like a bar chart and is easy for
management to read because of its visual nature.
10
CIS 336 Course Future Starts / cis336.com
CIS 336 Midterm Exam (2 Sets)  For more course
tutorials visit www.cis336.com   CIS 336 Midterm
Exam Set 1 1)The concept of jobs is being
replaced with the concept of work, requiring a
framework that links the IS Strategy with the
organization strategy to answer all of the
following EXCEPT 2) All of the following
are new types of jobs created by the growing
reliance on technology EXCEPT
11
CIS 336 Course Future Starts / cis336.com
CIS 336 Quiz 1 (Devry) For more course tutorials
visit www.cis336.com   (TCO 3) Normalization
works through a series of stages called normal
forms. Typically _________ stages must be
completed before a table can be considered
normalized. (TCO 3) The conflicts between design
efficiency, information requirements, and
processing speed are often resolved through
12
CIS 336 Course Future Starts / cis336.com
CIS 336 Quiz 2 (Devry) For more course tutorials
visit www.cis336.com   (TCO 2) Explain what a
composite attribute is (TCO 1) Data constitutes
the building blocks of (TCO 1) Successful
database design is first and foremost based on
_____________ requirements. (TCO 1) The lowest
level in a database hierarchy is the ____________
or value as it is often referred
13
CIS 336 Course Future Starts / cis336.com
CIS 336 Quiz 3 (Devry) For more course tutorials
visit www.cis336.com   (TCO 7) Which of the
following types of columns will automatically
right-align the data when it is displayed? (TCO
7) Which of the following SQL statements will
display the profit generated by each book
currently stored in the BOOKS table? (You do not
need to see the table structure for this question)
14
CIS 336 Course Future Starts / cis336.com
CIS 336 Quiz 4 (Devry) For more course tutorials
visit www.cis336.com   (TCO 8) If a Cartesian
join is used to link table A which contains five
rows to table B which contains eight rows, there
will be _______ rows in the results. (TCO 8)
Which of the following statements will produce
the value 21.1? (TCO 8) Which of the following
format elements will display insignificant
leading zeros?
15
CIS 336 Course Future Starts / cis336.com
CIS 336 Quiz 5 (Devry) For more course tutorials
visit www.cis336.com   (TCO 6) Which of the
following keywords is used to remove a row in a
table? (TCO 6) When using the ALTER TABLE...DROP
COLUMN command, which of the following is NOT
correct? (TCO 6) Which of the following commands
will add a new column named FIRSTORDERDATE to the
CUSTOMERS table to store the date that the
customer first placed an order with the company?
16
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 1 iLab 1 Devry University
(Devry) For more course tutorials
visit www.cis336.com 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.
17
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 2 Assignment 1 Models for
Competitive Dynamics (2 Papers) For more course
tutorials visit www.cis336.com   This Tutorial
contains 2 Papers/Tutorial CIS 336 Week 2
Assignment 1 Models for Competitive
Dynamics Assignment 1 Models for Competitive
Dynamics Due Week 2 and worth 100 points
18
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 2 iLab 2 Devry University
(Devry) For more course tutorials
visit www.cis336.com   Lab two introduces the
next step in creating a data model, the Entity
Relationship Diagram (ERD). You will be given a
business scenario for a company named Clapham
Specialty Store, which is a small specialist
grocery and delicatessen. The business
specifications will outline a number of things
about the business, some of which will apply
directly to the database you are being asked to
model.
19
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 3 Group Project Task 1 Data Model
(Devry) For more course tutorials
visit www.cis336.com 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.
20
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 3 iLab 3 Devry University
(Devry) For more course tutorials
visit www.cis336.com Beginning with this lab,
and continuing through the remaining weeks you
will be doing all of your work in Oracle itself.
The editor interface to the Oracle server is
SQLPlus, and by now you have received your logon
ID and password and should have at least made
sure you can connect. If for any reason you have
not done so, please do so now before continuing
any further.
21
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 4 Assignment 2 Telecommuting and the
Mobile Worker (2 Papers) For more course
tutorials visit www.cis336.com This Tutorial
contains 2 Papers/Tutorial CIS 336 Week 4
Assignment 2 Telecommuting and the Mobile
Worker Assignment 2 Telecommuting and the Mobile
Worker Due Week 4 and worth 100 points
22
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 4 Group Project Task 2 (Devry) For
more course tutorials visit www.cis336.com Task
2 - Logical Model (30 points) Using the Oracle
SQLPlus editor, develop a database for MiniQuest
based on your data model. The database should
contain all the tables and attributes discussed
in the project specifications. Be sure to use
your data dictionary when creating your tables.
23
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 4 iLab 4 Devry University
(Devry) For more course tutorials
visit www.cis336.com   Lab 4 of 7 Building the
Physical Model (28 points) Submit your assignment
to the Dropbox located on the silver tab at the
top of this page. For instructions on how to use
the Dropbox, please click here. (See
Syllabus/"Due Dates for Assignments Exams" for
due dates.) L A B O V E R V I E W
Scenario/Summary Lab 4 will introduce the
various aspects of the SQL select statement and
the methods of retrieving data from the database
tables.
24
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 5 Group Project Task 3 (Devry) For
more course tutorials visit www.cis336.com Task
3 - Verification of Logical Model(45
points) 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).
25
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 5 iLab 5 Devry University
(Devry) For more course tutorials
visit www.cis336.com   Lab 5 of 7 Retreiving
data from Multiple Tables (28 points) Submit your
assignment to the Dropbox located on the silver
tab at the top of this page. For instructions on
how to use the Dropbox, please click here. (See
Syllabus/"Due Dates for Assignments Exams" for
due dates.) L A B O V E R V I E W
Scenario/Summary Lab 5 deals with writing queries
using multiple tables as covered in the reading
and lecture material this week
26
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 6 Assignment 3 IT Support for
Virtual Teams (2 Papers) For more course
tutorials visit www.cis336.com   This Tutorial
contains 2 Papers/Tutorial CIS 336 Week 6
Assignment 3 IT Support for Virtual
Teams Assignment 3 IT Support for Virtual
Teams Due Week 6 and worth 100 points
27
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 6 Group Project Task 4 (Devry) For
more course tutorials visit www.cis336.com   Task
4 - Verification of Transaction Processing (30
points) Develop a query that will identify and
mark inactive those customers that have bills
overdue by more than 30 days (this can usually be
done using a sub-query). Remember, you are only
marking a customer as inactive, not actually
deleting the customer record from the system.
28
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 6 iLab 6 Devry University
(Devry) For more course tutorials
visit www.cis336.com   Week 6. L A B S T E P S
STEP 1 Back to top Using the BOOK_CUSTOMER table
and the NVL function, create a query that will
return a list containing the customer number,
first name, last name, and the characters NOT
REFERRED if the customer was not referred by
another customer. Give the derived column an
alias of REFERRED BY. Do not list any customers
that were referred by another customer.
29
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 7 Assignment 4 Virtualization and
Cloud Computing World (2 Papers) For more course
tutorials visit www.cis336.com   This Tutorial
contains 2 Papers/Tutorial CIS 336 Week 7
Assignment 4 Virtualization and Cloud Computing
World Assignment 4 Virtualization and Cloud
Computing World Due Week 7 and worth 100 points
30
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 7 Group Project Task 5 (Devry) For
more course tutorials visit www.cis336.com Develo
p 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
31
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 7 iLab 7 Devry University
(Devry) For more course tutorials
visit www.cis336.com   L A B O V E R V I E W
Scenario/Summary There is a lot more to a
database than just tables and the data in them. A
very important part of database security has to
do with using and understanding Database Views.
Being able to enhance the efficiency of the
database tables by using additional indexes is
also a very important aspect of database
development.
32
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 8 Case Study 1 Disneys ITILJourney
(2 Papers) For more course tutorials
visit www.cis336.com   CIS 336 Week 8 Case Study
1 Disneys ITIL Journey Case Study 1 Disneys
ITIL Journey Due Week 8 and worth 70 points
33
CIS 336 Course Future Starts / cis336.com
CIS 336 Week 9 Case Study 2 Federal CIO Councils
Bring Your Own Device (BYOD) Toolkit (2
Papers) For more course tutorials
visit www.cis336.com   This Tutorial contains 2
Papers/Tutorial CIS 336 Week 9 Case Study 2
Federal CIO Councils Bring Your Own Device
(BYOD) Toolkit Case Study 2 Federal CIO
Councils Bring Your Own Device (BYOD)
Toolkit Due Week 9 and worth 70 points
34
CIS 336 Course Future Starts / cis336.com
The Best way to predict the Future is to create
it.....To Best way....
www.cis336.com