CIS 336 Course Career Path Begins cis336dotcom - PowerPoint PPT Presentation

Loading...

PPT – CIS 336 Course Career Path Begins cis336dotcom PowerPoint presentation | free to download - id: 8184c9-MTI3N



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 cis336dotcom

Description:

CIS 336 Entire Course: Devry University – PowerPoint PPT presentation

Number of Views:3

less

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

Title: CIS 336 Course Career Path Begins cis336dotcom


1
CIS 336 Course Career Path Begins /cis336dotcom
  • FOR MORE CLASSES VISIT
  • www.cis336.com

2
CIS 336 Entire Course Devry University (Devry)
  • CIS 336 Entire Course Devry University (Devry)

3
CIS 336 All iLabs Week 1 to Week 7 Devry
University (Devry)
  • CIS 336 All iLabs Week 1 to Week 7 Devry
    University

4
CIS 336 Final Exam 1 (Devry)
  • 1. (TCO 1) Most DBMS are referred to as
    _____________database management systems. (Points
    4)
  • elemental linked hierarchical relational
  • 2. (TCO 1) Data constitutes the building blocks
    of _____________. (Points 4)
  • information processing applications programming

5
CIS 336 Final Exam 2 (Devry)
  • 1. (TCO 1) Most DBMS are referred to as
    _____________database management systems. (Points
    4)
  • elemental linked hierarchical relational
  • 2. (TCO 1) A relational DBMS provides protection
    of the _______________________ through security,
    control, and recovery facilities. (Points 4)

6
CIS 336 Final Exam 3 (Devry)
  • 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 useful. (Points 15)

7
CIS 336 Final Exam 4 (Devry)
  • 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".
  • 2. (TCO 8) Write a query that will display the
    earliest date an order was placed.
  • 3. (TCO 7) Using the BETWEEN operator, write a
    query that will list all details about all orders
    that were placed during the period of September
    3rd thru September 5th of 1998.

8
CIS 336 Final Exam 4 Sets of Answers (Devry)
  • CIS 336 Final Exam 4 Sets of Answers

9
CIS 336 Quiz 1 (Devry)
  • 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

10
CIS 336 Quiz 2 (Devry)
  • 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
  • (TCO 2) The term _____________ design is used to
    refer to the task of creating the conceptual data
    model represented by an Entity Relationship
    Diagram (ERD).

11
CIS 336 Quiz 3 (Devry)
  • 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?
  • (TCO 7) Which of the following operators would be
    most appropriate to determine whether or not the
    retail price of a book is at least 24.00?

12
CIS 336 Quiz 4 (Devry)
  • (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?
  • (TCO 8) Oracles pseudo table used only for cases
    where a table is not really needed is _________?

13
CIS 336 Quiz 5 (Devry)
  • 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?

14
CIS 336 Week 1 iLab 1 Devry University (Devry)
  • 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" side and which should be the
    "many" that you must first decide which side has
    the primary key, or unique identifier. Once you
    have decided the primary key of the relationship,
    you have identified the "one" side of the
    relationship. Note that for an RD, the foreign
    key "many" side of the relationship points to the
    primary key "one" side.

15
CIS 336 Week 2 iLab 2 Devry University (Devry)
  • 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 you are being
    asked to model. There is a table which lists the
    entities (tables) that will be needed for the
    database and related attributes (columns) for
    each entity. There is also a column that lists

16
CIS 336 Week 3 Group Project Task 1 Data Model
(Devry)
  • 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 should include
    a minimum of an ERD and metadata chart (data
    dictionary).

17
CIS 336 Week 3 iLab 3 Devry University (Devry)
  • 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 then you need to let
    the instructor

18
CIS 336 Week 4 Group Project Task 2 (Devry)
  • 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.
  • A key component to every task submission is the
    team responsibilities document. This document
    should outline the contributions that each member
    of the team made to completing the task
    deliverable.

19
CIS 336 Week 4 iLab 4 Devry University (Devry)
  • 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 of the SQL select statement
    and the methods of retrieving data from the
    database tables. The lab will utilize a set of
    tables found in the script file

20
CIS 336 Week 5 Group Project Task 3 (Devry)
  • 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 require more
    to ensure that all of the required data is in the
    database (i.e., the packages table, program
    table, etc). To submit this task, add a comment
    heading called INSERT STATEMENTS to your
    corrected SQL script

21
CIS 336 Week 5 iLab 5 Devry University (Devry)
  • 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 tables as covered
    in the reading and lecture material this week. In
    some cases, you will be given the option to write
    a query using either the TRADITIONAL method of
    joining tables or using the JOIN key word. In
    some cases, you will be asked to use a specific
    approach. Using the incorrect process when the
    process is specified

22
CIS 336 Week 6 Group Project Task 4 (Devry)
  • 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.
  • To submit this task, create a heading called
    MODIFY STATEMENTS in your group project SQL
    script, and name the file TEAM_X_TASK4.TXT. This
    should be the same script that contains your DROP
    TABLE, CREATE TABLE, and INSERT statements. Once
    you have verified that your SQL statement or
    statements work, create a spooled output showing
    the results of your statements.

23
CIS 336 Week 6 iLab 6 Devry University (Devry)
  • 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. Do not
    list any customers that were referred by another
    customer. STEP 2 Back to top Using the BOOKS
    table and the SUBSTR function, create a query
    that will return a list of book ISBN codes and
    the book title for all the computer books. Format
    the ISBN code to display as 9-999-99999-9 (e.g.,
    1059831198 would display as 1-059-83119-8) STEP
    3 Back to top Using the BOOKS table, create a
    query using the correct

24
CIS 336 Week 7 Group Project Task 5 (Devry)
  • 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
  • Customer Table A minimum of 12 customers (this
    will allow several channels to have more than one
    customer selecting it as a favorite channel)
    Billing Table Records to support the above
    customers Program Table A minimum of 25 programs
    (your program guide should have enough programs
    for various channels to support the program guide
    report)

25
CIS 336 Week 7 iLab 7 Devry University (Devry)
  • 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. Finally, being
    able to create and use Database Sequences to
    automate some of the sequential processes in the
    database can not only save time but improve
    efficiency. In Lab 7, you will have a chance to
    work with all three of these areas. General Lab
    Information and Considerations This lab will
    utilize the same set of tables found in the
    script file (LeeBooks.SQL) that were used for Labs

26
CIS 336 Course Career Path Begins /cis336dotcom
  • FOR MORE CLASSES VISIT
  • www.cis336.com
About PowerShow.com