All necessary assumptions needed for the completion

Assignment Help Basic Computer Science
Reference no: EM13707541

Design database document. This assignment consists of two (2) sections: a project introduction and a design document. You must submit both sections as ONE file 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.

You are currently the Chief Information Officer (CIO) for an innovative Internet-based company with gross revenues of more than $35 million dollars per year. During an executive leadership meeting, you were told that your company will be merging with a multinational company of equal size and you will be responsible for developing a project plan to strategically integrate all systems, including databases and infrastructure. The Chief Executive Officer has given you sixty (60) days to deliver an information technology project plan in anticipation of the company merger. Your company will be expanding from one (1) floor to three (3) floors within six (6) months. Since this merger will be bringing two (2) fairly equal-sized companies together under one roof, the infrastructure must be redesigned to accommodate the increased needs. Your company currently uses operational systems and relational databases but desires to expand into data warehousing. All information technology (hardware and software) must be redesigned to meet organizational needs. The solution should be implemented in either a hosted solution, on-site solution, or a hybrid model. The CEO is expecting you to integrate different technologies from different solution providers and incorporate industry best practices in connection with the development of technological systems. In addition, the CEO is extremely interested in cloud technologies and virtualization but is leery of security issues; however, the CEO is sure that you will implement proper security protocols. The company currently consists of twenty five (25) employees but is expected to increase to sixty five (65) employees when the merger is complete.

Required Design Document for #1


Write at least five (5) pages (MUST include at least 2 APA typed reference list) project introduction that documents the current state of the organization prior to any development or enhancements, takes into account all the information given above, and includes the following:

1. Background information of the company.
2. Details regarding the type of business activities that the company is involved in.
3. Speculation on outsourcing or offshoring opportunities.
4. A description of the current information systems that the company has to support the business. The description should include an overview of the following: operational systems, databases, and data warehousing; cloud technology and virtualization; and network infrastructure and security.
5. The use of at least two (2) quality resources in this assignment. Note: Wikipedia

 

Required Design Document for #2

One of the main functions of any business is to transform data into information. The use of relational databases and data warehousing has gained recognition as a standard for organizations. A quality database design makes the flow of data seamless. The database schema is the foundation of the relational database. The schema defines the tables, fields, relationships, views, indexes, and other elements. The schema should be created by envisioning the business, processes, and workflow of the company. Since your company is an innovative Internet-based company, movement toward data warehousing seems to be one of the most viable options to give your company a competitive advantage; however, these concepts must be explained to the executive board in a manner to garner support.
Write at least ten-fifteen (10-15) pages (MUST include at least 3 APA typed reference list) design document in which you:

1. Support the need for the use of relational databases and data warehousing. From a management standpoint, it may be important to show the efficiencies that can be gained for executive oversight.

2. Create a database 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.

3. Identify and create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved. Normalize the database tables to third normal form (3NF).

4. Identify and create an Entity-Relationship (E-R) Diagram relating the tables of the database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted
solution is not included in the required page length but must be included in the design document appendix. Explain your rationale behind the design of the E-R Diagram.

5. Identify and create a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. Explain the rationale behind the design of your DFD.

6. Illustrate the flow of data including both inputs and outputs for the use of a data warehouse. The diagram should map data between source systems, operational systems, data warehouses and specified data marts. Note: The graphically depicted solution is not included in the required page length.
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 follow APA format.

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 MS Word. All references to these diagrams must be included in the body of the design document.

Verified Expert

Reference no: EM13707541

Questions Cloud

How does the answer depend on the shape of hill surface : A ball is rolling up a hill with a smooth surface. Initial kinetic energy of the ball is equal to its potential energy on the top of the hill. How does the answer depend on the shape of the hill surface
How long is the flea in the air from the time it jumps : A flea jumps straight up to a maximum height of 0.500m. How long is the flea in the air from the time it jumps
What is the average velocity for the time interval : The position of an object moving in a straight line is given by x = 5t-t2+9t3, where x is in meters and t in seconds. What is the average velocity for the time interval from t = 2 s to t = 4 s
Discuss results of two individual sales manager interview : Discuss the results of two individual sales manager interview and analysis of SWOT any everything for two different invidual sales manager.
All necessary assumptions needed for the completion : Design database document. This assignment consists of two (2) sections: a project introduction and a design document. You must submit both sections as ONE file for the completion of this assignment. Label each file name according to the section..
How long is the flea in the air from the time : A flea jumps straight up to a maximum height of 0.360m. How long is the flea in the air from the time it jumps to the time it hits the ground
What would be the braking distance : A car traveling at a speed of v can brake to an emergency stop in a distance x. What would be the braking distance if the car were traveling at 60.0km/h
Find the tension in each part of the rope : A piñata of mass M = 6.7 kg is attached to a rope of negligible mass that is strung between the tops of two vertical poles. Find the tension (T) in each part of the rope due to the weight of the piñata
How long does the bullet take to pass through it : A bullet traveling horizontally at a speed of 330m/s hits a board perpendicular to its surface, how long does the bullet take to pass through it

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Review and discuss methods for it managers to maintain

Review and discuss methods for IT managers to maintain their skills while gaining new managerial skills

  Advantages of logging more information to alerts file

What are the advantages of logging more information to the alerts file? What are the disadvantages of logging more information to the alerts file?

  Writing a new class that is derived from another class

Writing a new class that is derived from another class.You will be given the code for a Car class. Your job is to write a CustomCar class that is derived from Car and adds new features to it.

  Case of healthy people pharmacy

Consider the case of Healthy People Pharmacy. Healthy People Pharmacy is a small town pharmacy that not only sells pharmaceuticals but also sells items ranging from milk to socks

  Attributes and behaviors

Write a Class called Course containing the following attributes and behaviors

  Use the sql command line in oracle to perform

One of a DBA's primary responsibilities is to create and manage database user accounts and to grant or revoke access privileges as needed. Users should be able to access or modify only those parts of the database that they need to perform their jo..

  Netstack college has received a grant to wire all

Netstack College has received a grant to wire all of its six buildings for 10/100 Ethernet. Four of the buildings contain classrooms and laboratories and will need to support 250 network connections each. One building is for administration and ..

  Recognize components of system cpu

Recognize the following components of your system: type of central processing unit (CPU), amounts of random access memory (RAM) and read-only memory (ROM), input and output devices, and types of storage.

  Make a c program using cramers rule using 3 variables and eq

make a C program using cramers rule using 3 variables and 3 equations. I need help why the third variable says it isnt initialized and allow the the determinents to be calculated. also i need help making a menu allowing the user to make a start the p..

  Display the total and average number of calories burned

How would you solve the following in C++? Please write code below: Write a condition-controlled while loop that allows the user to enter the calories they burned.

  Designing an application server

Designing an Application Server

  Manipulate the dom on a web page.

In your own words, give a practical example of why you might want to traverse or manipulate the DOM on a Web page. What task would you want accomplish?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd