CIS 515 Begins Education / snaptutorial.com

1
CIS 515 Course Seek Your Dream / snaptutorial.com
The Best way to predict the Future is to create
it.....To Best way....
www.snaptutorial.com
2
CIS 515 Course Seek Your Dream / snaptutorial.com
CIS 515 All Assignments (2 Set)
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) CIS 515 Week 4 Assignment 4 Database
Modeling And Normalization (2 Papers)
3
CIS 515 Course Seek Your Dream / snaptutorial.com
CIS 515 Week 1 Assignment 1 Accessing Oracle (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 Course Seek Your Dream / snaptutorial.com
CIS 515 Week 2 Assignment 2 Database Systems And
Database Models (2 Papers)
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 such as payroll, human
resources, finance, marketing, sales, and
operations. The sales department is the only
department where employees are paid a commission
in addition to their yearly salary and benefits.
All other departments compensate their employees
with a yearly salary and benefits only.
Commission is paid by multiplying the employees
commission rate by the total amount of product
units sold.
5
CIS 515 Course Seek Your Dream / snaptutorial.com
CIS 515 Week 3 Assignment 3 University Database
(2 Papers)
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.
6
CIS 515 Course Seek Your Dream / snaptutorial.com
CIS 515 Week 4 Assignment 4 Database Modeling And
Normalization (2 Papers)
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.
7
CIS 515 Course Seek Your Dream / snaptutorial.com
CIS 515 Week 6 Assignment 5 Tour Operator Agency
Database (2 Papers)
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
functionalities. The tour operator seeks a
database management specialist to assist them in
leveraging their data sources to enable them to
forecast and project tour sales appropriately.
8
CIS 515 Course Seek Your Dream / snaptutorial.com
CIS 515 Week 7 Assignment 6 Sql Concepts And
Database Design (2 Papers)
Employee (EmpNumber, EmpFirstName, EmpLastName,
CommissionRate, YrlySalary, DepartmentID,
JobID) Invoice (InvNumber, InvDate, EmpNumber,
InvAmount, CustomerID) InvoiceLine
(InvLineNumber, InvNumber, ProductNumber,
Quantity)
9
CIS 515 Course Seek Your Dream / snaptutorial.com
CIS 515 Week 10 Technical Paper Database
Administrator For Department Store (2 Papers)
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.
10
CIS 515 Course Seek Your Dream / snaptutorial.com
CIS 515 Week 8 Case Study Database Development (2
Papers)
From the software development methodologies
described in the article titled,
Process-centered Review of Object Oriented
Software Development Methodologies, complete the
following. Evaluate which method would be
efficient for planning proactive concurrency
control methods and lock granularities. Assess
how your selected method can be used to minimize
the database security risks that may occur within
a multiuser environment.
11
CIS 515 Course Seek Your Dream / snaptutorial.com
The Best way to predict the Future is to create
it.....To Best way....
www.snaptutorial.com