CIS 336 Invent Youself/newtonhelp.com - PowerPoint PPT Presentation

About This Presentation
Title:

CIS 336 Invent Youself/newtonhelp.com

Description:

For more course tutorials visit www.newtonhelp.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? – PowerPoint PPT presentation

Number of Views:5
Slides: 27
Provided by: chekuuuuu58

less

Transcript and Presenter's Notes

Title: CIS 336 Invent Youself/newtonhelp.com


1
CIS 336 Invent Youself /newtonhelp.com
2
CIS 336 Invent Youself/newtonhelp.com
  • 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 functions that guarantee the integrity
    and consistency of the data in the database.
    Which of the following is NOT one of those
    functions?

3
CIS 336 Invent Youself/newtonhelp.com
  • 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)
  • elemental
  • linked
  • hierarchical

4
CIS 336 Invent Youself/newtonhelp.com
  • 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)
  • elemental

5
CIS 336 Invent Youself/newtonhelp.com
  • 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 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

6
CIS 336 Invent Youself/newtonhelp.com
  • 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 Invent Youself/newtonhelp.com
  • 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 Invent Youself/newtonhelp.com
  • 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 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. All aspects of the
    project will be covered during

9
CIS 336 Invent Youself/newtonhelp.com
  • 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
  • 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. Your ERD will use Crows Foot notation
    to denote the relationships between tables.

10
CIS 336 Invent Youself/newtonhelp.com
  • 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
  • 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 mo

11
CIS 336 Invent Youself/newtonhelp.com
  • 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
  • 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

12
CIS 336 Invent Youself/newtonhelp.com
  • 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
  • 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

13
CIS 336 Invent Youself/newtonhelp.com
  • CIS 336 iLab 5 Joining Tables
  • For more course tutorials visit
  • www.newtonhelp.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

14
CIS 336 Invent Youself/newtonhelp.com
  • 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
  • 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

15
CIS 336 Invent Youself/newtonhelp.com
  • 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 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

16
CIS 336 Invent Youself/newtonhelp.com
  • 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.
  • (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

17
CIS 336 Invent Youself/newtonhelp.com
  • 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 Invent Youself/newtonhelp.com
  • 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?
  • (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?

19
CIS 336 Invent Youself/newtonhelp.com
  • 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.
  • (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?

20
CIS 336 Invent Youself/newtonhelp.com
  • 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?
  • (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 Invent Youself/newtonhelp.com
  • 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 Invent Youself/newtonhelp.com
  • 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 _____
  • Question 2. (TCO 3) A table that
    is in 1NF and includes no partial dependencies
    only is said to be in

23
CIS 336 Invent Youself/newtonhelp.com
  • 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 Invent Youself/newtonhelp.com
  • CIS 336 Week 5 Quiz (New)
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  • CIS 336 Week 5 Quiz

25
CIS 336 Invent Youself/newtonhelp.com
  • 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 Invent Youself/newtonhelp.com
Write a Comment
User Comments (0)
About PowerShow.com