CIS 336Course Real Knowledge / cis336.com

1
CIS 336Course Real Knowledge / cis336.com
The Best way to predict the Future is to create
it.....To Best way....
www.cis336.com
2
CIS 336Course Real Knowledge / 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 336Course Real Knowledge / 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 336Course Real Knowledge / 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) informationprocessingapplicationsp
rogramming 3. (TCO 2) If a foreign key contains
either matching values or nulls,
5
CIS 336Course Real Knowledge / 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) usernetworksystemdatabase 3. (TCO 2) If a
foreign key contains either matching values or
nulls, the table(s) that make use of such a
foreign key is/are said to exhibit __________
integrity. (Points 4) referential
6
CIS 336Course Real Knowledge / 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? 3. (TCO 3) Explain in what two
specific cases presented in the text composite
primary keys are particularly useful. (Points
15) 4. (TCO 7) How are comparisons done on
character string data in a queries WHERE clause,
and why would this be especially useful in
comparing certain attributes? (Points 15)
7
CIS 336Course Real Knowledge / 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. 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 an
8
CIS 336Course Real Knowledge / 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 336Course Real Knowledge / 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. 3) What is at the center of the project
triangle? 4) This is a text message that is
stored on a users computer by a Web server that
helps trace the users browsing habits. 5) All
of the following are risks associated with IS
outsourcing EXCEPT
10
CIS 336Course Real Knowledge / 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 (TCO 3) The PK must
uniquely identify each entity instance. A primary
key must be able to guarantee unique values. It
cannot contain nulls. This rationale belongs to
11
CIS 336Course Real Knowledge / 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 (TCO 2) The term
_____________ design is used to refer to the task
of creating the conceptual data model represented
by an Entity Relationship Diagram (ERD).
12
CIS 336Course Real Knowledge / 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) (TCO 7) Which of the following will
display the new retail price of each book as 20
percent more than it originally cost? (TCO 7)
Which of the following operators would be most
appropriate to determine whether or not the
retail price of a book is at least 24.00? (TCO
7) The ______________________ comparison operator
is used to indicate that a data value must fall
within a range of values to be included in the
query results.
13
CIS 336Course Real Knowledge / 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? (TCO 8) Oracles pseudo table used only
for cases where a table is not really needed is
_________? (TCO 7) Using the BOOK_CUSTOMER and
BOOK_ORDER tables shown below for reference which
SQL statement will return the same results as the
following SQL statement?
14
CIS 336Course Real Knowledge / 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? (TCO 8) Which of the following is NOT a
valid statement?
15
CIS 336Course Real Knowledge / 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.
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,
16
CIS 336Course Real Knowledge / 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 Competition has, since the 90s, led to
wider gaps between industry leaders and laggards.
There are more winner-take-all environments and
greater churns among industry sector rivals. We
have witnessed sharp increases in quality and
quantity of IT (Information Technology)
investments
17
CIS 336Course Real Knowledge / 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. There is a table which lists the entities
(tables) that will be needed for the database and
related attributes (columns) for each entity.
There is also a column that lists specific
information about the entity that will be helpful
i
18
CIS 336Course Real Knowledge / cis336.com
CIS 336 Week 3 Group Project Task 1 Data Model
(Devry) or 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. (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).
19
CIS 336Course Real Knowledge / 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. If for any reason you cannot connect
then you need to let the instructor know ASAP so
that any problems can be resolved. Before
attempting Lab 3, you need to be sure you have
read through the SQLPlus tutorial which can be
found in Doc Sharing as well as under the
SQLPlus Tutorial tab in Week
20
CIS 336Course Real Knowledge / 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 The number
of American telecommuters is expected to increase
by 29 million telecommuters or 43 of the
workforce by 2016 as more work gets performed
from remote locations. Mobile workers can work
from wherever they are and use the IT / IS
technology necessary to access co-workers,
company or corporate infrastructure, intranets,
and other information sources
21
CIS 336Course Real Knowledge / 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. 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. To submit this task, you need to
create a file in notepad called TEAM_X_TASK2
22
CIS 336Course Real Knowledge / 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. The lab will utilize a set of tables
found in the script file (LeeBooks.sql) found in
the Doc Sharing area of the website. You will
need to download the fil
23
CIS 336Course Real Knowledge / 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. In some cases,
you will be given the option to write a query
using either the TRADITIONAL method of joining
tables or using the JOIN key word. In some cases,
yo
24
CIS 336Course Real Knowledge / 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 Global
organizations have branches that are located in
multiple countries. Some of these organizations
develop software and take advantage of the global
talent pool of software developers while others
have global technical support teams, customer s
25
CIS 336Course Real Knowledge / 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. To
submit this task, create a heading called MODIFY
STATEMENTS in your group project SQL script, and
name the file TEAM_X_TASK4.TXT. This should be
the same script that contains your DROP TABLE,
CREATE TABLE, and INSERT statements. Once you
have verified that your SQL statement or
statements work, create a spooled output showing
the results of your statements.
26
CIS 336Course Real Knowledge / 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. STEP 2
Back to top Using the BOOKS table and the SUBSTR
function, create a query that will return a list
of book ISBN codes and the book title for all the
computer books. Format the ISBN code to display
as 9-999-99999-9 (e.g., 1059831198 would display
as 1-059-83119-8) STEP 3 Back to top Using the BO
27
CIS 336Course Real Knowledge / 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
28
CIS 336Course Real Knowledge / cis336.com
The Best way to predict the Future is to create
it.....To Best way....
www.cis336.com