How can a schema be created to support a company’s business and processes in data warehousing?

  

Project Deliverable 3: Database and Data Warehousing DesignDue Week 5 and
worth 110 pointsThis 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
companys 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
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 companys 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 (E-R) Diagram 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 your rationale behind the design of your E-R Diagram.
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.
Illustrate the flow of data including both inputs and outputs for the use of
a data warehouse. The diagram must map data between source systems, data
warehouses and specified data marts. The diagram should map data between source
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 students
name, the professors 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.Section 2: Revised Project PlanUse
Microsoft Project to:
Update the project plan from Project Deliverable 2: Business Requirements,
with three to five (3-5) new project tasks each consisting of five to ten (5-10)
sub-tasks.The specific course learning outcomes associated with this
assignment are:
Summarize how information systems represent a key source of competitive
advantage for organizations.
Develop information systems-related activities to maximize the business
value within and outside the organization.
Use technology and information resources to research issues in information
systems.
Write clearly and concisely about strategic issues and practices in the
information systems domain using proper writing mechanics and technical style
conventions.

Introduction:

Don't use plagiarized sources. Get Your Custom Essay on
How can a schema be created to support a company’s business and processes in data warehousing?
Just from $13/Page
Order Essay

In today’s digital age, data has become an essential component for organizations to stay ahead in the competition. The effective use of data can provide businesses with a strategic competitive advantage. And this is where data warehousing comes into the picture. Data warehousing has become a strategic priority for contemporary organizations due to the ever-increasing amount of data that organizations need to analyze. This project deliverable 3 aims to design a solution overview that incorporates data warehousing for a data-collection company. As the Chief Information Officer (CIO) of this company, our goal is to provide the executive team with a clear understanding of how data warehousing can benefit the company.

Description:

This project deliverable consists of two sections: a design document and a revised project plan. The design document specifically aims to create a schema that supports the company’s business and processes. Additionally, we will create an Entity-Relationship (E-R) diagram and a Data Flow Diagram (DFD) to illustrate the flow of data. The schema design must entail tables, fields, relationships, views, and indexes. The E-R diagram relates the tables of the database schema using Microsoft Visio or an open-source alternative. The DFD must illustrate the flow of data, including both inputs and outputs, for the use of a data warehouse. Mapping data between source systems, data warehouse, and specified data marts is crucial to this process and needs to be accurately depicted. The project deliverable 3 aims to support the need for data warehousing within the company and elaborate on the best practices that the company will adhere to.

course title, and the date. The cover page and the reference page are not included in the required assignment page length. Section 2: Revised Project Plan Update the project plan from Project Deliverable 2: Business Requirement, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks. The specific course learning outcomes associated with this assignment are: Describe the role of databases and data warehouses in managing enterprise data and supporting organizational decision-making. Develop a data model, representing entities, attributes, relationships, and constraints for a business scenario. Develop a schema, using SQL commands, that supports business processes and user requirements. 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.

Solution 1:

To support the need for data warehousing within the company, a comprehensive solution overview must be developed that incorporates best practices. The company must adhere to the principles of data warehousing so that the enormous amounts of data that are collected can be analyzed and transformed into high-quality information that can be used to gain competitive advantages. The best practices to be followed include:

1. Developing a clear understanding of the data warehousing system requirements.
2. Designing a scalable and flexible data architecture.
3. Adopting a methodology that streamlines the design and development process.
4. Ensuring robust data integration between source systems and the data warehouse.
5. Developing an efficient data cleansing process.
6. Providing appropriate data access controls.
7. Focusing on providing regular monitoring and maintenance of the data warehouse.

To support the company’s business and processes, the following tables, fields, relationships, views, and indexes should be included in the schema:

1. Customer table
2. Product table
3. SalesOrder table
4. SalesOrderItem table
5. Warehouse table
6. Shipments table
7. Inventory table

The relationships between the tables are shown in the Entity-Relationship (ER) Diagram. As for the rationale behind designing the ER Diagram, it enables easy understanding of how the tables relate to one another and how data moves between them. The ER Diagram also helps to identify the key attributes and entities that are required for the successful operation of the system.

For illustrating the flow of data between source systems, data warehouses, and specified data marts, a Data Flow Diagram (DFD) must be created. The DFD should map data between source systems, data warehouses, and specified data marts, illustrating the movement of data inputs and outputs. The diagram must be designed using graphical tools like Microsoft Visio or a free alternative like Dia.

Solution 2:

One of the primary challenges of contemporary organizations is to transform their data into quality information to gain competitive advantages. Therefore, there is a need for data warehousing within the company, which gathers data using Web analytics and operational systems. To design a comprehensive solution overview incorporating data warehousing, the company should follow these best practices:

1. Adopt a comprehensive data warehousing methodology.
2. Develop an appropriate data architecture that supports scalability.
3. Enhance data integration between source systems and data warehouse.
4. Streamline the design and development process.
5. Establish robust data cleaning and data access controls.
6. Regular monitoring of the data warehouse to ensure that it meets changing business requirements.

To support the company’s business and processes, the following tables, fields, relationships, views, and indexes should be included in the schema:

1. Customer table
2. Product table
3. SalesOrder table
4. SalesOrderItem table
5. Warehouse table
6. Shipments table
7. Inventory table

The relationships between the tables are presented in the Entity-Relationship (ER) Diagram. The ER Diagram helps to establish how data moves between tables and enables a clear understanding of how the various entities relate to each other.

To illustrate data flow between source systems, data warehouses, and specified data marts, a Data Flow Diagram (DFD) must be created. The DFD should map data between source systems, data warehouses, and specified data marts, illustrating the inputs and outputs of data. The purpose of the DFD is to enable easy understanding of how data flows in the system. The diagram must be designed using graphical tools such as Microsoft Visio or a free alternative.

course title, and the date. The cover page and the reference page are not included in the required assignment page length. Section 2: Revised Project Plan Use Microsoft Project or an open source alternative, such as Open Project, to: Update the project plan from Project Deliverable 2: Business Requirements, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks. 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. Recognize the historical development of database management systems and logical data models. Evaluate the importance of the relationship between data warehousing and data mining. Design and implement a database solution by creating entity relationship diagrams, relational schema, and tables. 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.
Suggested Resources/Books:
1. Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling by Ralph Kimball
2. Building a Data Warehouse: With Examples in SQL Server by Vincent Rainardi
3. SQL Cookbook: Query Solutions and Techniques for All SQL Users by Anthony Molinaro

Similar asked questions:
1. What is the importance of data warehousing in contemporary organizations?
2. How can a company transform data into quality information for strategic competitive advantage?
3. What are the best practices for designing a database schema that supports a company’s business and processes?
4. Explain the use of Entity-Relationship (E-R) Diagram and Data Flow Diagram (DFD) in the design of a database schema.
5. What is the role of graphical tools like Microsoft Visio or Dia in designing a solution to support data warehousing?Project Deliverable 3: Database and Data Warehousing DesignDue Week 5 and
worth 110 pointsThis 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
companys 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
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 companys 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 (E-R) Diagram 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 your rationale behind the design of your E-R Diagram.
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.
Illustrate the flow of data including both inputs and outputs for the use of
a data warehouse. The diagram must map data between source systems, data
warehouses and specified data marts. The diagram should map data between source
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 students
name, the professors 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.Section 2: Revised Project PlanUse
Microsoft Project to:
Update the project plan from Project Deliverable 2: Business Requirements,
with three to five (3-5) new project tasks each consisting of five to ten (5-10)
sub-tasks.The specific course learning outcomes associated with this
assignment are:
Summarize how information systems represent a key source of competitive
advantage for organizations.
Develop information systems-related activities to maximize the business
value within and outside the organization.
Use technology and information resources to research issues in information
systems.
Write clearly and concisely about strategic issues and practices in the
information systems domain using proper writing mechanics and technical style
conventions.

Introduction:

In today’s digital age, data has become an essential component for organizations to stay ahead in the competition. The effective use of data can provide businesses with a strategic competitive advantage. And this is where data warehousing comes into the picture. Data warehousing has become a strategic priority for contemporary organizations due to the ever-increasing amount of data that organizations need to analyze. This project deliverable 3 aims to design a solution overview that incorporates data warehousing for a data-collection company. As the Chief Information Officer (CIO) of this company, our goal is to provide the executive team with a clear understanding of how data warehousing can benefit the company.

Description:

This project deliverable consists of two sections: a design document and a revised project plan. The design document specifically aims to create a schema that supports the company’s business and processes. Additionally, we will create an Entity-Relationship (E-R) diagram and a Data Flow Diagram (DFD) to illustrate the flow of data. The schema design must entail tables, fields, relationships, views, and indexes. The E-R diagram relates the tables of the database schema using Microsoft Visio or an open-source alternative. The DFD must illustrate the flow of data, including both inputs and outputs, for the use of a data warehouse. Mapping data between source systems, data warehouse, and specified data marts is crucial to this process and needs to be accurately depicted. The project deliverable 3 aims to support the need for data warehousing within the company and elaborate on the best practices that the company will adhere to.

course title, and the date. The cover page and the reference page are not included in the required assignment page length. Section 2: Revised Project Plan Update the project plan from Project Deliverable 2: Business Requirement, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks. The specific course learning outcomes associated with this assignment are: Describe the role of databases and data warehouses in managing enterprise data and supporting organizational decision-making. Develop a data model, representing entities, attributes, relationships, and constraints for a business scenario. Develop a schema, using SQL commands, that supports business processes and user requirements. 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.

Solution 1:

To support the need for data warehousing within the company, a comprehensive solution overview must be developed that incorporates best practices. The company must adhere to the principles of data warehousing so that the enormous amounts of data that are collected can be analyzed and transformed into high-quality information that can be used to gain competitive advantages. The best practices to be followed include:

1. Developing a clear understanding of the data warehousing system requirements.
2. Designing a scalable and flexible data architecture.
3. Adopting a methodology that streamlines the design and development process.
4. Ensuring robust data integration between source systems and the data warehouse.
5. Developing an efficient data cleansing process.
6. Providing appropriate data access controls.
7. Focusing on providing regular monitoring and maintenance of the data warehouse.

To support the company’s business and processes, the following tables, fields, relationships, views, and indexes should be included in the schema:

1. Customer table
2. Product table
3. SalesOrder table
4. SalesOrderItem table
5. Warehouse table
6. Shipments table
7. Inventory table

The relationships between the tables are shown in the Entity-Relationship (ER) Diagram. As for the rationale behind designing the ER Diagram, it enables easy understanding of how the tables relate to one another and how data moves between them. The ER Diagram also helps to identify the key attributes and entities that are required for the successful operation of the system.

For illustrating the flow of data between source systems, data warehouses, and specified data marts, a Data Flow Diagram (DFD) must be created. The DFD should map data between source systems, data warehouses, and specified data marts, illustrating the movement of data inputs and outputs. The diagram must be designed using graphical tools like Microsoft Visio or a free alternative like Dia.

Solution 2:

One of the primary challenges of contemporary organizations is to transform their data into quality information to gain competitive advantages. Therefore, there is a need for data warehousing within the company, which gathers data using Web analytics and operational systems. To design a comprehensive solution overview incorporating data warehousing, the company should follow these best practices:

1. Adopt a comprehensive data warehousing methodology.
2. Develop an appropriate data architecture that supports scalability.
3. Enhance data integration between source systems and data warehouse.
4. Streamline the design and development process.
5. Establish robust data cleaning and data access controls.
6. Regular monitoring of the data warehouse to ensure that it meets changing business requirements.

To support the company’s business and processes, the following tables, fields, relationships, views, and indexes should be included in the schema:

1. Customer table
2. Product table
3. SalesOrder table
4. SalesOrderItem table
5. Warehouse table
6. Shipments table
7. Inventory table

The relationships between the tables are presented in the Entity-Relationship (ER) Diagram. The ER Diagram helps to establish how data moves between tables and enables a clear understanding of how the various entities relate to each other.

To illustrate data flow between source systems, data warehouses, and specified data marts, a Data Flow Diagram (DFD) must be created. The DFD should map data between source systems, data warehouses, and specified data marts, illustrating the inputs and outputs of data. The purpose of the DFD is to enable easy understanding of how data flows in the system. The diagram must be designed using graphical tools such as Microsoft Visio or a free alternative.

course title, and the date. The cover page and the reference page are not included in the required assignment page length. Section 2: Revised Project Plan Use Microsoft Project or an open source alternative, such as Open Project, to: Update the project plan from Project Deliverable 2: Business Requirements, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks. 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. Recognize the historical development of database management systems and logical data models. Evaluate the importance of the relationship between data warehousing and data mining. Design and implement a database solution by creating entity relationship diagrams, relational schema, and tables. 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.
Suggested Resources/Books:
1. Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling by Ralph Kimball
2. Building a Data Warehouse: With Examples in SQL Server by Vincent Rainardi
3. SQL Cookbook: Query Solutions and Techniques for All SQL Users by Anthony Molinaro

Similar asked questions:
1. What is the importance of data warehousing in contemporary organizations?
2. How can a company transform data into quality information for strategic competitive advantage?
3. What are the best practices for designing a database schema that supports a company’s business and processes?
4. Explain the use of Entity-Relationship (E-R) Diagram and Data Flow Diagram (DFD) in the design of a database schema.
5. What is the role of graphical tools like Microsoft Visio or Dia in designing a solution to support data warehousing?

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
× How can I help you?