CIS 515 Learn/newtonhelp.com - PowerPoint PPT Presentation

About This Presentation
Title:

CIS 515 Learn/newtonhelp.com

Description:

For more course tutorials visit www.newtonhelp.com This Tutorial contains 2 Set of Papers for each Assignment CIS 515 Week 1 Assignment 1 Accessing Oracle (2 Papers) CIS 515 Week 2 Assignment 2 Database Systems And Database Models (2 Papers) CIS 515 Week 3 Assignment 3 University Database (2 Papers) – PowerPoint PPT presentation

Number of Views:13
Slides: 35
Provided by: abcdf400

less

Transcript and Presenter's Notes

Title: CIS 515 Learn/newtonhelp.com


1
CIS 515 Learn/newtonhelp.com
2
CIS 515 Learn/newtonhelp.com
  • CIS 515 All Assignments (2 Set)
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • This Tutorial contains 2 Set of Papers for each
    Assignment
  •  
  • CIS 515 Week 1 Assignment 1 Accessing Oracle (2
    Papers)
  •  
  • CIS 515 Week 2 Assignment 2 Database Systems And
    Database Models (2 Papers)
  •  
  • CIS 515 Week 3 Assignment 3 University Database
    (2 Papers)
  •  

3
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 1 Assignment 1 Accessing Oracle (2
    Papers)
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • This Tutorial contains 2 Papers
  •  
  • Your instructor will provide you with login
    credentials to a Strayer University maintained
    Oracle server. Once you have received these
    credentials, you will need to log in to the
    Oracle server and document your login to verify
    your credentials work and you can complete the
    activities later in the course. This assignment
    requires the use of a snipping tool or print
    screen option on a keyboard to document the
    completion of this assignment.
  •  

4
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 1 Discussion 1Planning Database
    Design
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • Planning Database Design Please respond to the
    following
  •  
  • The proper implementation of a database is
    essential to the success of the data performance
    functions of an organization.  Identify and
    evaluate at least three considerations that one
    must plan for when designing a database.
  •  
  • Suggest at least two types of databases that
    would be useful for small businesses, two types
    for regional level organizations and two types
    for internationally wide companies. Include your
    rationale for each

5
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 1 Discussion 2 Database Modeling
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • Database Modeling Please respond to the
    following
  •  
  • Following a data model is important in the
    planning of a database system. Evaluate at least
    two classic models that are used in providing
    structure for database solutions.
  •  
  • Compare and contrast the effectiveness of classic
    models and recently evolved models such as Big
    Data and NoSQL. Give your opinion on which type
    of model is more effective and why.

6
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 1-11 All Discussion Question
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • CIS 515 Week 1 Discussion 1 Planning Database
    Design
  •  
  • CIS 515 Week 1 Discussion 2 Database Modeling
  •  
  • CIS 515 Week 2 Discussion 1 Maintaining Data
    Integrity
  •  
  • CIS 515 Week 2 Discussion 2 Aggregate Queries
  •  
  • CIS 515 Week 3 Discussion 1 The Entity
    Relationship Model
  •  
  • CIS 515 Week 3 Discussion 2 Preparing an Adequate
    Data Model
  •  

7
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 2 Assignment 2 Database Systems And
    Database Models (2 Papers)
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • This Tutorial contains 2 Papers
  • Assignment 2 Database Systems and Database
    Models
  • The Strayer Oracle Server may be used to test and
    compile the SQL Queries developed for this
    assignment. Your instructor will provide you with
    login credentials to a Strayer University
    maintained Oracle server.
  • Imagine that you have been hired as a consultant
    to assist in streamlining the data processing of
    an international based organization that sells
    high-end electronics. The organization has
    various departments

8
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 2 Discussion 1Maintaining Data
    Integrity
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Maintaining Data Integrity" Please respond to
    the following
  • Describe the importance of maintaining integrity
    rules throughout the database structure.  Create
    at least three examples of common relationships
    that are used within a relational database
    system.  Justify your response. 

9
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 2 Discussion 2Aggregate Queries
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Aggregate Queries" Please respond to the
    following
  • Suppose you have been hired as an IT professional
    to support database reporting functionality for a
    Human Resources system.  Compose at least two
    aggregate function queries that can be useful for
    the executives of the organization to extract
    summary data from a database system.  

10
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 3 Assignment 3 University Database
    (2 Papers)
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • This Tutorial contains 2 Papers
  • CIS 515 WEEK 3 ASSIGNMENT 3 UNIVERSITY DATABASE
  • Assignment 3 University Database
  • Due Week 3 and worth 90 points
  • A prestigious university has recently implemented
    a consolidation strategy that will require it to
    centralize their student records. In order to
    move forward, the local university will need to
    develop a data model that will retain student
    records and perform various data extract
    transform and load (ETL) processes. Imagine that
    you have been hired as a database consultant to
    assist in the development of a data design
    strategy for the student records.

11
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 3 Discussion 1The Entity
    Relationship Model
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "The Entity Relationship Model" Please respond to
    the following
  • Defining relationships within a database can
    improve search capabilities and optimal
    performance of the database in the long run.
    Identify at least two relationship strength types
    that can be used within the entity relationship
    model.  
  • Using the classifications from part one of this
    discussion provide a real word scenario that
    demonstrates each relationship strength
    classification.   

12
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 3 Discussion 2Preparing an Adequate
    Data Model
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Preparing an Adequate Data Model" Please respond
    to the following
  • Using specialization hierarchies can provide an
    efficient application development structure.
    Justify the use of surrogate primary keys for a
    database design. Provide an example to support
    your response.
  •  
  • Historical data can be important to measuring
    performance. Prepare an example on how
    time-variant data can be properly captured and
    maintained within a database system.  

13
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 4 Assignment 4 Database Modeling And
    Normalization (2 Papers)
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • This Tutorial contains 2 Papers
  • CIS 515 WEEK 4 ASSIGNMENT 4 DATABASE MODELING AND
    NORMALIZATION
  • Assignment 4 Database Modeling and Normalization
  • Imagine that you work for a consulting firm that
    offers information technology and database
    services. Part of its core services is to
    optimize and offer streamline solutions for
    efficiency. In this scenario, your firm has been
    awarded a contract to implement a new personnel
    system for a government agency. This government
    agency has requested an optimized data repository
    for its system which will enable the management
    staff to perform essential human resources (HR)
    duties along with the capability to produce ad
    hoc reporting features for various departments.
    They look forward to holding data that will

14
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 4 Discussion Question
    2Denormalization Functionality
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • CIS 515 Week 4 Discussion Question 2
  •  
  •  Denormalization Functionality Please respond
    to the following
  •  
  • Having an adequate data model to serve specific
    business needs of an organization is important.
    Evaluate the need for denormalization within an
    organization. Provide at least three examples
    that prove denormalization is useful to data
    consumers.
  • Using a data-modeling checklist can help database
    developers design efficient data repositories.
    Suggest at least two possible scenarios that
    could take place if one of the steps in the
    data-modeling checklist (table 6.7 in Chapter 6
    of the textbook) is missed.
  •  

15
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 4 Discussion Questions 1 Optimizing
    Database Design
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • CIS 515 Week 4 Discussion Question 1
  •  
  • Optimizing Database Design Please respond to
    the following
  •  
  • Many legacy systems require normalization.
    Identify at least two factors that should be
    considered in order to produce an optimal
    normalized set of tables when performing
    normalization. Include in your discussion a
    detailed example on how each factor would
    eliminate data redundancy.
  • Optimal database design recognizes proper
    organization of table structures and
    relationships. Suggest at least two methods that
    can be used to improve the design of a database
    system.

16
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 5 Discussion Question 1Relational
    Set Operators
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Relational Set Operators" Please respond to the
    following
  • A relational Database Model allows database users
    to analyze data thoroughly. To accomplish this,
    advanced commands such as UNION and INTERSECT may
    be used.  Describe a business scenario where a
    UNION relational set operator may be used to
    merge two similar data sets. Within the context
    of your business scenario, analyze the analysis
    and data consistency advantages of using a UNION
    operator rather than simply merging two data sets
    into one result table.

17
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 5 Discussion Question 2Advanced SQL
    and PL / SQL
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Advanced SQL and PL / SQL" Please respond to the
    following
  • Extracting and interpreting data can be very
    valuable to an organization. Describe the
    importance of using sub queries in a database
    system. Provide at least two business case
    scenarios to support your response.  
  • A good IT professional is able to be versatile in
    SQL programming styles. Identify at least two
    possible advantages of utilizing PL / SQL instead
    of standard SQL Syntax. Explain whether either
    syntax provides enhanced code processing
    capabilities with examples. Note The Strayer
    Oracle Server may be used to test 
  •  

18
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 6 Assignment 5 Tour Operator Agency
    Database (2 Papers)
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • This Tutorial contains 2 Papers
  • CIS 515 WEEK 6 ASSIGNMENT 5 TOUR OPERATOR AGENCY
    DATABASE
  • Assignment 5 Tour Operator Agency Database
  • The Strayer Oracle Server may be used to test and
    compile the SQL Queries developed for this
    assignment. Your instructor will provide you with
    login credentials to a Strayer University
    maintained Oracle server.
  • A multinational tour operator agency has gained
    new business growth in the North American market
    through the use of social media. Its operation
    has expanded by 50 within six months and the
    agency requires an enhanced data management
    strategy to sustain their business operations.
    Their existing data repository for its
    reservation processing system is limited in
    business intelligence and reporting

19
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 6 Discussion Question 1Planning the
    DBLC
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Planning the DBLC" Please respond to the
    following 
  • The development of a database requires thorough
    methodology that ensures quality within the
    solution. Imagine you have been contracted to
    develop a finance database that will help an
    organization track monthly expenditures by
    departments. Using the DBLC, discuss the various
    activities that you would have to achieve each
    phase. Assess possible challenges that may exist
    within each phase. Suggest actions that one can
    perform to overcome these possible challenges. 

20
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 6 Discussion Question 2Logical and
    Physical Design
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Logical and Physical Design" Please respond to
    the following
  • In order to ensure optimal database performance,
    the logical and physical design should consider
    the user requirements thoroughly. Suppose you
    have been hired to transform a conceptual model
    into a logical model for a sales database.
    Describe the specific steps that you must perform
    in order to appropriately construct the database
    model. For each step mentioned, speculate the
    risks that would take place and how you would
    avoid or mitigate those risks.     
  • Suggest at least three activities that are
    required in the physical design process of a
    database to ensure adequate physical storage and
    data access. Analyze why user, security groups,
    and role definitions are essential to maintain
    the integrity of the database.

21
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 7 Assignment 6 Sql Concepts And
    Database Design (2 Papers)
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • This Tutorial contains 2 Papers
  • CIS 515 WEEK 7 ASSIGNMENT 6 SQL CONCEPTS AND
    DATABASE DESIGN
  • Assignment 6 SQL Concepts and Database Design
  • Due Week 7 and worth 90 points
  • The Strayer Oracle Server may be used to test and
    compile the SQL Queries developed for this
    assignment. Your instructor will provide you with
    login credentials to a Strayer University
    maintained Oracle server.
  • Imagine that you work for a finance
    industry-based organization. Your organization is
    looking to submit its database design
    documentation to an evaluation team in order to
    meet Sarbanes-Oxley (SOX) compliance. You have
    been assigned to assist in preparing the
    documentation of the organizations sales
    database. You are asked to propose a data
    dictionary that can be used to document the
    following
  • Employee (EmpNumber, EmpFirstName, EmpLastName,
    CommissionRate, YrlySalary, DepartmentID, JobID)
  • Invoice (InvNumber, InvDate, EmpNumber,
    InvAmount, CustomerID)

22
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 7 Discussion 2 Optimization for
    Transactional Processing
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • Week 7 Discussion 2 "Optimization for
    Transactional Processing"
  •  
  • Databases can grow in data structure and data
    capacity throughout time. At certain times, it is
    necessary to perform optimization techniques in
    order to ensure optimal performance of the
    database. Evaluate at least two methods that can
    be used to optimize database components such as
    queries, reports SQL transaction processing, and
    data consumption. Provide a real-world example
    that explains how these methods would help an
    organization process a large number of online
    transactions within a short time span. 
  • Suggest at least two SQL optimization techniques
    that can be used to enhance the data access
    turnaround time and transaction processing time.
    Provide examples to support your response.
  • Assess the database statistics that could be used
    in order to measure database performance. Provide
    a real-world example that demonstrates how this
    information would enable businesses to accurately
    scale

23
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 7 Discussion Question 1Concurrency
    Control
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • Week 7 Discussion 1 "Concurrency Control"
  • There are times when a database is accessed by
    many users across the enterprise.  Transaction
    logs can help maintain concurrency in a multiuser
    platform. Describe at least two business
    scenarios where COMMIT and ROLLBACK would be
    required. Describe how these functions would be
    essential for business continuity and concurrency
    control. Identify how these functions would
    enable an organization to recover from a database
    corruption event. 
  •  
  • Describe how locks could be used in order to
    qualify data transactions and enhance concurrency
    control. Suggest at least two business scenarios
    that would benefit from implementing locking
    methods.

24
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 8 Case Study Database Development (2
    Papers)
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • This Tutorial contains 2 Papers
  • Due Week 8 and worth 90 points?Read the following
    articles available in the ACM Digital Library
  • Dual Assessment of Data Quality in Customer
    Databases, Journal of Data and Information
    Quality (JDIQ), Volume 1 Issue 3, December 2009,
    Adir Even, G. Shankaranarayanan.
  • Process-centered review of object oriented
    software development methodologies, ACM Computing
    Surveys (CSUR), Volume 40 Issue 1, February 2008,
    Raman Ramsin, and Richard F. Paige.
  • Please follow the steps below to access ACM
    Digital Library
  • 1.Login to iCampus at https//icampus.strayer.edu/
    login
  • 2.From iCampus
  • Click STUDENT SERVICES gtgt
    Learning Resources Center gtgt Databases

25
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 8 Discussion Question 1Centralized
    versus Decentralized Database Management Systems
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Centralized versus Decentralized Database
    Management Systems" Please respond to the
    following
  • Big Data brought its own challenges to the field
    of databases. What are these challenges, and how
    does the emerging NoSQL model address these
    challenges?
  • The different NoSQL technologies were created to
    meet different needs. Choose one of the NoSQL
    data models and describe it. Explain what kind of
    applications would benefit from your chosen NoSQL
    data model.

26
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 8 Discussion Question 2Business
    Intelligence Tools
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Business Intelligence Tools" Please respond to
    the following
  • Business intelligence tools are considered the
    key drivers for many organizations. Identify and
    evaluate at least two business intelligence tools
    that could be effectively used to report business
    performance. Justify your response.
  • Estimate the costs and describe the values of the
    two business intelligence tools you have
    identified from Part 1 of this discussion based
    on their functionality, integrating architecture,
    and benefits to the enterprise. Provide your
    rationale.
  •  

27
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 9 Discussion Question 1Database
    Connectivity Methods
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Database Connectivity Methods" Please respond to
    the following
  • Database solutions today must be able to adapt
    and integrate among various computing
    applications. Determine at least three forms of
    database connectivity methods that can be used as
    an interface between applications. For each
    method, you have chosen, create an example that
    demonstrates how each could facilitate data
    exchange functionality in a cloud service
    environment.

28
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 9 Discussion Question 2Extensible
    Markup Language XML
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Extensible Markup Language (XML)" Please respond
    to the following
  • XML provides a method for data to be transferred
    between systems. Specify at least three
    components of an XML document. Analyze how each
    component ensures data reliability and
    validation.
  • Identify at least two e-Commerce systems that
    provide XML data integration. For each system,
    describe how XML extensions could enable
    e-Commerce integration among system stakeholders
    such as vendors , resellers, suppliers, and
    customers.

29
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 10 Discussion Question 1Database
    Administrators Role
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Database Administrators Role" Please respond to
    the following
  • Information professionals with adequate skills
    are required to maintain the business continuity
    of database services in an organization. Identify
    and assess at least three professional skills
    that would be required to be successful database
    administrators.  
  • Give your opinion on what the critical nature of
    a database administrators role is to IT industry
    organizations. Support your answer with specific
    examples of functions and responsibilities they
    perform.

30
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 10 Discussion Question 2Database
    Security
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Database Security" Please respond to the
    following
  • Confidentiality, integrity, and availability are
    the three common security goals. Select at least
    three security vulnerabilities that could
    jeopardize and compromise a database.  Classify
    each vulnerability with being technical,
    managerial, cultural, or procedural. Provide your
    rationale.
  • Suggest specific actions that could be performed
    to minimize the vulnerabilities identified in
    Question 1 of this discussion. Describe how often
    these measures should be performed and the order
    in which each should be performed.  

31
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 10 Technical Paper Database
    Administrator For Department Store (2 Papers)
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  • This Tutorial contains 2 Papers
  • CIS 515 WEEK 10 TECHNICAL PAPER DATABASE
    ADMINISTRATOR FOR DEPARTMENT STORE
  • Technical Paper Database Administrator for
    Department Store
  • The Strayer Oracle Server may be used to test and
    compile the SQL Queries developed for this
    assignment. Your instructor will provide you with
    login credentials to a Strayer University
    maintained Oracle server.
  • Imagine that you have been hired as the database
    administrator for a local department store. The
    department store has recently expanded by opening
    five (5) stores within your local region. They
    have also launched a series of marketing
    campaigns to attract new customers and increase
    sales. For your hired role, you will be
    responsible for creating and maintaining an
    enterprise-wide database system that will hold
    the sales and inventory data for the
    organization. The designed database will help
    operations in supporting its new business
    marketing strategy. Using the concepts presented
    throughout the course, you will develop a plan to
    create this database and establish a design that
    aligns with the product sales initiatives of the
    organization.

32
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 11 Discussion Question 1Practical
    Database Management
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • "Practical Database Management" Please respond to
    the following
  • Imagine that you have been hired to optimize and
    secure an existing database installation. Select
    at least three considerations that would enable
    the organization to extend database functionality
    and reliability, and enhance data transaction
    performance.  Support your answer with technical
    considerations that could be implemented to
    leverage data services. Classify professional and
    technical skills that could enable you to be
    successful in this scenario.

33
CIS 515 Learn/newtonhelp.com
  • CIS 515 Week 11 Discussion Question 2Database
    Trends
  •  
  • For more course tutorials visit
  • www.newtonhelp.com
  •  
  •  
  •  
  • Database Trends Please respond to the
    following
  • Identify at least two industries that are
    currently using common data exchange and data
    management trends. Rank the success of each
    implementation based on the ease of
    implementation, ease of use, and costs. Speculate
    the data exchange and data management trends that
    may take place in the next five to 10 years.
    Justify your response.

34
CIS 515 Learn/newtonhelp.com
Write a Comment
User Comments (0)
About PowerShow.com