Create a database schema that supports the companys business

Assignment Help Database Management System

Reference no: EM13772942

Project Deliverable 3: Database and Data Warehousing Design

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.

Section 1: Design Document

Write a six to ten (6) page design document in which you: (Continue with company WebFocus from Project Deliverable 1 & 2 - attached).

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 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 MS Visio or Dia as an appendix of the design document. All references to these diagrams must be included in the body of the design document.

Reference no: EM13772942

Questions Cloud

Determine the entropy change of the refrigerant : Determine the entropy change of the refrigerant during process - Calculate the applied pressure difference P1 - P2.

Compare and contrast the mmorpg interaction environment : Describe cognitive social phenomena that occur specifically to the context of the MMORPG that wouldn't happen in a face-to-face chess game. Compare and contrast the MMORPG interaction environment and a face-to-face environment where chess is being..

Discuss differences between the licensure and certification : Define and discuss the differences between the licensure and certification as they relate to health care providers or professionals.

What is the one change in morality that you would make : Consider the moral and ethical issues, dilemmas, controversies, and questions raised in this week's reading and video materials. What is the one change in morality that you would make by using the power of that ring

Create a database schema that supports the companys business : 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.

Protection of the collective buying power of american people : Analyze the FAR, and conclude whether or not these regulations overall offer adequate protection of the collective buying power of the American people. Prepare an argument in support of your position

Examine huizinga play theory : Examine Huizinga's "Play Theory." Why is "play" differentiated from other activity? What makes play "play" and not just another activity one does in the day?

Regulatory programs concerning petroleum tanks : What are the regulatory programs concerning petroleum tanks? Give positives and negatives for both Underground and Above Ground Storage Tanks. Give examples of exemptions under the tank program for registration requirements.An underground tank l..

Challenges associated with that particular lifecycle : Develop a diet specifically tailored to that stage of life (make sure to include all of the macronutrients (percentages of carbs, fats, and protein) and explain the rationale. Do not forget to discuss specific nutrients that may be of concern dur..

User Account

All Pages