Recent Question/Assignment
1. Indicate the changes you need to make to the design of the Premiere Products database to support the following situation. A customer is not
necessarily represented by a single sales rep but can be represented by several sales reps. When a customer places an order, the sales rep who
gets the commission on the order must be one of the collection of sales reps who represents the customer.
2. Indicate the changes you need to make to the design of the Premiere Products database to support the following situation. There is no
relationship between customers and sales reps. When a customer places an order, it may be through any sales rep. On the order, identify both
the customer placing the order and the sales rep responsible for the order.
3. Indicate the changes you need to make to the design of the Premiere Products database in the event User View 3 requirements are changed as
follows; For a part, store the part's number, description, item class, and price. In addition, for each warehouse in which the part is located, store
the number of the warehouse, description of the warehouse, and number of units of the part stored in the warehouse.
4. Indicate the changes you need to make to the Premiere Products database design to support the following situation. The region where
customers are located is divided into territories. For each territory, store the territory number (a unique identifier) and territory name. Each sales
rep is assigned to a single territory. Each customer is also assigned to a single territory, but the territory must be the same as the territory to
which the customer's sales rep is assigned.
5. Indicate the changes you need to make to the Premiere Products database design to support the following situation. The region where
customers are located is divided into territories. For each territory, store the territory number (a unique identifier) and territory name. Each sales
rep is assigned to a single territory. Each customer is also assigned to a single territory, which may not be the same as the territory to which the
customer's sales rep is assigned.
necessarily represented by a single sales rep but can be represented by several sales reps. When a customer places an order, the sales rep who
gets the commission on the order must be one of the collection of sales reps who represents the customer.
2. Indicate the changes you need to make to the design of the Premiere Products database to support the following situation. There is no
relationship between customers and sales reps. When a customer places an order, it may be through any sales rep. On the order, identify both
the customer placing the order and the sales rep responsible for the order.
3. Indicate the changes you need to make to the design of the Premiere Products database in the event User View 3 requirements are changed as
follows; For a part, store the part's number, description, item class, and price. In addition, for each warehouse in which the part is located, store
the number of the warehouse, description of the warehouse, and number of units of the part stored in the warehouse.
4. Indicate the changes you need to make to the Premiere Products database design to support the following situation. The region where
customers are located is divided into territories. For each territory, store the territory number (a unique identifier) and territory name. Each sales
rep is assigned to a single territory. Each customer is also assigned to a single territory, but the territory must be the same as the territory to
which the customer's sales rep is assigned.
5. Indicate the changes you need to make to the Premiere Products database design to support the following situation. The region where
customers are located is divided into territories. For each territory, store the territory number (a unique identifier) and territory name. Each sales
rep is assigned to a single territory. Each customer is also assigned to a single territory, which may not be the same as the territory to which the
customer's sales rep is assigned.
Looking for answers ?
Recent Questions
Attached is my resume and cover letter as it's required in the assignment2000 wordsWord limit: 1500 - 2000Objectives:The purpose of this assignment is to:1. Familiarise yourself with best practice in engineering sustainability in a particular field by conducting a thorough literature...Module code: BMA4005-20Module title: Professional PracticeAssignment: A1. Digital PosterWord count: 500Contribution to module mark: 40% of overall gradeAssessment type: IndividualWeight 40%Submission deadline:...Assessment Criteria for Written Report (20%)• Submission of a minimum 1500 to maximum 1800-words written report due from week 9. You will submit your written report one week after you have undertaken the...Assessment 2: (20%) Case Study Presentation Due Date weeks 10This assessment builds on your theoretical knowledge and tests your ability to apply this knowledge to practice.you are required to formulate...Assessment 2Assessment 2Report: 30%Word count: 1400 – 1600 wordsDue date: Sunday of Week 8DescriptionYou are playing the role of a community service worker supporting a young adult son who is 18 years...1500-1800 wordsShow All Questions