Reference no: EM132135314
Question: 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:
1. Customer information is tracked using ‘standard' attributes.
2. 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
3. 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
4. Your company wants to keep the number of tables storing address information to a bare minimum (read this as 1).
5. Customers can be both a "supplier" and "someone that purchased services," and it is not required that they be either.
6. Employee information is tracked using standard attributes.
7. An employee will either be considered customer interfacing or internal support.
8. 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
9. If the employee is internal support, then the following is tracked:
• Salary
• Support area
10. An employee can be either customer facing or internal support, but not both.
11. Your company wants to keep the number of tables storing generic employee information to a bare minimum (read this as 1).
12. Finally, the company wants to track products or services offered. This should be a single table with typical attributes that describe inventory.
13. Every customer that either makes a purchase or sells goods to the company must be associated with an employee.
14. 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."
APA References at least 2 with intext citations
Briefly describe the general preventative measures
: ENMIN 5120 Tunnelling & Mine Development - federation University - List the most important parameters used to describe dusts and the extent to which they
|
How the teacher deals with and handles behavior issues
: How expectations, routines, and procedures are introduced and reinforced in the classroom. How the teacher deals with and handles behavior issues in the class
|
Explain each risk impact on the organization
: Give a description of the risk each vulnerability or threat would have on the organization in terms of its people, network, data, or reputation.
|
Describe one or two experiences with mass media
: The market for higher education is determining the key questions of what gets produced, how it is produced, how much is produced, and who gets how much.
|
Create an enhanced erd to meet the requirements
: Create an enhanced ERD to meet these requirements. Ensure that entities are properly defined and appropriate attributes are listed for each entity.
|
Design and marketing section of the printer division
: Digistar, Inc., is a large corporation that produces a wide variety of products and services. As a result, it is a tall organization with a product structure.
|
Owner and manager of a small business
: Assume that you are the owner and manager of a small business. Having a strategy for your business. Be sure to include each of the three primary strategic
|
Write a critical evaluation of the article
: Using the University Digital Library or the Google scholar website, locate a peer reviewed article about privacy. Write a critical evaluation of the article.
|
Manager for an international chain of fitness centers
: Miriam is a senior manager for an international chain of fitness centers. Two suppliers provide exercise machines for her company.
|