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