CIS 336 Course Experience Tradition / cis336.com

1
CIS Course Experience Tradition / cis336.com
CIS Course Experience Tradition / cis336.com
Education reform has as its main purpose to make
sure that the education delivered is of quality
For More Courses
For More Courses
Visit Now
Visit Now
www.cis336.com
www.cis336.com
Education reform has as its main purpose to make
sure that the education delivered is of quality
2
CIS Course Experience Tradition / cis336.com
CIS 336 Final Exam 1 (Devry)
1. (TCO 1) Most DBMS are referred to as
_____________database management systems. (Points
4) elementallinkedhierarchicalrelational
3
CIS Course Experience Tradition / cis336.com
CIS 336 Final Exam 2 (Devry)
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) user
4
CIS Course Experience Tradition / cis336.com
CIS 336 Final Exam 3 (Devry)
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)
5
CIS Course Experience Tradition / cis336.com
CIS 336 Final Exam 4 (Devry)
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.
6
CIS Course Experience Tradition / cis336.com
CIS 336 Final Exam 4 Sets of Answers (Devry)
CIS 336 Final Exam 4 Sets of Answers
7
CIS Course Experience Tradition / cis336.com
CIS 336 Final Exam Guide
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.
8
CIS Course Experience Tradition / cis336.com
CIS 336 Final Exam (Feb 2016)
CIS 336 Final Exam  Question 1. 1. (TCO 1) A DBMS
performs several important functions that
guarantee the integrity and consistency of the
data in the database. Which of the following is
NOT one of those functions? Question 2. 2. (TCO
1) A relational DBMS provides protection of the
_____ through security, control, and recovery
facilities.
9
CIS Course Experience Tradition / cis336.com
CIS 336 Group Project
This project is designed to touch all aspects of
the fundamental concepts of database design and
logical data modeling covered during the class.
Each student will be responsible for designing,
developing, and demonstrating the functionality
of a database created based on a set of business
specifications that you create. At the end of the
session, each student will submit a report that
includes the logical and physical design of the
database and demonstrates the database's ability
to deliver meaningful reports.
10
CIS Course Experience Tradition / cis336.com
CIS 336 iLab 1 Normal Forms and Entity
Relationship Diagrams
CIS336 Lab 1 Normal Forms and Entity
Relationship Diagrams IntroductionIn this
exercise, you will analyze a de-normalized data
set presented in the form of a spreadsheet. You
will next construct a series of dependency
diagrams, transforming the evolving data model
from First Normal Form (1NF), to Second Normal
Form (2NF), and finally to Third Normal Form
(3NF). When the model has reached 3NF, you will
construct the Entity Relationship Diagram (ERD)
depicting the logical design of the database.
11
CIS Course Experience Tradition / cis336.com
CIS 336 iLab 2 The Expanded Entity Relationship
Diagram
CIS336 Lab 2 The Expanded Entity Relationship
Diagram LAB OVERVIEWScenario and SummaryThis
lab introduces the next step in creating a data
model, the Entity Relationship Diagram (ERD). You
will be given a business scenario for a
University Medical Center, which is a small
community hospital. 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.
12
CIS Course Experience Tradition / cis336.com
CIS 336 iLab 3 Building the Physical
CIS-336 Lab 3 Building the Physical LAB
OVERVIEW Scenario and Summary The lab for this
week addresses taking a logical database design
(data model) and transforming it into a physical
model (tables, constraints, and relationships).
As part of the lab, you will need to download
the zip file titled CIS336Lab3Files from Doc
Sharing. This zip file contains the ERD, Data
Dictionary, and test data for the tables you
create as you complete this exercise.
13
CIS Course Experience Tradition / cis336.com
CIS 336 Week 4 Quiz (New)
CIS 336 Week 4 Quiz     Question
1.                  (TCO 7) Which of the
following types of columns will automatically
right-align the data when it is
displayed?     Question 2.                  (TCO
7) Which of the following symbols can be used to
denote that any and all characters following the
sign are eligible when used with LIKE?
14
CIS Course Experience Tradition / cis336.com
CIS 336 iLab 5 Joining Tables
CIS336 Lab5 Joining Tables LAB
OVERVIEWScenario and SummaryLab 5 will
introduce the concept of multi-table JOINS in
order to work with data in two or more related
tables simultaneously. This lab may be completed
using either DeVrysOmnymbus EDUPE-APP lab
environment, or a local copy of the MySQL
database running on your own computer using the
OM database tables. The lab will utilize a set of
tables that are represented by the ERD
(OM_ERD.docx) and are created and populated by
the script file (create_OM_db.sql).
15
CIS Course Experience Tradition / cis336.com
CIS 336 iLab7 Working with Views
CIS-336 Lab7 Working with Views LAB
OVERVIEWLab 7 will introduce the concept of
database views. This lab may be completed using
either DeVrysOmnymbus EDUPE-APP lab environment,
or a local copy of the MySQL database running on
your own computer using the OM database tables.
The lab will utilize a set of tables that are
represented by the ERD (OM_ERD.docx) and are
created and populated by the script file
(create_OM_db.sql). Follow the instructions in
the file CreateOMTables.docx to create your
database, tables, and data.
16
CIS Course Experience Tradition / cis336.com
CIS 336 Quiz 1 (Devry)
(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.
17
CIS Course Experience Tradition / cis336.com
CIS 336 Quiz 2 (Devry)
(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).
18
CIS Course Experience Tradition / cis336.com
CIS 336 Quiz 3 (Devry)
(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?
19
CIS Course Experience Tradition / cis336.com
CIS 336 Quiz 4 (Devry)
(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 _________?
20
CIS Course Experience Tradition / cis336.com
CIS 336 Quiz 5 (Devry)
(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?
21
CIS Course Experience Tradition / cis336.com
CIS 336 Week 2 Quiz (New)
CIS 336 Week 2 Quiz                               
                                Question
1.                  (TCO 1) Raw facts, such as a
telephone number, a birth date, and a customer
name, are also referred to as _____     Question
2.                  (TCO 1) The DBMS allows you
to extrapolate information from your data by
using a _____
22
CIS Course Experience Tradition / cis336.com
CIS 336 Week 3 Quiz (New)
CIS 336 Week 3 Quiz     Question
1.                  (TCO 3) When designing a
database, you should _____   Question
2.                  (TCO 3) A table that is in
1NF and includes no partial dependencies only is
said to be in _____
23
CIS Course Experience Tradition / cis336.com
CIS 336 Week 4 Quiz (New)
CIS 336 Week 4 Quiz     Question
1.                  (TCO 7) Which of the
following types of columns will automatically
right-align the data when it is
displayed?     Question 2.                  (TCO
7) Which of the following symbols can be used to
denote that any and all characters following the
sign are eligible when used with LIKE?
24
CIS Course Experience Tradition / cis336.com
CIS 336 Week 5 Quiz (New)
CIS 336 Week 5 Quiz   Question 1.                 
(TCO 8) The ____ set operator in SQL combines
rows from two queries and returns only the values
that are common between the two sets.   Question
2.                  (TCO 8) Which SQL function
converts a value to a particular string format?  
25
CIS Course Experience Tradition / cis336.com
CIS 336 Week 6 Quiz (New)
CIS 336 Week 6 Quiz     Question
1.                  (TCO 6) Which of the
following keywords can be used to change the
size, datatype, or default value of an existing
column?     Question 2.                  (TCO 9)
If the _____ clause of the UPDATE command is
omitted, then all the rows in the specified table
will be changed.
26
CIS Course Experience Tradition / cis336.com
CIS336 iLab 6 Group Functions and Subqueries
CIS336 Lab 6 Group Functions and Subqueries LAB
OVERVIEWScenario and SummaryLab 6 will
introduce the concept of group functions and
subqueries to meet more complex report
requirements. This lab may be completed using
either DeVrysOmnymbus EDUPE-APP lab environment,
or a local copy of the MySQL database running on
your own computer using the OM database tables.
The lab will utilize a set of tables that are
represented by the ERD (OM_ERD.docx) and are
created and populated by the script file
(create_OM_db.sql).
27
CIS Course Experience Tradition / cis336.com
Education reform has as its main purpose to make
sure that the education delivered is of quality
For More Courses
Visit Now
www.cis336.com