Cis 515 Assignment 3

In: Business and Management

Submitted By coursehomework
Words 621
Pages 3
CIS 515 ASSIGNMENT 3
To purchase this visit following link: http://coursehomework.com/product/cis-515-assignment-3/ Contact us at:
HELP@COURSEHOMEWORK.COM
CIS 515 ASSIGNMENT 3
CIS515 Assignment 3: University Database – A Grade paper
Instant Download
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.
You met with various university subject matter experts and have determined the following after performing various business analysis processes:
• Faculty groups are divided by core competencies that the university offers. For example, there are groups such as the Art Faculty, Computer Technology Faculty, Language Faculty, and Science Faculty. Each faculty member has an assigned Dean and is designated to teach at one particular campus and school. They are able to teach as many courses as required.
• Courses are categorized by course code and title. Certain courses have prerequisites and the university has asked for this to be cataloged as well.
• There are various schools within each campus. For example, the Los Angeles campus holds the following schools: School of Science, School of Law, and School of Computer Technology. Additionally, each school offers different professional study programs such as Forensic Computer Science, Marine Biology, Business Management, and Civil Engineering to name a few.
• The study path for students requires that they be enrolled in a specific professional study program. The professional study program…...

Similar Documents

Cis 515 Week 5 Assignment

...CIS 515 Week 5 Assignment To Buy this Class Copy & paste below link in your Brower http://www.homeworkregency.com/downloads/cis-515-week-5-assignment/ Or Visit Our Website Visit : http://www.homeworkregency.com Email Us : homeworkregency@gmail.com CIS 515 Week 5 Assignment Tour Operator Agency Database Due Week 6 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. 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. Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics: • A table that stores all the......

Words: 17308 - Pages: 70

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment To Buy this Class Copy & paste below link in your Brower http://www.homeworkregency.com/downloads/cis-515-week-6-assignment/ Or Visit Our Website Visit : http://www.homeworkregency.com Email Us : homeworkregency@gmail.com CIS 515 Week 6 Assignment 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 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......

Words: 13856 - Pages: 56

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6......

Words: 760 - Pages: 4

Cis 515 Week 5 Assignment

...CIS 515 Week 5 Assignment To Buy this Class Copy & paste below link in your Brower http://homeworkregency.com/downloads/cis-515-week-5-assignment/ Or Visit Our Website Visit : http://www.homeworkregency.com Email Us : homeworkregency@gmail.com CIS 515 Week 5 Assignment Tour Operator Agency Database Due Week 6 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. 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. Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics: • A table that stores all the......

Words: 641 - Pages: 3

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment To Buy this Class Copy & paste below link in your Brower http://homeworkregency.com/downloads/cis-515-week-6-assignment/ Or Visit Our Website Visit : http://www.homeworkregency.com Email Us : homeworkregency@gmail.com CIS 515 Week 6 Assignment 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 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......

Words: 432 - Pages: 2

Cis 515 Week 5 Assignment

...CIS 515 Week 5 Assignment http://homeworkfy.com/downloads/cis-515-week-5-assignment/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Homeworkfy@gmail.com Visit our Site for More Tutorials: (http://homeworkfy.com/ ) Tour Operator Agency Database Due Week 6 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. 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. Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics: • A table that stores all the salespersons. The table......

Words: 641 - Pages: 3

Cis 515 Week 5 Assignment

...CIS 515 Week 5 Assignment http://homeworkfy.com/downloads/cis-515-week-5-assignment/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Homeworkfy@gmail.com Visit our Site for More Tutorials: (http://homeworkfy.com/ ) Tour Operator Agency Database Due Week 6 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. 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. Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics: • A table that stores all the salespersons. The table......

Words: 641 - Pages: 3

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment http://homeworkfy.com/downloads/cis-515-week-6-assignment/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Homeworkfy@gmail.com Visit our Site for More Tutorials: (http://homeworkfy.com/ ) 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 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......

Words: 432 - Pages: 2

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment http://homeworkfy.com/downloads/cis-515-week-6-assignment/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Homeworkfy@gmail.com Visit our Site for More Tutorials: (http://homeworkfy.com/ ) 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 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......

Words: 432 - Pages: 2

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment http://homeworkfy.com/downloads/cis-515-week-6-assignment/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Homeworkfy@gmail.com Visit our Site for More Tutorials: (http://homeworkfy.com/ ) 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 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......

Words: 432 - Pages: 2

Cis 515 Assignment 2

...CIS 515 ASSIGNMENT 2 To purchase this visit following link: http://coursehomework.com/product/cis-515-assignment-2/ Contact us at: HELP@COURSEHOMEWORK.COM CIS 515 ASSIGNMENT 2 CIS515 Assignment 2: Database Systems and Database Models Instant Download Due Week 2 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 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 employee’s commission rate by the total amount of product units sold. You have access to the following data sets: • Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID) • Invoice (InvNumber, InvDate, EmpNumber, InvAmount) • InvoiceLine (InvLineNumber, InvNumber, ProductNumber, Quantity) • Product (ProductNumber, ProductDescription, ProductCost) • Department (DepartmentID, DepartmentDescription) • Job...

Words: 494 - Pages: 2

Cis 515 Assignment 4

...CIS 515 ASSIGNMENT 4 To purchase this visit following link: http://coursehomework.com/product/cis-515-assignment-4/ Contact us at: HELP@COURSEHOMEWORK.COM CIS 515 ASSIGNMENT 4 CIS 515 Assignment 4: Database Modeling and Normalization – A Grade Paper Instant Download Due Week 4 and worth 90 points 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 allow them to perform HR core functions such as hiring, promotions, policy enforcement, benefits management, and training. Using this scenario, write a three to four (3-4) page paper in which you: 1. Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps / factors that one must consider in this process with consideration of the HR core functions and responsibilities of the client. 2. Analyze the risks that can occur if any of the developmental or iterative steps of creating an ERM Diagram are......

Words: 1113 - Pages: 5

Cis 515 Assignment 4

...CIS 515 ASSIGNMENT 4 To purchase this visit following link: http://coursehomework.com/product/cis-515-assignment-4/ Contact us at: HELP@COURSEHOMEWORK.COM CIS 515 ASSIGNMENT 4 CIS 515 Assignment 4: Database Modeling and Normalization – A Grade Paper Instant Download Due Week 4 and worth 90 points 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 allow them to perform HR core functions such as hiring, promotions, policy enforcement, benefits management, and training. Using this scenario, write a three to four (3-4) page paper in which you: 1. Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps / factors that one must consider in this process with consideration of the HR core functions and responsibilities of the client. 2. Analyze the risks that can occur if any of the developmental or iterative steps of creating an ERM Diagram are......

Words: 1113 - Pages: 5

Cis 515 Week 5 Assignment

...CIS 515 Week 5 Assignment To Buy this Class Copy & paste below link in your Brower http://homeworkregency.com/downloads/cis-515-week-5-assignment/ CIS 515 Week 5 Assignment Tour Operator Agency Database Due Week 6 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. 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. Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics: • A table that stores all the salespersons. The table holds their employee id, first name, last name and “Tours sold” field. The “Tours sold”......

Words: 627 - Pages: 3

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment To Buy this Class Copy & paste below link in your Brower http://homeworkregency.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment 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 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: a. A description of the content for each field b. The data type of each field...

Words: 418 - Pages: 2