CIS 336 Imagine Your Future/newtonhelp.com

1
CIS 336 Imagine Your Future/newtonhelp
2
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 Final Exam (Feb 2016)
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
•  
• CIS 336 Final Exam
• Question 1. 1. (TCO 1) A DBMS performs several
  important

3
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 Final Exam 1
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
•  
• 1. (TCO 1) Most DBMS are referred to as
  _____________database management systems. (Points
  4)

4
CIS 336 Imagine Your Future/newtonhelp

•  
• CIS 336 Final Exam 2
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
•  
• 1. (TCO 1) Most DBMS are referred to as
  _____________database management systems. (Points
  4)

5
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 Final Exam 3
• For more course tutorials visit
•  www.newtonhelp.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

6
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 Final Exam 4 Sets of Answers
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
•  
• CIS 336 Final Exam 4 Sets of Answers

7
CIS 336 Imagine Your Future/newtonhelp

•  CIS 336 Final Exam 4
• For more course tutorials visit
•  
• www.newtonhelp.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.

8
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 Group Project
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
• This project is designed to touch all aspects of
  the fundamental concepts of database design and
  logical data modeling covered during

9
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 iLab 1 Normal Forms and Entity
  Relationship Diagrams
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
•  
• CIS336 Lab 1 Normal Forms and Entity
  Relationship Diagrams
• Introduction

10
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 iLab 2 The Expanded Entity Relationship
  Diagram
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
•  
• CIS336 Lab 2 The Expanded Entity Relationship
  Diagram

11
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 iLab 3 Building the Physical
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
•  
• CIS-336 Lab 3 Building the Physical
• LAB OVERVIEW
• Scenario and Summary

12
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 iLab 4 Introduction to Select, Insert,
  Update, and Delete Statements (only SQL Command,
  No output)
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
• CIS336 Lab 4 Introduction to Select, Insert,
  Update, and Delete Statements

13
CIS 336 Imagine Your Future/newtonhelp

•  CIS 336 iLab 5 Joining Tables
• For more course tutorials visit
•  www.newtonhelp.com
•  
•  CIS336 Lab5 Joining Tables
• LAB OVERVIEW

14
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 iLab 6 Group Functions and Subqueries
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
•  
• CIS336 Lab 6 Group Functions and Subqueries
• LAB OVERVIEW

15
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 iLab7 Working with Views
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
• CIS-336 Lab7 Working with Views
• LAB OVERVIEW
• Lab 7 will introduce the concept of database
  views. This lab m

16
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 Quiz 1
• For more course tutorials visit
•  
• www.newtonhelp.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.

17
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 Quiz 2
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
• (TCO 2) Explain what a composite attribute is
• (TCO 1) Data constitutes the building blocks of

18
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 Quiz 3
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
• (TCO 7) Which of the following types of columns
  will automatically right-align the data when it
  is displayed?

19
CIS 336 Imagine Your Future/newtonhelp

• CIS 336 Quiz 4
• For more course tutorials visit
•  
• www.newtonhelp.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.

20
CIS 336 Imagine Your Future/newtonhelp

•  
• CIS 336 Quiz 5
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
• (TCO 6) Which of the following keywords is used
  to remove a row in a table?

21
CIS 336 Imagine Your Future/newtonhelp

•  CIS 336 Week 2 Quiz (New)
• For more course tutorials visit
•  www.newtonhelp.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 Imagine Your Future/newtonhelp

•  CIS 336 Week 3 Quiz (New)
• For more course tutorials visit
•  www.newtonhelp.com
•  CIS 336 Week 3 Quiz
• Question 1. (TCO 3) When
  designing a database, you should _____

23
CIS 336 Imagine Your Future/newtonhelp

•  CIS 336 Week 4 Quiz (New)
• For more course tutorials visit
•  www.newtonhelp.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 Imagine Your Future/newtonhelp

• CIS 336 Week 5 Quiz (New)
• For more course tutorials visit
•  www.newtonhelp.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 Imagine Your Future/newtonhelp

• CIS 336 Week 6 Quiz (New)
• For more course tutorials visit
•  www.newtonhelp.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 Imagine Your Future/newtonhelp