Create an e-r diagram relating table of your database schema

Assignment Help Database Management System
Reference no: EM131269947

Assigmnment

Section 1: Design Document

1. Write a four to six page design document in which you:

o Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to.

o 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.

o 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.

o 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.

o 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 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.

Section 2: Revised Project Plan

Use Microsoft Project to:

2. Update the project plan from Project Deliverable 2: Business Requirements, with three to five new project tasks each consisting of five to ten 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.

Reference no: EM131269947

Questions Cloud

How to install windows server on the servers at wadley inc : Write a 350- to 500-word paper on how to install Windows Server 2012 on the servers at Wadley, Inc. Also, cover how to install Active Directory and how it functions. Explain the schema and global catalog.
Develop an outline for a proposed project that would meet : As a result, your manager has given you the responsibility to develop an outline for a proposed project that would meet this upcoming need for arranging and conducting a two-day training session.
List the product name and unit price of all of the products : Consider the General Hardware Corp. relational database and the data stored in it
Find the total production in the first year of operation : Use an appropriate definite integral to find the total production (to the nearest thousand barrels) in the first year of operation.
Create an e-r diagram relating table of your database schema : 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.
List the foreign keys in each of the six relations : How many foreign keys are there in each of the six relations?
Find total profit earned over the first 5 years of operation : use an appropriate definite integral to find the total profit (to the nearest million dollars) earned over the first 5 years of operation.
What is the candidate key of this relation : Each owner can own more than one vehicle. The other attributes are not unique. What is/are the candidate key(s) of this relation? If there is more than one candidate key, choose one as the primary key and indicate which is/are the alternate key(s)..
Identify the type of internet access that you use at home : Identify the type of Internet access that you use at home or in school. Discuss the pros and cons of the service available within your area. Justify your response.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Create table command, and modify it to create a new table

Start with this CREATE TABLE command, and modify it to create a new range_partitioned table named CH07EMPLOYEE_RANGE that contains the same column as the employee table.

  Create a simple query for each table that returns

Create a simple query for each table that returns all of the columns and all of the rows for each table. Write a query that displays each part that has been purchased by Huffman Trucking Company

  If you cannot capture some constraints explain why

Consider the university database from Exercise 2.3 and the ER dia-gram you designed. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints, explain why.

  Create a data model for on adult baseball league

Create a data model for on Adult Baseball league which supports all of the following data requirements. Create an example model of this relationship using the MySQL Workbench data modeler.

  Identify any pattern to these unusual orders

Get all employees that satisfy the following conditions

  Create an entity relationship diagram

Create an entity relationship diagram by today for an automated web-based timesheet portal system - An Entity-Relationship Diagram of an automated payroll system for a company.

  Create the appropriate relationships between each entity

Modify the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors). Create the appropriate relationships between each entity within the diagram.

  Describe the data structure that will store all data element

Provide an Entity Relationship Model (ERM) that will describe the data structure that will store all data elements. Note: The graphically depicted solution is not included in the required page length.

  Design the database using the er approach

Design the database using the ER approach and then create the tables accordingly. Populate the tables

  Data modelling in organizational intelligence

Data Modelling (database) require 8 page essay covering the following subjects: Organizational Intelligence. It must specifically talk about organizational intellignece being outcome of organization's efforts.

  Binary 1-n relationship-optional-to-optional relationship

Give examples of binary 1:N relationships, for (a) an optional-to-optional relationship, (b) an optional-to-mandatory relationship,

  Write a paper using word discussing sql injection

Write a 500-1000 word paper using Word discussing SQL Injection. Be sure to include ways to prevent this type of attack. Use at least two sources outside your text and course material for this paper.

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