CIS 336 Inspiring Innovation--tutorialrank.com

1
CIS 336 Inspiring Innovation / tutorialrank.com
2
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Final Exam (April,2019)  For more course
tutorials visit www.tutorialrank.com   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?  
3
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Final Exam 1   For more course
tutorials visit www.tutorialrank.com Tutorial
Purchased 3 Times, Rating A       1. (TCO 1)
Most DBMS are referred to as _____________database
management systems. (Points 4)
elementallinked
4
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Final Exam 2  For more course tutorials
visit www.tutorialrank.com Tutorial Purchased 2
Times, Rating B       1. (TCO 1) Most DBMS are
referred to as _____________database management
systems. (Points 4) elementallinkedhierarchic
al
5
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Final Exam 3  For more course tutorials
visit www.tutorialrank.com Tutorial Purchased 4
Times, Rating A     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
6
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Final Exam 4 Sets of Answers  For more
course tutorials visit www.tutorialrank.com Tutori
al Purchased 4 Times, Rating A   CIS 336 Final
Exam 4 Sets of Answers
7
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Final Exam 4  For more course tutorials
visit www.tutorialrank.com Tutorial 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
8
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Group Project For more course tutorials
visit www.tutorialrank.com   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
9
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 iLab 1 Normal Forms and Entity
Relationship Diagrams For more course tutorials
visit www.tutorialrank.com   CIS336 Lab 1 Normal
Forms and Entity Relationship Diagrams Introductio
nIn 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
10
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 iLab 2 The Expanded Entity Relationship
Diagram For more course tutorials
visit www.tutorialrank.com   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
11
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 iLab 3 Building the Physical For more
course tutorials visit www.tutorialrank.com   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
12
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 iLab 4 Introduction to Select, Insert,
Update, and Delete Statements (only SQL Command,
No output)  For more course tutorials
visit www.tutorialrank.com   CIS336 Lab 4
Introduction to Select, Insert, Update, and
Delete Statements LAB OVERVIEWLab 4 will
introduce the various aspects of the SQL select
statement and the methods of retrieving data from
the database tables. This lab will also introduce
the fundamentals of updating and deleting
records. This lab may be
13
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 iLab 5 Joining Tables For more course
tutorials visit www.tutorialrank.com   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
14
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 iLab 6 Group Functions and Subqueries For
more course tutorials visit www.tutorialrank.com  
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
15
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 iLab7 Working with Views For more course
tutorials visit www.tutorialrank.com   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
16
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Quiz 1  For more course tutorials
visit www.tutorialrank.com Tutorial Purchased 2
Times, Rating B       (TCO 3) Normalization
works through a series of stages called normal
forms. Typically _________ stages must be
completed before a table can be considered
normalized.
17
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Quiz 2 For more course tutorials
visit www.tutorialrank.com Tutorial Purchased 3
Times, Rating A       (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.
18
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Quiz 3  For more course tutorials
visit www.tutorialrank.com Tutorial Purchased 4
Times, Rating A    (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)
19
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Quiz 4  For more course tutorials
visit www.tutorialrank.com Tutorial Purchased 3
Times, Rating A   (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?
20
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Quiz 5  For more course tutorials
visit www.tutorialrank.com Tutorial Purchased 2
Times, Rating B   (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 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Week 2 Quiz (New)  For more course
tutorials visit www.tutorialrank.com   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 _____
22
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Week 3 Quiz (New)  For more course
tutorials visit www.tutorialrank.com   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 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Week 4 Quiz (New)  For more course
tutorials visit www.tutorialrank.com   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?
24
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Week 5 Quiz (New)  For more course
tutorials visit www.tutorialrank.com   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.  
25
CIS 336 Inspiring Innovation-- tutorialrank.com
CIS 336 Week 6 Quiz (New)  For more course
tutorials visit www.tutorialrank.com   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?  
26
CIS 336 Inspiring Innovation / tutorialrank.com