CIS 336 Course Career Path Begins tutorialrank.com - PowerPoint PPT Presentation

Loading...

PPT – CIS 336 Course Career Path Begins tutorialrank.com PowerPoint presentation | free to download - id: 81269f-MjlkO



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

CIS 336 Course Career Path Begins tutorialrank.com

Description:

CIS 336 Entire Course CIS 336 Final Exam 1 CIS 336 Final Exam 2 CIS 336 Final Exam 3 CIS 336 Final Exam 4 Sets of Answers CIS 336 Final Exam 4 CIS 336 Quiz 1 CIS 336 Quiz 2 CIS 336 Quiz 3 CIS 336 Quiz 4 CIS 336 Quiz 5 CIS 336 Week 1 iLab 1 Devry University CIS 336 Week 2 iLab 2 Devry University CIS 336 Week 3 Group Project Task 1 Data Model CIS 336 Week 3 iLab 3 Devry University CIS 336 Week 4 Group Project Task 2 CIS 336 Week 4 iLab 4 Devry University CIS 336 Week 5 Group Project Task 3 CIS 336 Week 5 iLab 5 DevryUniversity CIS 336 Week 6 Group Project Task 4 CIS 336 Week 6 iLab 6 Devry University CIS 336 Week 7 Group Project Task 5 CIS 336 Week 7 iLab 7 Devry University – PowerPoint PPT presentation

Number of Views:7

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: CIS 336 Course Career Path Begins tutorialrank.com


1
CIS 336 Course Career Path Begins
-tutorialrank.com
For More Tutorials
www.tutorialrank.com
2
CIS 336 Course Career Path Begins
-tutorialrank.com
  • CIS 336 Entire Course
  • CIS 336 Final Exam 1
  • CIS 336 Entire Course Devry University
  • 1. (TCO 1) Most DBMS are referred to as
    _____________database management systems. (Points
    4)
  • elementallinkedhierarchicalrelational
  • 2. (TCO 1) Data constitutes the building blocks
    of _____________. (Points 4)
  • informationprocessing

3
CIS 336 Course Career Path Begins
-tutorialrank.com
  • CIS 336 Final Exam 2
  • CIS 336 Final Exam 3
  • 1. (TCO 1) Most DBMS are referred to as
    _____________database management systems. (Points
    4)
  • elementallinkedhierarchicalrelational
  • 2. (TCO 1) A relational DBMS provides protection
    of the _______________________ through security,
    control, and recovery facilities. (Points 4)
  • 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?

4
CIS 336 Course Career Path Begins
-tutorialrank.com
  • CIS 336 Final Exam 4 Sets of Answers
  • CIS 336 Final Exam 4
  • CIS 336 Final Exam 4 Sets of Answers
  • 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".

5
CIS 336 Course Career Path Begins
-tutorialrank.com
  • CIS 336 Quiz 1
  • CIS 336 Quiz 2
  • (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 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

6
CIS 336 Course Career Path Begins
-tutorialrank.com
  • CIS 336 Quiz 3
  • CIS 336 Quiz 4
  • (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 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?

7
CIS 336 Course Career Path Begins
-tutorialrank.com
  • CIS 336 Quiz 5
  • CIS 336 Week 1 iLab 1 Devry University
  • (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
  • L A B O V E R V I E W Scenario/Summary This lab
    will introduce you to the processes involved in
    defining one of the key components of a data
    model the relationship diagram (RD). In this
    lab, you will draw a relationship diagram for two
    of the steps shown. Keep in mind when you are
    trying to decide which side of the relationship
    should be the "one"

8
CIS 336 Course Career Path Begins
-tutorialrank.com
  • CIS 336 Week 2 iLab 2 Devry University
  • CIS 336 Week 3 Group Project Task 1 Data Model
  • Lab two introduces the next step in creating a
    data model, the Entity Relationship Diagram
    (ERD). You will be given a business scenario for
    a company named Clapham Specialty Store, which is
    a small specialist grocery and delicatessen. The
    business specifications will outline a number of
    things about the business, some of which will
    apply directly to the database
  • Present a detailed data model for the project
    scenario. You can create your data model using
    Microsoft Visio, which you will have access to
    through iLab and Microsoft Excel, which comes
    with Microsoft Office. Other tools may be used as
    long as the output is legible and conforms to
    standard format. (i.e. I will not be able to
    grade the data model if I cannot tell what it is
    supposed to be!). Your data model

9
CIS 336 Course Career Path Begins
-tutorialrank.com
  • CIS 336 Week 3 iLab 3 Devry University
  • CIS 336 Week 4 Group Project Task 2
  • Beginning with this lab, and continuing through
    the remaining weeks you will be doing all of your
    work in Oracle itself. The editor interface to
    the Oracle server is SQLPlus, and by now you
    have received your logon ID and password and
    should have at least made sure you can connect.
    If for any reason you have not done so, please do
    so now before continuing any further. If for any
    reason you cannot connect
  • Task 2 - Logical Model (30 points)
  • Using the Oracle SQLPlus editor, develop a
    database for MiniQuest based on your data model.
    The database should contain all the tables and
    attributes discussed in the project
    specifications. Be sure to use your data
    dictionary when creating your tables.

10
CIS 336 Course Career Path Begins
-tutorialrank.com
  • CIS 336 Week 4 iLab 4 Devry University
  • CIS 336 Week 5 Group Project Task 3
  • Lab 4 of 7 Building the Physical Model (28
    points) Submit your assignment to the Dropbox
    located on the silver tab at the top of this
    page. For instructions on how to use the Dropbox,
    please click here. (See Syllabus/"Due Dates for
    Assignments Exams" for due dates.) L A B O V E
    R V I E W Scenario/Summary Lab 4 will introduce
    the various aspects
  • Task 3 - Verification of Logical Model(45 points)
  • Develop the SQL statements to insert records into
    the database. You should ensure that the data in
    the database is sufficient to allow for each of
    the reports requested by Ms. Smith to be tested.
    You need to show a minimum of three insert
    queries for each database table that you have
    created. Some tables will obviously

11
CIS 336 Course Career Path Begins
-tutorialrank.com
  • CIS 336 Week 5 iLab 5 DevryUniversity
  • CIS 336 Week 6 Group Project Task 4
  • Lab 5 of 7 Retreiving data from Multiple Tables
    (28 points) Submit your assignment to the Dropbox
    located on the silver tab at the top of this
    page. For instructions on how to use the Dropbox,
    please click here. (See Syllabus/"Due Dates for
    Assignments Exams" for due dates.) L A B O V E
    R V I E W Scenario/Summary Lab 5 deals with
    writing queries using multiple table
  • Task 4 - Verification of Transaction Processing
    (30 points)
  • Develop a query that will identify and mark
    inactive those customers that have bills overdue
    by more than 30 days (this can usually be done
    using a sub-query). Remember, you are only
    marking a customer as inactive, not actually
    deleting the customer record from the system.

12
CIS 336 Course Career Path Begins
-tutorialrank.com
  • CIS 336 Week 6 iLab 6 Devry University
  • CIS 336 Week 7 Group Project Task 5
  • Week 6. L A B S T E P S STEP 1 Back to top Using
    the BOOK_CUSTOMER table and the NVL function,
    create a query that will return a list containing
    the customer number, first name, last name, and
    the characters NOT REFERRED if the customer was
    not referred by another customer. Give the
    derived column an alias of REFERRED BY.
  • Develop the queries to support each of the
    reports that are required by Ms. Smith. It is
    expected that the information returned by the
    queries is adequate to be used in the reporting
    process. Make sure your output contains enough
    information! The following is a recommendation
    and the MINIMUM amount of data you should have
    access to

13
CIS 336 Course Career Path Begins
-tutorialrank.com
  • CIS 336 Week 7 iLab 7 Devry University
  • CIS 336 All iLabs Week 1 to Week 7 Devry
    University
  • L A B O V E R V I E W Scenario/Summary There is a
    lot more to a database than just tables and the
    data in them. A very important part of database
    security has to do with using and understanding
    Database Views. Being able to enhance the
    efficiency of the database tables by using
    additional indexes is also a very important
    aspect of database development.
  • CIS 336 All iLabs Week 1 to Week 7 Devry
    University

14
CIS 336 Course Career Path Begins
-tutorialrank.com
For More Tutorials
www.tutorialrank.com
About PowerShow.com