CIS 515 Exciting Teaching / snaptutorial.com

1. CIS 515 All Assignments (2 Set) For more classes visit www.snaptutorial.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) CIS 515 Week 4 Assignment 4 Database Modeling And Normalization (2 Papers) CIS 515 Week 6 Assignment 5 Tour Operator Agency Database (2 Papers) CIS 515 Week 7 Assignment 6 Sql Concepts And Database Design (2 Papers) CIS 515 Week 8 Case Study Database Development (2 Papers) CIS 515 Week 10 Technical Paper Database Administrator For Department Store (2 Papers)

2. ****************************************** CIS 515 Week 1 Assignment 1 Accessing Oracle (2 Papers) For more classes visit www.snaptutorial.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. Write a one to two (1-2) page paper in which you: 1. Use the print screen option on a keyboard or a snipping tool to capture screen shots of your telnet session into the Oracle server. Note: The graphically depicted solution is included in the required page length. 2. Briefly describe the steps used to log into the Strayer Oracle server. Your assignment must follow these formatting requirements:

3. Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions. Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length. Include diagrams or screen shots created through the use of a snipping tool or print screen keyboard option. The completed diagrams / screen shots must be imported into the Word document before the paper is submitted. 
The specific course learning outcomes associated with this assignment are: Use technology and information resources to research issues in the strategic implications and management of database systems. Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions. ****************************************** CIS 515 Week 2 Assignment 2 Database Systems And Database Models (2 Papers) For more classes visit www.snaptutorial.com

4. This Tutorial contains 2 Papers CIS 515 WEEK 2 Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted. The specific course learning outcomes associated with this assignment are: Describe the role of databases and database management systems in managing organizational data and information. Design and implement a database solution to solve a proposed business problem. Use technology and information resources to research issues in the strategic implications and management of database systems. Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions. ****************************************** CIS 515 Week 3 Assignment 3 University Database (2 Papers) For more classes visit www.snaptutorial.com

5. 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 Design and implement a database solution to solve a proposed business problem. Use technology and information resources to research issues in the strategic implications and management of database systems. Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style ****************************************** CIS 515 Week 4 Assignment 4 Database Modeling And Normalization (2 Papers) For more classes visit www.snaptutorial.com This

6. . • Use technology and information resources to research issues in the strategic implications and management of database systems. • Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions. ****************************************** CIS 515 Week 6 Assignment 5 Tour Operator Agency Database (2 Papers) For more classes visit www.snaptutorial.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

7. 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 •Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and Open Office. The completed diagrams / charts must be imported into the Word document before the paper is submitted ****************************************** CIS 515 Week 7 Assignment 6 Sql Concepts And Database Design (2 Papers) For more classes visit www.snaptutorial.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.

8. 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 organization’s 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) • InvoiceLine (InvLineNumber, InvNumber, ProductNumber, Quantity) • Product (ProductNumber, ProductDescription, ProductCost) • Department (DepartmentID, DepartmentDescription) • Job (JobID, JobDescription) • Customer (CustomerID, CustomerName, CustomerAddress, CustomerPhone) Write a three to four (3-4) page paper in which you: 1. Create a data dictionary that includes the following: 1. A description of the content for each field 2. The data type of each field 3. The format the data will be stored as in the field 4. The range of value for the field 5. A label, as required, if the attribute is a primary key or foreign key Note: An example is shown in Table 7.3 in chapter 7 of the textbook. 2. Imagine that you are asked to identify the number of days that exist between the first invoice and last invoice for each month and complete the following: 1. Construct a query that will show the number of days that exist between the first invoice and last invoice, for each month, for each employee, using the DATEDIFF function. Be sure to provide the SQL script that will carry out this function. 2. Construct a query to show the expected payment date if invoices are due within 30 days of transaction. 3. Construct a query that will show distinct area codes of the customers. 3. Create a plan of the necessary activities that would be required to implement a valid database design process by including the following:

9. 1. Steps in the conceptual design stage 2. Steps in DBMS selection stage 3. Steps in logical design stage 4. Steps in physical design stage 5. Task details of each activity within each stage ****************************************** CIS 515 Week 10 Technical Paper Database Administrator For Department Store (2 Papers) For more classes visit www.snaptutorial.com This Tutorial contains 2 Papers CIS 515 that could be made available to provide disaster management functions for the database system within the retail environment. b. Assess the types of security threats that may exist when managing the department store database and suggest measure(s) that can be performed to minimize these threats that are particular to retail. 10. Use at least six (6) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources. Your assignment must follow these formatting requirements:

10. • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions. • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length. • Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and Open Office. The completed diagrams / charts must be imported into the Word document before the paper is submitted ****************************************** CIS 515 Week 8 Case Study Database Development (2 Papers) For more classes visit www.snaptutorial.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.

11. 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 >> Learning Resources Center >> Databases Scroll down to "Information Systems/Computing" The ACM Digital Library is located below the heading “Information Systems/Computing”. Write a two to three (2-3) page paper in which you: Recommend at least three (3) specific tasks that could be performed to improve the quality of datasets, using the Software Development Life Cycle (SDLC) methodology. Include a thorough description of each activity per each phase. Recommend the actions that should be performed in order to optimize record selections and to improve database performance from a quantitative data quality assessment. Suggest three (3) maintenance plans and three (3) activities that could be performed in order to improve data quality. 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. Analyze how the verify method can be used to plan out system effectively and ensure that the number of transactions do not produce record-level locking while the database is in operation. Your assignment must follow these formatting requirements: · Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must

12. follow APA or school-specific format. Check with your professor for any additional instructions. · Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length. ******************************************