CIS 336 PAPERS Inspiring Minds/cis336papers.com

1
CIS 336 PAPERS Inspiring Minds/cis336papers.com
2
CIS 336 PAPERS Inspiring Minds
CIS 336 Entire Course Devry University
(Devry) FOR MORE CLASSES VISIT www.cis336papers.co
m   CIS 336 Entire Course Devry University
3
CIS 336 PAPERS Inspiring Minds
CIS 336 All iLabs Week 1 to Week 7 Devry
University (Devry) FOR MORE CLASSES VISIT
www.cis336papers.com   CIS 336 All iLabs Week 1
to Week 7 Devry University
4
CIS 336 PAPERS Inspiring Minds
CIS 336 Final Exam 1 (Devry) FOR MORE CLASSES
VISIT www.cis336papers.com   1. (TCO 1) Most DBMS
are referred to as _____________database
management systems. (Points 4) elemental linked
hierarchical relational
5
CIS 336 PAPERS Inspiring Minds
CIS 336 Final Exam 2 (Devry) FOR MORE CLASSES
VISIT www.cis336papers.com   1. (TCO 1) Most DBMS
are referred to as _____________database
management systems. (Points 4) elemental linked
hierarchical relational
6
CIS 336 PAPERS Inspiring Minds
CIS 336 Final Exam 3 (Devry) FOR MORE CLASSES
VISIT www.cis336papers.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.
7
CIS 336 PAPERS Inspiring Minds
CIS 336 Final Exam 3 (Devry) FOR MORE CLASSES
VISIT www.cis336papers.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.
8
CIS 336 PAPERS Inspiring Minds
CIS 336 Final Exam 4 Sets of Answers (Devry) FOR
MORE CLASSES VISIT www.cis336papers.com   CIS 336
Final Exam 4 Sets of Answers
9
CIS 336 PAPERS Inspiring Minds
CIS 336 Quiz 1 (Devry) FOR MORE CLASSES
VISIT www.cis336papers.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
10
CIS 336 PAPERS Inspiring Minds
CIS 336 Quiz 2 (Devry) FOR MORE CLASSES
VISIT www.cis336papers.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.
11
CIS 336 PAPERS Inspiring Minds
CIS 336 Quiz 3 (Devry) FOR MORE CLASSES
VISIT www.cis336papers.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)
12
CIS 336 PAPERS Inspiring Minds
CIS 336 Quiz 4 (Devry) FOR MORE CLASSES
VISIT www.cis336papers.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?
13
CIS 336 PAPERS Inspiring Minds
CIS 336 Quiz 5 (Devry) FOR MORE CLASSES
VISIT www.cis336papers.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?
14
CIS 336 PAPERS Inspiring Minds
CIS 336 Week 1 iLab 1 Devry University (Devry)
FOR MORE CLASSES VISIT www.cis336papers.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.
15
CIS 336 PAPERS Inspiring Minds
CIS 336 Week 2 iLab 2 Devry University
(Devry) FOR MORE CLASSES VISIT www.cis336papers.co
m   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.
16
CIS 336 PAPERS Inspiring Minds
CIS 336 Week 3 Group Project Task 1 Data Model
(Devry) FOR MORE CLASSES VISIT www.cis336papers.co
m   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.
17
CIS 336 PAPERS Inspiring Minds
CIS 336 Week 3 iLab 3 Devry University
(Devry) FOR MORE CLASSES VISIT www.cis336papers.co
m   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.
18
CIS 336 PAPERS Inspiring Minds
CIS 336 Week 4 Group Project Task 2 (Devry) FOR
MORE CLASSES VISIT www.cis336papers.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.
19
CIS 336 PAPERS Inspiring Minds
CIS 336 Week 4 iLab 4 Devry University
(Devry) FOR MORE CLASSES VISIT www.cis336papers.co
m   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.)
20
CIS 336 PAPERS Inspiring Minds
CIS 336 Week 5 Group Project Task 3 (Devry) FOR
MORE CLASSES VISIT www.cis336papers.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.
21
CIS 336 PAPERS Inspiring Minds
CIS 336 Week 5 iLab 5 Devry University (Devry)
FOR MORE CLASSES VISIT www.cis336papers.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.)
22
CIS 336 PAPERS Inspiring Minds
CIS 336 Week 6 Group Project Task 4 (Devry) FOR
MORE CLASSES VISIT www.cis336papers.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.
23
CIS 336 PAPERS Inspiring Minds
CIS 336 Week 6 iLab 6 Devry University (Devry)
FOR MORE CLASSES VISIT www.cis336papers.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.
24
CIS 336 PAPERS Inspiring Minds
CIS 336 Week 7 Group Project Task 5 (Devry) FOR
MORE CLASSES VISIT www.cis336papers.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
25
CIS 336 PAPERS Inspiring Minds
CIS 336 Week 7 iLab 7 Devry University (Devry)
FOR MORE CLASSES VISIT www.cis336papers.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.
26
CIS 336 PAPERS Inspiring Minds