CIS 336 Course Success Begins / tutorialrank.com - PowerPoint PPT Presentation

About This Presentation
Title:

CIS 336 Course Success Begins / tutorialrank.com

Description:

For more course tutorials visit www.tutorialrank.com CIS 336 Entire Course: Devry University – PowerPoint PPT presentation

Number of Views:3
Slides: 15
Provided by: sudeepreddy74

less

Transcript and Presenter's Notes

Title: CIS 336 Course Success Begins / tutorialrank.com


1
CIS 336 learning consultant / tutorialrank.com
For More Tutorials
www.tutorialrank.com
2
CIS 336 learning consultant / tutorialrank.com
  • CIS 336 All iLabs Week 1 to Week 7 Devry
    University
  • CIS 336 Entire Course Devry University
  • CIS 336 All iLabs Week 1 to Week 7 Devry
    University
  • CIS 336 Entire Course Devry University

3
CIS 336 learning consultant / tutorialrank.com
  • CIS 336 Final Exam 1
  • CIS 336 Final Exam 2
  • How can an IT system initially help a company
    advance, but later become a requirement for that
    business to stay competitive?
  • 1. (TCO 1) Most DBMS are referred to as
    _____________database management systems. (Points
    4)
  • elemental
  • linked
  • hierarchical
  • relational

4
CIS 336 learning consultant / tutorialrank.com
  • CIS 336 Final Exam 3
  • CIS 336 Final Exam 4 Sets of Answers
  • Perform the following hands-on activities where
    possible.
  • Prior to being assigned to a team look at your
    own computer system and answer the below
    questions.
  • Provide a brief description of your
    findings/exploration. If you are unable to
    perform an activity describe why and what you
    would have expected to experience if you were
    able to complete the activity.
  • CIS 336 Final Exam 4 Sets of Answers

5
CIS 336 learning consultant / tutorialrank.com
  • CIS 336 Final Exam 4
  • CIS 336 Quiz 1
  • 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".
  • (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

6
CIS 336 learning consultant / tutorialrank.com
  • CIS 336 Quiz 2
  • CIS 336 Quiz 3
  • Perform the following hands-on activities where
    possible.
  • Provide a brief description of your
    findings/exploration. If you are unable to
    perform an activity describe why and what you
    would have expected to experience if you were
    able to complete the activity.
  • Secure a Windows PC from Unauthorized Local Use
  • Continue working on your proposal.
  • Submit a 700- to 1,050-word section of the paper
    with the following
  • A full description of the new system, a
    description of its components, and the benefit it
    will provide to Riordan
  • A discussion of the business requirements
    driving the need for the system
  • A discussion of the information used in the
    system

7
CIS 336 learning consultant / tutorialrank.com
  • CIS 336 Quiz 4
  • CIS 336 Quiz 5
  • How is mobile computing, Web 2.0, and social
    media changing how IT systems are used?
  • How are mobile devices changing the way IT
    systems are used? What are the useful aspects and
    dangers of these devices? What can organizations
    do to maximize value and minimize risk when users
    use these devices?

8
CIS 336 learning consultant / tutorialrank.com
  • CIS 336 Week 1 iLab 1 Devry University
  • CIS 336 Week 2 iLab 2 Devry University
  • 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.
  • 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.

9
CIS 336 learning consultant / tutorialrank.com
  • CIS 336 Week 3 Group Project Task 1 Data Model
  • CIS 336 Week 3 iLab 3 Devry University
  • Continue working on your proposal.
  • Develop the flow diagram of the information and
    any control elements needed to ensure proper
    access for the information.
  • Submit a 700- to 1,050-word section of the paper
    with the following
  • Describe three types of systems used in
    organizations. Note the factors that normally
    lead to adopting the system and requirements that
    will likely push its future growth of each type.

10
CIS 336 learning consultant / tutorialrank.com
  • CIS 336 Week 4 Group Project Task 2
  • CIS 336 Week 4 iLab 4 Devry University
  • Discuss an IT system that has transformed the way
    organizations in at least one field carry out
    work. Note what requirements drove the system to
    be developed and what requirements are likely to
    drive it to change in the future.
  • Write a 700- to 1,050-word paper identifying and
    describing how specific system used in an
    organization has transformed how the organization
    operates.
  • Discuss how the business requirements drove the
    systems initial development.
  • Describe the type and basic uses of the system,
    how the system has helped the organization, and
    any likely future development plans.

11
CIS 336 learning consultant / tutorialrank.com
  • CIS 336 Week 5 Group Project Task 3
  • CIS 336 Week 5 iLab 5 DevryUniversity ) (UOP
    Course)
  • Perform the following hands-on activities where
    possible.
  • Provide a brief description of your
    findings/exploration. If you are unable to
    perform an activity describe why and what you
    would have expected to experience if you were
    able to complete the activity.
  • Cleaning a Desktop Computer
  • Cleaning a CD or DVD
  • Continue working on your proposal.
  • Submit a 350- to 700-word section of the paper
    with the following element
  • A description of how a specific business
    requirement would drive the projects creation
    and use

12
CIS 336 learning consultant / tutorialrank.com
  • CIS 336 Week 6 Group Project Task 4
  • CIS 336 Week 6 iLab 6 Devry University
  • Discuss two major issues involved with acquiring
    systems and two major issues commonly faced when
    maintaining them. Address how each can be
    minimized or overcome.
  • 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.

13
CIS 336 learning consultant / tutorialrank.com
  • CIS 336 Week 7 Group Project Task 5
  • CIS 336 Week 7 iLab 7 Devry University
  • 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
  • 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.

14
CIS 336 learning consultant / tutorialrank.com
For More Tutorials
www.tutorialrank.com
Write a Comment
User Comments (0)
About PowerShow.com