Premium Essay

Cis 499 Project Deliverable 3

In: Business and Management

Submitted By activitymode
Words 2167
Pages 9
CIS 499 PROJECT DELIVERABLE 3
To purchase this visit here: http://www.activitymode.com/product/cis-499-project-deliverable-3/ Contact us at:
SUPPORT@ACTIVITYMODE.COM
PROJECT DELIVERABLE 3: DATABASE AND DATA WAREHOUSING DESIGN
This assignment consists of two (2) sections: a design document and a revised project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.
One of the main functions of any business is to be able to use data to leverage a strategic competitive advantage. This feat hinges upon a company’s ability to transform data into quality information. The use of relational databases is a necessity for contemporary organizations; however, data warehousing has become a strategic priority due to the enormous amounts of data that must be analyzed along with the varying sources from which data comes. Since you are now the CIO of a data-collection company which gathers data by using Web analytics and operational systems, you must design a solution overview that incorporates data warehousing. The executive team needs to be clear about what data warehousing can provide the company.
Section 1: Design Document 1.Write a four to six (4-6) page design document in which you: ◦Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to.
◦Create a schema that supports the company’s business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes.
◦Create an Entity-Relationship…...

Similar Documents

Premium Essay

Cis 109 Assignment 3

... Logical Design Gregory M Dowell CIS 111 Professor Thakkar 25 February 2014 Logical Design The purpose of normalization is to create a stable set of relations is representative of the operations of an enterprise. By doing this we are able to reduce redundancy to save space and avoid inconsistencies in data. It also ensures that the design is free of certain updates, insertions, and deletion anomalies (Ricardo, 2012). With normalization as with most anything else there are advantages and disadvantages. The advantages of normalization are: ACID, which stands for atomicity, consistency, isolation, and durability. Atomicity means the transaction is a single unit. Either the entire set of actions is carried out or is not. Consistency means that the user ensures their transactions will leave the database in a consistent state. Isolation is the requirement that the final effect of the transaction appear as if it were executed one after another instead of concurrently. Durability is ensuring that the effects are permanently recorded in a database even if the system crashes before all its rights are made to the database (Ricardo, 2012). Another advantage of normalization is performance. Well-normalized databases are faster to write to and access. Disadvantages of normalization are: they are difficult and expensive to do, require great skill and experience to create correctly, require discipline to maintain, and requires skill and discipline to keep well indexed......

Words: 1091 - Pages: 5

Premium Essay

Project Deliverable 5 Infrastructure and Security

...Project Deliverable 5: Infrastructure and Security This assignment consists of two (2) sections: an infrastructure document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment. The infrastructure which encompasses the network solution and security considerations is a major consideration for your company. Considering that the company will be expanding from one (1) floor to three (3) floors in the very near future you, as the CIO, are responsible for the design of the infrastructure and security protocols. You have been tasked with designing a network that is stable, redundant, and scalable. In addition, speed and reliability are important considerations. Assumptions should be drawn regarding network usage in relationship to network services and resources. All the established criteria that were set at the onset should be adhered to within your plan. The network solution that is chosen should support the conceived information system and allow for scalability. The network infrastructure will support organizational operations; therefore, a pictorial view of workstations, servers, routers, bridges, gateways, and access points should be used. In addition, access paths for Internet access should be depicted.......

Words: 724 - Pages: 3

Premium Essay

Project 3

...Problem Set 3 Name: Kaitlin Charles Problem Set 3 is to be completed by 11:59 p.m. (ET) on Monday of Module/Week 6. 1. Data for the market for graham crackers is shown below. Calculate the elasticity of demand between the following prices. |Price of crackers |Quantity Demanded (per month) | |$3 |80 | |$2.5 |120 | |$2 |160 | |$1.5 |200 | |$1 |240 | $1.00 - $1.50: 0.45 $1.50 - $2.00:0.78 $2.00 - $2.50: 1.29 $2.50 - $3.00: 2.2m If the price of graham crackers is $2.50 should firms raise or lower their prices if they want to increase revenue? Explain this in terms of elasticity. The firm should lower their prices 50 cents in an attempt to raise revenues. The elasticity of demand from 2.50-2.00 is 1.29, meaning with a reduction in prices there would be an elastic effect on quantity demanded. The maximum profit would be reached at the price of $2 because of the increased in demand with the price reduction. 2. Assume the competitive market shown below faces a short run price of $10. Using the graph below, identify the following: Profit maximizing output: 110 ...

Words: 617 - Pages: 3

Premium Essay

Cis 499 Week 7 Cloud Technology and Analytics

...CIS 499 Week 7 Cloud Technology and Analytics https://hwguiders.com/downloads/cis-499-week-7-cloud-technology-and-analytics/ CIS 499 Week 7 Cloud Technology and Analytics CIS 499 Week 7 Cloud Technology and Analytics https://hwguiders.com/downloads/cis-499-week-7-cloud-technology-and-analytics/ CIS 499 Week 7 Cloud Technology and Analytics CIS 499 Week 7 Cloud Technology and Analytics https://hwguiders.com/downloads/cis-499-week-7-cloud-technology-and-analytics/ CIS 499 Week 7 Cloud Technology and Analytics CIS 499 Week 7 Cloud Technology and Analytics https://hwguiders.com/downloads/cis-499-week-7-cloud-technology-and-analytics/ CIS 499 Week 7 Cloud Technology and Analytics CIS 499 Week 7 Cloud Technology and Analytics https://hwguiders.com/downloads/cis-499-week-7-cloud-technology-and-analytics/ CIS 499 Week 7 Cloud Technology and Analytics CIS 499 Week 7 Cloud Technology and Analytics https://hwguiders.com/downloads/cis-499-week-7-cloud-technology-and-analytics/ CIS 499 Week 7 Cloud Technology and Analytics CIS 499 Week 7 Cloud Technology and Analytics https://hwguiders.com/downloads/cis-499-week-7-cloud-technology-and-analytics/ CIS 499 Week 7 Cloud Technology and Analytics CIS 499 Week 7 Cloud Technology and Analytics https://hwguiders.com/downloads/cis-499-week-7-cloud-technology-and-analytics/ CIS 499 Week 7 Cloud Technology and Analytics CIS 499 Week 7 Cloud Technology and Analytics https://hwguiders.com/downloa...

Words: 952 - Pages: 4

Premium Essay

Cis 499 Week 8 Infrastructure Project Plan

...CIS 499 Week 8 Infrastructure Project Plan https://hwguiders.com/downloads/cis-499-week-8-infrastructure-project-plan/ CIS 499 Week 8 Infrastructure Project Plan CIS 499 Week 8 Infrastructure Project Plan https://hwguiders.com/downloads/cis-499-week-8-infrastructure-project-plan/ CIS 499 Week 8 Infrastructure Project Plan CIS 499 Week 8 Infrastructure Project Plan https://hwguiders.com/downloads/cis-499-week-8-infrastructure-project-plan/ CIS 499 Week 8 Infrastructure Project Plan CIS 499 Week 8 Infrastructure Project Plan https://hwguiders.com/downloads/cis-499-week-8-infrastructure-project-plan/ CIS 499 Week 8 Infrastructure Project Plan CIS 499 Week 8 Infrastructure Project Plan https://hwguiders.com/downloads/cis-499-week-8-infrastructure-project-plan/ CIS 499 Week 8 Infrastructure Project Plan CIS 499 Week 8 Infrastructure Project Plan https://hwguiders.com/downloads/cis-499-week-8-infrastructure-project-plan/ CIS 499 Week 8 Infrastructure Project Plan CIS 499 Week 8 Infrastructure Project Plan https://hwguiders.com/downloads/cis-499-week-8-infrastructure-project-plan/ CIS 499 Week 8 Infrastructure Project Plan CIS 499 Week 8 Infrastructure Project Plan https://hwguiders.com/downloads/cis-499-week-8-infrastructure-project-plan/ CIS 499 Week 8 Infrastructure Project Plan CIS 499 Week 8 Infrastructure Project Plan https://hwguiders.com/downloads/cis-499-week-8-infrastructure-project-plan/ CIS 499 Week 8......

Words: 1275 - Pages: 6

Free Essay

Cis 499 Week 10 Executive Summary

...CIS 499 Week 10 Executive Summary https://hwguiders.com/downloads/cis-499-week-10-executive-summary/ CIS 499 Week 10 Executive Summary CIS 499 Week 10 Executive Summary https://hwguiders.com/downloads/cis-499-week-10-executive-summary/ CIS 499 Week 10 Executive Summary CIS 499 Week 10 Executive Summary https://hwguiders.com/downloads/cis-499-week-10-executive-summary/ CIS 499 Week 10 Executive Summary CIS 499 Week 10 Executive Summary https://hwguiders.com/downloads/cis-499-week-10-executive-summary/ CIS 499 Week 10 Executive Summary CIS 499 Week 10 Executive Summary https://hwguiders.com/downloads/cis-499-week-10-executive-summary/ CIS 499 Week 10 Executive Summary CIS 499 Week 10 Executive Summary https://hwguiders.com/downloads/cis-499-week-10-executive-summary/ CIS 499 Week 10 Executive Summary CIS 499 Week 10 Executive Summary https://hwguiders.com/downloads/cis-499-week-10-executive-summary/ CIS 499 Week 10 Executive Summary CIS 499 Week 10 Executive Summary https://hwguiders.com/downloads/cis-499-week-10-executive-summary/ CIS 499 Week 10 Executive Summary CIS 499 Week 10 Executive Summary https://hwguiders.com/downloads/cis-499-week-10-executive-summary/ CIS 499 Week 10 Executive Summary CIS 499 Week 10 Executive Summary https://hwguiders.com/downloads/cis-499-week-10-executive-summary/ CIS 499 Week 10 Executive Summary CIS 499 Week 10 Executive......

Words: 924 - Pages: 4

Free Essay

Crj 499 Assignment 3 Technology Influences

...CRJ 499 Assignment 3 Technology Influences http://hwguiders.com/downloads/crj-499-assignment-3-technology-influences/ CRJ 499 Assignment 3 Technology Influences CRJ 499 Assignment 3 Technology Influences http://hwguiders.com/downloads/crj-499-assignment-3-technology-influences/ CRJ 499 Assignment 3 Technology Influences CRJ 499 Assignment 3 Technology Influences http://hwguiders.com/downloads/crj-499-assignment-3-technology-influences/ CRJ 499 Assignment 3 Technology Influences CRJ 499 Assignment 3 Technology Influences http://hwguiders.com/downloads/crj-499-assignment-3-technology-influences/ CRJ 499 Assignment 3 Technology Influences CRJ 499 Assignment 3 Technology Influences http://hwguiders.com/downloads/crj-499-assignment-3-technology-influences/ CRJ 499 Assignment 3 Technology Influences CRJ 499 Assignment 3 Technology Influences http://hwguiders.com/downloads/crj-499-assignment-3-technology-influences/ CRJ 499 Assignment 3 Technology Influences CRJ 499 Assignment 3 Technology Influences http://hwguiders.com/downloads/crj-499-assignment-3-technology-influences/ CRJ 499 Assignment 3 Technology Influences CRJ 499 Assignment 3 Technology Influences http://hwguiders.com/downloads/crj-499-assignment-3-technology-influences/ CRJ 499 Assignment 3 Technology Influences CRJ 499 Assignment 3 Technology Influences http://hwguiders.com/downloads/crj-499-assignment-3-technology-influences/ CRJ 499 Assignment 3 Technology......

Words: 858 - Pages: 4

Premium Essay

Project Deliverables

...Strayer University Project Deliverable 5: Infrastructure and Security Yan Li CIS590: Information Systems Capstone Professor Amir Afzal 31 May 2013   Table of Contents Figure 1: Current physical layout 5 2 Figure 2: Current logical layout 5 2 Figure 3: Planned physical layout 6 2 Figure 4: Planned Logical layout 6 2 1. Infrastructure and Security 3 2. Network 5 2.1 Current Network 5 2.2 Planned network 6 3. Security Policy 7 3.1 Process Policy 7 3.2 Employee Policy 8 Table of Figures Figure 1: Current physical layout 5 Figure 2: Current logical layout 5 Figure 3: Planned physical layout 6 Figure 4: Planned Logical layout 6   1. Infrastructure and Security The network infrastructure is critical to the success of business. Day in and day out, users rely on the network to do their jobs well. Network uptime is crucial to the company’s operation and is becoming even more important as technology advances. Network infrastructure refers to the grouping of physical hardware and logical components which are needed to provide a number of features for the network, such as connectivity, routing and switching capabilities, network security, and access control. The physical infrastructure of the network refers to the physical design of the network together with the hardware components. The logical infrastructure of the network consists of all the software components required to enable connectivity between devices, and to......

Words: 1515 - Pages: 7

Premium Essay

Eco 561 Week 3 Learning Team Deliverable

...A++PAPER;http://www.homeworkproviders.com/shop/eco-561-week-3-learning-team-deliverable/ ECO 561 WEEK 3 LEARNING TEAM DELIVERABLE ECO 561 Week 3 Learning Team Deliverable Learning Team Deliverable As future business managers or entrepreneurs, the classification and types of marketstructure, upsurge the team’s interest. Thus, this week’s team deliverable focuses on pure monopoly, monopolistic competitive markets, oligopoly, and pure competition. In economics, market structure refers to the number of firms producing identical products or services. In a pure monopoly there is only one! The team pinpointed some key terms that helped us differentiate this type of market from the other three structures. A“single seller” monopoly is one where a single firm is the sole producer of a good or service. A "no close substitutes" is a company that sales a product and there is nothing in the market the can be used as a substitute, therefore everyone have only one place to go to buy the produce. The "price maker" is when a firm has control over the quantity supplied; consequently they will have control over the price of the product they are producing. The "blocked entry" limits competitors from entering a market due to certain barriers such as economic or legal, things such as patents or licenses (McConnell, Brue & Flynn, 2009).A monopoly exists when there is only one supplier of a good, with no close substitutes; the smaller the number of firm in this industry, and the......

Words: 487 - Pages: 2

Premium Essay

Eco 561 Week 3 Learning Team Deliverable

...ECO 561 WEEK 3 LEARNING TEAM DELIVERABLE A+ Graded Tutorial Available At: http://hwsoloutions.com/?product=eco-561-week-3-learning-team-deliverable Visit Our website: http://hwsoloutions.com/ Product Description PRODUCT DESCRIPTION ECO 561 Week 3 Learning Team Deliverable Learning Team Deliverable As future business managers or entrepreneurs, the classification and types of marketstructure, upsurge the team’s interest. Thus, this week’s team deliverable focuses on pure monopoly, monopolistic competitive markets, oligopoly, and pure competition. In economics, market structure refers to the number of firms producing identical products or services. In a pure monopoly there is only one! The team pinpointed some key terms that helped us differentiate this type of market from the other three structures. A“single seller” monopoly is one where a single firm is the sole producer of a good or service. A “no close substitutes” is a company that sales a product and there is nothing in the market the can be used as a substitute, therefore everyone have only one place to go to buy the produce. The “price maker” is when a firm has control over the quantity supplied; consequently they will have control over the price of the product they are producing. The “blocked entry” limits competitors from entering a market due to certain barriers such as economic or legal, things such as patents or licenses (McConnell, Brue & Flynn, 2009).A monopoly exists when there is only one......

Words: 501 - Pages: 3

Free Essay

Cis 515 Assignment 3

...CIS 515 ASSIGNMENT 3 To purchase this visit following link: https://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......

Words: 621 - Pages: 3

Free Essay

Cis 336 Group Project

...CIS 336 GROUP PROJECT To purchase this visit following link: http://www.activitymode.com/product/cis-336-group-project/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 336 GROUP PROJECT CIS336 Week 3 Group Project Task 1 Data Model CIS336 Week 4 Group Project Task 2 CIS336 Week 5 Group Project Task 3 CIS336 Week 6 Group Project Task 4 CIS336 Week 7 Group Project Task 5 CIS 336 GROUP PROJECT To purchase this visit following link: http://www.activitymode.com/product/cis-336-group-project/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 336 GROUP PROJECT CIS336 Week 3 Group Project Task 1 Data Model CIS336 Week 4 Group Project Task 2 CIS336 Week 5 Group Project Task 3 CIS336 Week 6 Group Project Task 4 CIS336 Week 7 Group Project Task 5 CIS 336 GROUP PROJECT To purchase this visit following link: http://www.activitymode.com/product/cis-336-group-project/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 336 GROUP PROJECT CIS336 Week 3 Group Project Task 1 Data Model CIS336 Week 4 Group Project Task 2 CIS336 Week 5 Group Project Task 3 CIS336 Week 6 Group Project Task 4 CIS336 Week 7 Group Project Task 5 CIS 336 GROUP PROJECT To purchase this visit following link: http://www.activitymode.com/product/cis-336-group-project/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 336 GROUP PROJECT CIS336 Week 3 Group Project Task 1 Data Model CIS336 Week 4 Group Project Task 2 CIS336 Week 5 Group Project Task 3 CIS336 Week 6 Group Project Task......

Words: 594 - Pages: 3

Premium Essay

Cis Final Project

...Computer Concepts and Applications-GS July 2015 Final Project You have been hired by a medium size (approximately 200 employees) widget manufacturing company to do a complete evaluation of their computer needs and make recommendations to them about an information system to support their business. Currently several of their support departments are using manual processes and they wish to automate their accounting and human resources business processes. They also want to harness the power of the Internet in their business. Making Your Company Greater Through Technology As we head into the future, it important for any business organization to be prepared. The evolution of business technologically is rapid, and it’s important to stay updated. As this company continues to grow, many changes need to be considered to help its continued success. One of the most important changes that need to be considered is an implementation of an information system to support the business. This system will be implemented throughout the company and support departments such as accounting and human resources. What is an Information System? An information system is the corresponding networks or components of hardware and software that are used to accumulate, filter, develop, create, and deliver information. There are four main components of an information system: hardware, software, data, and communication. Hardware is the part of the information system that a person can touch- the......

Words: 1593 - Pages: 7

Premium Essay

Cis 336 Week 3 Group Project Task 1 Data Model

...CIS 336 Week 3 Group Project Task 1 Data Model To Buy This material Click below link http://www.uoptutors.com/cis-336-devry/cis-336-week-3-group-project-task-1-data-model Present a detailed data model for the project scenario. You can create your data model using Microsoft Visio, which you will have access to through iLab and Microsoft Excel, which comes with Microsoft Office. Other tools may be used as long as the output is legible and conforms to standard format. (i.e. I will not be able to grade the data model if I cannot tell what it is supposed to be!). Your data model should include a minimum of an ERD and metadata chart (data dictionary). A key component to every task submission is the team responsibilities document. This document should outline the contributions that each member of the team made to completing the task deliverable. There is a sample document in the Doc Sharing tab that can be used, or each team can come up with their own design. As stated in the syllabus, although this is a team project, each member will also be graded on their involvement in the project. This assessment needs to be honest and accurate in describing the individual members’ activities for the task. Deliverables for this task: A completed Data Model to include: An ERD, showing all tables, related attributes, and the primary and foreign keys. This diagram must show both the relationship and cardinality of the relationship using accepted notation. A Data Dictionary (or meta......

Words: 294 - Pages: 2

Premium Essay

Cis 336 Week 5 Group Project Task 3

...CIS 336 Week 5 Group Project Task 3 To Buy This material Click below link http://www.uoptutors.com/cis-336-devry/cis-336-week-5-group-project-task-3 Develop the SQL statements to insert records into the database. You should ensure that the data in the database is sufficient to allow for each of the reports requested by Ms. Smith to be tested. You need to show a minimum of three insert queries for each database table that you have created. Some tables will obviously require more to ensure that all of the required data is in the database (i.e., the packages table, program table, etc). To submit this task, add a comment heading called INSERT STATEMENTS to your corrected SQL script from Task 2. Add your INSERT statements for each table after this heading. Keep in mind that you will need to insert data into the tables in the same order that the tables were created. This will minimize any integrity constraint errors you might encounter. Keep in mind also that any values being inserted into a field defined as a foreign key field must first exist in a previous table’s primary key field. Save the file as TEAM_X_TASK3.TXT, where X is your team identifier. After testing your statements to verify that your data will insert into your tables, create a spooled output file with the SET ECHO ON session command set for submitting. Note – Although you are only required to have three records per table in most of your tables for this deliverable, you will need a considerable amount of......

Words: 365 - Pages: 2