CIS 336 Course Experience Tradition /tutorialrank.com

1
CIS 336 Course Experience Tradition
/tutorialrank.com
The Best way to predict the Future is to create
it.....To Best way....
www.tutorialrank.com
2
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Entire Course Devry University
For more course tutorials visit www.tutorialr
ank.com CIS 336 Entire Course Devry University
3
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Final Exam 1 For more course tutorials
visit www.tutorialrank.com 1. (TCO 1) Most DBMS
are referred to as _____________database
management systems. (Points 4)
elementallinkedhierarchicalrelational
4
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Final Exam 2 For more
course tutorials visit www.tutorialrank.com      
1. (TCO 1) Most DBMS are referred to as
_____________database management systems. (Points
4) elementallinkedhierarchicalrelational
5
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Final Exam 3 For more
course tutorials visit www.tutorialrank.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?
6
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Final Exam 4 Sets of Answers
For more course tutorials
visit www.tutorialrank.com CIS 336 Final Exam 4
Sets of Answers
7
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Final Exam 4 For more
course tutorials visit www.tutorialrank.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".
8
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Quiz 1 For more course tutorials
visit www.tutorialrank.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
9
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Quiz 3 For more course
tutorials visit www.tutorialrank.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?
10
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Quiz 4 For more course
tutorials visit www.tutorialrank.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?
11
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Quiz 5 For more course
tutorials visit www.tutorialrank.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?
12
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Week 1 iLab 1 Devry University
For more course tutorials
visit www.tutorialrank.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.
13
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Week 2 iLab 2 Devry University
For more course tutorials
visit www.tutorialrank.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
14
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Week 3 Group Project Task 1 Data Model
For more course tutorials
visit www.tutorialrank.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).
15
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Week 3 iLab 3 Devry University
For more course tutorials
visit www.tutorialrank.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
3.
16
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Week 4 Group Project Task 2
For more course tutorials visit www.tutorialr
ank.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.
17
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Week 4 iLab 4 Devry University
For more course tutorials
visit www.tutorialrank.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
18
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Week 5 Group Project Task 3
For more course tutorials
visit www.tutorialrank.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). To submit
this task, add a comment heading called INSERT
STATEMENTS to your corrected SQL script from Task
2.
19
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Week 5 iLab 5 DevryUniversity For
more course tutorials visit www.tutorialrank.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,
20
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Week 6 Group Project Task 4 For
more course tutorials visit www.tutorialrank.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.
21
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Week 6 iLab 6 Devry University
For more course tutorials
visit www.tutorialrank.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
22
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Week 7 Group Project Task 5
For more course tutorials visit www.tutorialr
ank.com 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
23
CIS 336Course Experience Tradition
/tutorialrank.com
CIS 336 Week 7 iLab 7 Devry University
For more course tutorials
visit www.tutorialrank.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. Finally, being able to create and
use Database Sequences to automate some of the
sequential processes in the database can not only
save time but improve efficiency. In Lab 7, you
will have a chance to work with all three of
these areas. General Lab Information and
Considerations This lab will utilize the same set
24
CIS 336 Course Experience Tradition
/tutorialrank.com
The Best way to predict the Future is to create
it.....To Best way....
www.tutorialrank.com