Create an enhanced erd to meet these requirements

Assignment Help Other Subject
Reference no: EM132050320

After you have analyzed the existing material used by the 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.

Add the enhanced ERD and the discussion about the relationship multiplicity to your project template to the section titled "Database System Development Life Cycle."

Reference no: EM132050320

Questions Cloud

What is the amount of net income on the income statement : A company's financial records at the end of the year including the following amounts: What is the amount of net income on the income statement
Experiencing decline in business because of competition : A company is experiencing decline in business because of competition. The manager thinks they may be able to turn the company around
Different employment tests that are available : What are some of the strengths and weaknesses of the different employment tests that are available, give details for three different employment tests.
What is explicit knowledge and tacit or implicit knowledge : What is explicit knowledge and tacit or implicit knowledge?
Create an enhanced erd to meet these requirements : Create an enhanced ERD to meet these requirements. Ensure that entities are properly defined and appropriate attributes are listed for each entity.
What is the purpose of a surveillance system : What is the purpose of a surveillance system? Provide two examples of surveillance systems (from your residential state)
Compute the cost of the units transferred : Compute the cost of the units transferred to the next department during the period and the cost of ending work in process inventory
Walmart is planning to introduce self-scanning robots : Walmart is planning to introduce self-scanning robots. How does this support CRM initiatives? What are the challenges of using this technology?
Sense of progress for employees working : How can managers provide a sense of progress for employees working on long-range projects that might not show results for months or even years?

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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