Create an enhanced erd to meet requirements

Assignment Help Database Management System
Reference no: EM13828426

Part 1

An analysis of the existing material used by a company for their day-to-day duties, the current Access database, and the additional requirements that the current system does not meet, the following requirements entity/attributes have been compiled:

  • Customer information is tracked using 'standard' attributes.
  • A customer may purchase products or services; if they purchase products or services, the following is tracked:
    • Product purchased
    • Date of purchase
    • Total of purchase
  • A supplier may sell products or services; if they sold products or services, the following is tracked:
    • Product sold
    • Date of sale
    • Total of sale
    • Is item purchased available for resale
  • Your company wants to keep the number of tables storing address information to a bare minimum (read this as 1).
  • Customers can be both a "supplier" and "someone that purchased services," and it is not required that they be either.
  • Employee information is tracked using standard attributes.
  • An employee will either be considered customer interfacing or internal support.
  • If the employee is customer facing, the following information is tracked:
    • Customer for interaction (note that a customer will only interface with a single employee)
    • Product specialty
    • Hours of training
    • Commission rate
  • If the employee is internal support, then the following is tracked:
    • Salary
    • Support area
  • An employee can be either customer facing or internal support, but not both.
  • Your company wants to keep the number of tables storing generic employee information to a bare minimum (read this as 1).
  • Finally, the company wants to track products or services offered. This should be a single table with typical attributes that describe inventory.
  • Every customer that either makes a purchase or sells goods to the company must be associated with an employee.
  • Every transaction that a customer makes with the company is stored/tracked, A customer may buy or sell many products, and a product is sold to more than one customer.

Create an enhanced ERD to meet these requirements. Ensure that entities are properly defined and appropriate attributes are listed for each entity. Also, ensure that all entities are properly related.

Add your ERD as a screenshot to a Word document, and provide supporting discussion about the need for the enhanced diagram tools and the reasoning behind the multiplicity for the relationships.

Part 2

Write 400-600 words that respond to the following questions with your thoughts, ideas, and comments. Now that the ERD is created, and as you are working on the logical model, you need to choose an RDBMS for the final solution. Using the method for DBMS selection, analyze 3 different DBMS products available and make a determination about which product you will recommend to management for selection. (One of the databases to analyze must be MySQL).

Using the vendors' Web sites, determine a rating for the following features, and calculate a final score for each:

Vendor

 

Product Version

                     

Desired Feature

Comments

Rating

Weight

Score

Vendor Stability

 

 

0.10

 

Operating System Choice and Requirements

 

 

0.05

 

Ease of Use/Training Requirements

 

 

0.20

 

Ease of Data Model Creation

 

 

0.15

 

Distributed Database Support

 

 

0.10

 

Administration Ease

 

 

0.20

 

Cost

 

 

0.20

 

Total

 

Based on your analysis, which database product will you recommend, and why?

As you are designing and developing the database, you think to the future and want to be able to grow the database as required, not only expanding the data model as needed, but also in the event that the company wants to open remote data centers and have replicated copies of the data. Describe distributed databases and how they might be used.

A summary of this section output to be developed is described below:

  • A completed template for 3 different database products (1 of them being MySQL)
    • Comments must be supplied
  • A recommendation for a DBMS, including a justification
  • A description of distributed databases

Part 3

Analyze the table below and reorganize the table into Boyce-Codd Normal Form, at each step describing what is needed to move to the next Normal Form and why each step meets the Normal Form requirements.

  • Show unnormalized table given and progression through the normal forms up to Boyce Codd in logical data models.
  • Include explanation of how each normal form is met as you progress through the process of breaking down this unnormalized table to tables meeting Boyce Codd normal form.

Charity
ID

Charity Name

Charity
Location

POC Name

POC ID

Tel Extn.

Customer ID

Customer Name

Date

Contribution Started

No of Month

Date Places

Expected ContributionEnd

In addition, transform your data model (your ERD created previous) into a logical model, to third normal form. Describe why each table is in third Normal Form. In your logical data model identify the primary keys in each table as bolded and underlined and each foreign key as italicized and underlined.

A summary of this section output to be developed is described below:

  • Logical Data Model for the supplied table with a description of how it moved through UNF to 1NF to 2NF to 3NF and Boyce Codd.
  • Logical Data Model for Part 2 with a description of how each table is in third normal form.

Reference no: EM13828426

Questions Cloud

Corporate strategy main expansion options an analysis : Corporate Strategy Main Expansion Options An Analysis
Long term financial management decisions : Superior Manufacturing is thinking of launching a new product.  The company expects to sell $950,000 of the new product in the first year and $1,500,000 each year thereafter.
Case study pension fund : AONE pension fund has assets of £20m. Contributions from Lower Valley Estates and the Members of the fund are currently running at approximately £1m pa received at the end of the year whilst dividend and interest income from investments in the cur..
Entering into trade with another country : Entering Into Trade With Another Country
Create an enhanced erd to meet requirements : Create an enhanced ERD to meet requirements. Ensure that entities are properly defined and appropriate attributes are listed for each entity. Also, ensure that all entities are properly related.
Which technology is used to locate specific trailer : Which legal system relies upon principles or rules of law that were developed from court decisions? Which technology is used to locate specific trailer and even pallets
Explain the prospective of starting a new business in qatar : Explain the Prospective of Starting a New Business in Qatar
Discuss some business and consumer ethics of corporate : Discuss some business and consumer ethics of corporate organizations
Identify which customers have stopped purchasing products : CRM can allow organizations to identify which customers have stopped purchasing products or services from the organization so that the organization can target those former customers for future promotions and/or perhaps to investigate why they stop..

Reviews

Write a Review

 

Database Management System Questions & Answers

  Practice on topic of normalization

Practice on topic of Normalization

  Research paper on the turing and von neumann models

Write a two page research paper on the Turing and von Neumann models.

  Explain the idea for database and partitioned view

Explain the idea for the database along with the thoughts for partitioned view. How would you utilize this partitioned view?

  Explain what do business rules require to be effective

What are the advantages of having the DBMS between the end user's applications and the database. What are some reasons for studying file systems. IT 645 - Database Management Systems

  Improve decision making for management

Prepare a brief of at least 1,400 words for Kudler Fine Foods management in which you address

  Data manipulation in excel

Data Manipulation in EXCEL-How to enter in data manually to an EXCEL spreadsheet and then create formulas to perform calculations on that data. In this lesson, you will learn how to import data to EXCEL from an external source,use tools built-in t..

  Explain techniques for distributed data placement

Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the diagrams supporting your conclusion. Note: The graphically depicted solution is not included in the required page length.

  Provide an entity relationship model

Provide an Entity Relationship Model (ERM) that will describe the data structure that will store all data elements and analyze the university's requirements and provide a proposal to organize all the required data elements.

  Dimensions and attributes in a star schema model

Explain the use of facts, dimensions and attributes in a star schema model. Explain the use of facts, dimensions and attributes in a star schema model.

  Explain how you arrived at your final solution

Explain how you arrived at your final solution for the four conceptual and process view diagrams that you have created and describe how you created the conceptual and process view for all four (4) diagrams. In the description, be sure to provide a j..

  When you create a query in access than you are essentially

When you create a query in access, you are essentially

  How much wages and salaries cost would be allocated

What would be the total overhead cost per customer according to the activity based costing system? In other words, what would be the overall activity rate for the customer support activity cost pool?

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