CIS 336 STUDY Education key to Success / cis336study.com

1
CIS 336 STUDY Education key to Success /
cis336study.com
2
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Final Exam 1 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• 1. (TCO 1) Most DBMS are referred to as
  _____________database management systems. (Points
  4)

3
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Final Exam 2 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• 1. (TCO 1) Most DBMS are referred to as
  _____________database management systems. (Points
  4)

4
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Final Exam 3 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336study.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

5
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Final Exam 4 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336study.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

6
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Final Exam 4 Sets of Answers (Devry)
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• CIS 336 Final Exam 4 Sets of Answers

7
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Group Project
• FOR MORE CLASSES VISIT
• www.cis336study.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

8
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 iLab 1 Normal Forms and Entity
  Relationship Diagrams
• FOR MORE CLASSES VISIT
• www.cis336study.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
  

9
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 iLab 2 The Expanded Entity Relationship
  Diagram
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• CIS336 Lab 2 The Expanded Entity Relationship
  Diagram
• LAB OVERVIEW
• Scenario and Summary

10
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 iLab 3 Building the Physical
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• CIS-336 Lab 3 Building the Physical
• LAB OVERVIEW
• Scenario and Summary

11
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 iLab 4 Introduction to Select, Insert,
  Update, and Delete Statements (only SQL Command,
  No output)
• FOR MORE CLASSES VISIT
• www.cis336study.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

12
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 iLab 5 Joining Tables
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• CIS336 Lab5 Joining Tables
• LAB OVERVIEW
• Scenario and Summary

13
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 iLab7 Working with Views
• FOR MORE CLASSES VISIT
• www.cis336study.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

14
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Quiz 1 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336study.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.

15
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Quiz 2 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• (TCO 2) Explain what a composite attribute is
•  
• (TCO 1) Data constitutes the building blocks of

16
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Quiz 3 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• (TCO 7) Which of the following types of columns
  will automatically right-align the data when it
  is displayed?
•  

17
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Quiz 4 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336study.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.

18
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Quiz 5 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336study.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

19
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Week 2 Quiz (New)
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• Question 1. (TCO 1) Raw facts,
  such as a telephone number, a birth date, and a
  customer name, are also referred to as _____

20
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Week 3 Quiz (New)
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• 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

21
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Week 4 Quiz (New)
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• 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?

22
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Week 5 Quiz (New)
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• 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.

23
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS 336 Week 6 Quiz (New)
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
•  
• Question 1. (TCO 6) Which of
  the following keywords can be used to change the
  size, datatype, or default value of an existing
  column?

24
CIS 336 STUDY Education key to Success /
cis336study.com

• CIS336 iLab 6 Group Functions and Subqueries
• FOR MORE CLASSES VISIT
• www.cis336study.com
•  
• CIS336 Lab 6 Group Functions and Subqueries
• LAB OVERVIEW
• Scenario and Summary
• Lab 6 will introduce the concept of grou

25
CIS 336 STUDY Education key to Success /
cis336study.com