CIS 336 Education on your terms-tutorialrank.com

1
CIS 336 Education on your terms/tutorialrank.com
2
CIS 336Education on your terms/tutorialrank.com
CIS 336 All iLabs Week 1 to Week 7 Devry
University For more course
tutorials visit www.tutorialrank.com CIS 336
All iLabs Week 1 to Week 7 Devry University
3
CIS 336Education on your terms/tutorialrank.com
CIS 336 Entire Course Devry University
For more course tutorials
visit www.tutorialrank.com Tutorial Purchased 6
Times, Rating A CIS 336 Entire Course Devry
University
4
CIS 336Education on your terms/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)
elementallinkedhierarchical
5
CIS 336Education on your terms/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
2. (TCO 1) A relational DBMS provides protection
of the _______________________ through security,
control, and recovery facilities. (Points 4)
usernetwork
6
CIS 336Education on your terms/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?
7
CIS 336Education on your terms/tutorialrank.com
CIS 336 Final Exam 4 Sets of Answers
For more course tutorials
visit www.tutorialrank.com Tutorial Purchased 4
Times, Rating A CIS 336 Final Exam 4 Sets of
Answers
8
CIS 336Education on your terms/tutorialrank.com
CIS 336 Final Exam 4 For more
course tutorials visit www.tutorialrank.com Tutori
al Purchased 3 Times, Rating A 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.
9
CIS 336Education on your terms/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
10
CIS 336Education on your terms/tutorialrank.com
CIS 336 Quiz 2 For more course tutorials
visit www.tutorialrank.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
11
CIS 336Education on your terms/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?
12
CIS 336Education on your terms/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?
13
CIS 336Education on your terms/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?
14
CIS 336Education on your terms/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.
15
CIS 336Education on your terms/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,
16
CIS 336Education on your terms/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).
17
CIS 336Education on your terms/tutorialrank.com
CIS 336 Week 3 iLab 3 Devry University
For more course tutorials
visit www.tutorialrank.com Tutorial Purchased 4
Times, Rating A 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
18
CIS 336Education on your terms/tutorialrank.com
CIS 336 Week 4 Group Project Task 2
For more course tutorials
visit www.tutorialrank.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 336Education on your terms/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.
20
CIS 336Education on your terms/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
21
CIS 336Education on your terms/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,
22
CIS 336Education on your terms/tutorialrank.com
CIS 336 Week 6 Group Project Task 4
For more course tutorials
visit www.tutorialrank.com Tutorial Purchased 2
Times, Rating B 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 336Education on your terms/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 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-
24
CIS 336Education on your terms/tutorialrank.com
CIS 336 Week 7 Group Project Task 5
For more course tutorials
visit www.tutorialrank.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 336Education on your terms/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
26
CIS 336Education on your terms/tutorialrank.com