Database System Development Life Cycle

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

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
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