cis 336 aid Focus Dreams/cis336aiddotcom

1
cis 336 aid Focus Dreams/cis336aiddotcom

•  
• FOR MORE CLASSES VISIT
• www.cis336aid.com

2
CIS 336 Final Exam (Feb 2016)   FOR MORE CLASSES
VISIT www.cis336aid.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? Question 2. 2. (TCO 1) A relational
DBMS provides protection of the _____ through
security, control, and recovery facilities.
Question 3. 3. (TCO 2) A relationship is an
association between _____ Question 4. 4. (TCO 2)
A _____ key is a key that is composed of more
than one attribute.
3
CIS 336 Final Exam 1 (Devry)   FOR MORE CLASSES
VISIT www.cis336aid.com 1. (TCO 1) Most DBMS are
referred to as _____________database management
systems. (Points 4) elementallinkedhierarchica
lrelational 2. (TCO 1) Data constitutes the
building blocks of _____________. (Points
4) informationprocessingapplicationsprogramming
.
4
CIS 336 Final Exam 2 (Devry)   FOR MORE CLASSES
VISIT www.cis336aid.com 1. (TCO 1) Most DBMS are
referred to as _____________database management
systems. (Points 4) elementallinkedhierarchica
lrelational 2. (TCO 1) A relational DBMS
provides protection of the _______________________
through security, control, and recovery
facilities. (Points 4)
5
CIS 336 Final Exam 3 (Devry)   FOR MORE CLASSES
VISIT www.cis336aid.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? 3. (TCO 3) Explain in what two
specific cases presented in the text composite
primary keys are particularly useful. (Points
15).
6
CIS 336 Final Exam 4 (Devry)   FOR MORE CLASSES
VISIT www.cis336aid.com   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.
7
CIS 336 Final Exam 4 Sets of Answers
(Devry)   FOR MORE CLASSES VISIT www.cis336aid.com
  CIS 336 Final Exam 4 Sets of Answers.
8
CIS 336 Final Exam Guide   FOR MORE CLASSES
VISIT www.cis336aid.com 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. 3) What is at the
center of the project triangle? 4) This is a text
message that is stored on a users computer by a
Web server that helps trace the users browsing
habits. 5) All of the following are risks
associated with IS outsourcing EXCEPT.
9
CIS 336 Group Project   FOR MORE CLASSES
VISIT www.cis336aid.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 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 336 iLab 1 Normal Forms and Entity
Relationship Diagrams   FOR MORE CLASSES
VISIT www.cis336aid.com   CIS336 Lab 1 Normal
Forms and Entity Relationship Diagrams
Introduction In 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 336 iLab 2 The Expanded Entity Relationship
Diagram   FOR MORE CLASSES VISIT www.cis336aid.com
  CIS336 Lab 2 The Expanded Entity Relationship
Diagram LAB OVERVIEW Scenario and Summary This
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. There
is a table that lists the entities (tables) that
will be needed for the database and related
attributes (columns) for each entity.
12
CIS 336 iLab 3 Building the Physical   FOR MORE
CLASSES VISIT www.cis336aid.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 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. Your job will be to use the ERD
Diagram found below as a guide to define the
table structures and constraints using both
CREATE TABLE and ALTER TABLE statements.
13
CIS 336 iLab 4 Introduction to Select, Insert,
Update, and Delete Statements (only SQL Command,
No output)   FOR MORE CLASSES VISIT www.cis336aid.
com CIS336 Lab 4 Introduction to Select,
Insert, Update, and Delete Statements LAB
OVERVIEW Lab 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
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 .
14
CIS 336 iLab 5 Joining Tables   FOR MORE CLASSES
VISIT www.cis336aid.com   CIS336 Lab5 Joining
Tables LAB OVERVIEW Scenario and Summary Lab 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). Follow the
instructions in the file CreateOMTables.docx to
create your database, tables, and data. A few
IMPORTANT things to note if using EDUPE MySQL.
15
CIS 336 iLab7 Working with Views   FOR MORE
CLASSES VISIT www.cis336aid.com   CIS-336 Lab7
Working with Views LAB OVERVIEW Lab 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. A few
IMPORTANT things to note if using EDUPE MySQL
There can be NO SPACES in alias names given to
a column. For example Select unit_price as
Retail Price from items
16
CIS 336 Quiz 1 (Devry)   FOR MORE CLASSES
VISIT www.cis336aid.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 (TCO
3) The PK must uniquely identify each entity
instance. A primary key must be able to guarantee
unique values. It cannot contain nulls. This
rationale belongs to (TCO 9) The SQL command that
lets you insert data into a table, one row at a
time, is _____________. (TCO 4) Which command is
used to restore the table's contents to their
default values?
17
CIS 336 Quiz 2 (Devry)   FOR MORE CLASSES
VISIT www.cis336aid.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 (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 336 Quiz 3 (Devry)   FOR MORE CLASSES
VISIT www.cis336aid.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? (TCO 7)
Which of the following operators would be most
appropriate to determine whether or not the
retail price of a book is at least 24.00?
19
CIS 336 Quiz 4 (Devry)   FOR MORE CLASSES
VISIT www.cis336aid.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? (TCO 8) Oracles pseudo table used
only for cases where a table is not really needed
is _________? (TCO 7) Using the BOOK_CUSTOMER and
BOOK_ORDER tables shown below for reference which
SQL statement will return the same results as the
following SQL statement?
20
CIS 336 Quiz 5 (Devry)   FOR MORE CLASSES
VISIT www.cis336aid.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? (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? (TCO 8) Which of the following is NOT a
valid statement?
21
CIS 336 Week 2 Quiz (New)   FOR MORE CLASSES
VISIT www.cis336aid.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 _____ Question 2.
(TCO 1) The DBMS allows you to extrapolate
information from your data by using a _____
Question 3. (TCO 1) A database row (record)
consists of _____ Question 4. (TCO 2) In Oracle,
a _____ is automatically constrained to be unique
and not null. Question 5. (TCO 2) A verb
associating two nouns in a business rule usually
translates to a(n) ___ in the data model.
Question 6. (TCO 2) In a relationship, when a
primary key from one table is also defined in a
second table, the field is referred to as a _____
in the second table. Question 7.
22
CIS 336 Week 3 Quiz (New)   FOR MORE CLASSES
VISIT www.cis336aid.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 _____ Question 3. (TCO 3)
(TCO 3) A table is not in 1NF if _______________.
Question 4. (TCO 9) All of following are examples
of DML commands except _____ Question 5. (TCO 4)
Which of the following is not considered a
database object? Question 6. (TCO 4) In Oracle,
the DEFAULT constraint is used to _____ Question
7. (TCO 4) The SQL command that lets you save
your work to disk, is _____ Question 8.
23
CIS 336 Week 4 Quiz (New)   FOR MORE CLASSES
VISIT www.cis336aid.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? 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? Question
3. (TCO 7) Based upon the contents of the BOOKS
table shown below, which of the following is a
valid SQL statement? Question 4. (TCO 7) Which of
the following operators would be most appropriate
to determine whether or not the retail price of a
book is at least 24.00? Question 5.
24
CIS 336 Week 5 Quiz (New)   FOR MORE CLASSES
VISIT www.cis336aid.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.
Question 2. (TCO 8) Which SQL function converts a
value to a particular string format? Question 3.
(TCO 8) Based upon the contents of the BOOK_ORDER
table shown below, which of the following SQL
statements will display only those orders shipped
to the zip code zone that begins with 323?
Question 4. (TCO 8) Oracles pseudo table used
only for cases where a table is not really needed
is _____ Question 5.
25
CIS 336 Week 6 Quiz (New)   FOR MORE CLASSES
VISIT www.cis336aid.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?
Question 2. (TCO 9) If the _____ clause of the
UPDATE command is omitted, then all the rows in
the specified table will be changed. Question 3.
(TCO 6) Which of the following commands will
increase the size of the CITY column in the
CUSTOMERS table from 12 to 20 and increase size
of the LASTNAME column from 10 to 14? Question 4.
(TCO 8) Based upon the contents of the BOOKS
table shown below, which of the following SQL
statements will return the number of different
categories contained in the table? Question 5.
(TCO 9) Which of the following is not a valid SQL
command?
26
CIS336 iLab 6 Group Functions and
Subqueries   FOR MORE CLASSES VISIT www.cis336aid.
com CIS336 Lab 6 Group Functions and Subqueries
LAB OVERVIEW Scenario and Summary Lab 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). Follow the instructions in
the file CreateOMTables.docx to create your
database, tables, and data. A few IMPORTANT
things to note if using EDUPE MySQL There can
be NO SPACES in alias names given to a column.
For example Select unit_price as Retail Price
from items
27
cis 336 aid Focus Dreams/cis336aiddotcom

•  
• FOR MORE CLASSES VISIT
• www.cis336aid.com