CIS 336 Enhance teaching - tutorialrank.com

1
CIS 336 Enhance teaching / tutorialrank.com
2
CIS 336 Enhance teaching / tutorialrank.com
CIS 336 Final Exam (October,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 functio
3
CIS 336 Enhance teaching / 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 Enhance teaching / tutorialrank.com
CIS 336 Final Exam 2 For
more course tutorials visit www.tutorialrank.com T
utorial Purchased 2 Times, Rating B       1.
(TCO 1) Most DBMS are referred to as ________
5
CIS 336 Enhance teaching / tutorialrank.com
CIS 336 Final Exam 3 For
more course tutorials visit www.tutorialrank.com T
utorial 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 cities the company
has factories in. She writes the following
6
CIS 336 Enhance teaching / 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  
7
CIS 336 Enhance teaching / 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.
8
CIS 336 Enhance teaching / 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
9
CIS 336 Enhance teaching / 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, transformi
10
CIS 336 Enhance teaching / 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
11
CIS 336 Enhance teaching / 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
12
CIS 336 Enhance teaching / 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
13
CIS 336 Enhance teaching / 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 local copy of the
MySQL database running on your o
14
CIS 336 Enhance teaching / 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 local copy of the
MySQL database running on your o
15
CIS 336 Enhance teaching / 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
16
CIS 336 Enhance teaching / tutorialrank.com
CIS 336 Quiz 1 For more
course tutorials visit www.tutorialrank.com Tutori
al 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 Enhance teaching / 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 b
18
CIS 336 Enhance teaching / tutorialrank.com
CIS 336 Quiz 3 For more
course tutorials visit www.tutorialrank.com Tutori
al Purchased 4 Times, Rating A       (TCO 7)
Which of the following types of columns will
automatically right-align the data when it is
displayed?
19
CIS 336 Enhance teaching / tutorialrank.com
CIS 336 Quiz 4 For more
course tutorials visit www.tutorialrank.com Tutori
al 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.
20
CIS 336 Enhance teaching / tutorialrank.com
CIS 336 Quiz 5 For more
course tutorials visit www.tutorialrank.com Tutori
al 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
21
CIS 336 Enhance teaching / 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 Enhance teaching / 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 _____
23
CIS 336 Enhance teaching / 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 Enhance teaching / 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 Enhance teaching / 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 Enhance teaching / tutorialrank.com
aa