CIS 336 Life of the Mind/newtonhelp.com

1
CIS 336 Life of the Mind/newtonhelp
2
CIS 336 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/newtonhelp

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

14
CIS 336 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/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 Life of the Mind/newtonhelp