CIS 336 Slingshot Academy /snaptutorial.com

1
 CIS 336 Slingshot Academy snaptutorial
For more course Tutorials
www.snaptutorial.com
2
 CIS 336 Slingshot Academy snaptutorial
CIS 336 Entire Course
CIS 336 All iLabs Week 1 to Week 7 Devry
University
CIS 336 Entire Course Devry University
CIS 336 All iLabs Week 1 to Week 7 Devry
Universitye.
3
 CIS 336 Slingshot Academy snaptutorial
CIS 336 Final Exam 3
CIS 336 Final Exam 1
1. (TCO 1) Most DBMS are referred to as
_____________database management systems. (Points
4) elemental linked hierarchical relational 2.
(TCO 1) Data constitutes the building blocks of
_____________. (Points 4) information processing
applications programming
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)
4
 CIS 336 Slingshot Academy snaptutorial
CIS 336 Final Exam 4
CIS 336 Final Exam 4 Sets of Answers
CIS 336 Final Exam 4 Sets of Answers
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.
5
 CIS 336 Slingshot Academy snaptutorial
CIS 336 Quiz 2
CIS 336 Quiz 1
(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 (TCO 9)
The SQL command that lets you insert data into a
table, one row at a time, is _____________.
(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).
6
 CIS 336 Slingshot Academy snaptutorial
CIS 336 Quiz 4
CIS 336 Quiz 3
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 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?
7
 CIS 336 Slingshot Academy snaptutorial
CIS 336 Week 1 iLab 1 Devry University
CIS 336 Quiz 5
(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?
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.
8
 CIS 336 Slingshot Academy snaptutorial
CIS 336 Week 3 Group Project Task 1 Data Model
CIS 336 Week 2 iLab 2 Devry University
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
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).
9
 CIS 336 Slingshot Academy snaptutorial
CIS 336 Week 4 Group Project Task 2
CIS 336 Week 3 iLab 3 Devry University
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
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
10
 CIS 336 Slingshot Academy snaptutorial
CIS 336 Week 5 Group Project Task 3
CIS 336 Week 4 iLab 4 Devry University
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
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
11
 CIS 336 Slingshot Academy snaptutorial
CIS 336 Week 6 Group Project Task 4
CIS 336 Week 5 iLab 5 DevryUniversity
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
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.
12
 CIS 336 Slingshot Academy snaptutorial
CIS 339 Entire Course
CIS 336 Week 6 iLab 6 Devry University
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.
CIS 339iLab 1 System Requirements CIS/339 iLab 2
of 7 CIS 339iLab 3 - Structural Modeling - Class
Diagram and CRCs CIS 339iLab 4 - Sequence,
Communication, and State Diagrams CIS 339iLab 5 -
Package Diagrams CIS 339iLab 6 - CRCs, Contracts,
and Method Specifications CIS 339iLab 7 -
Object-Oriented Application Coding
13
 CIS 336 Slingshot Academy snaptutorial
CIS 336 Week 7 Group Project Task 5B
CIS 336 Week 7 iLab 7 Devry University
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
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 Customer Table A minimum of 12
customers (this will allow several channels to
have more than one customer selecting it as a
favorite channel) Billing Table
14
 CIS 336 Slingshot Academy snaptutorial
For more course Tutorials
www.snaptutorial.com