Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You own a company that supplies rental graduation attire (i.e., caps, gowns, tassels, etc.) for students and faculty at universities across the US. Your current

image text in transcribedimage text in transcribedimage text in transcribed
You own a company that supplies rental graduation attire (i.e., caps, gowns, tassels, etc.) for students and faculty at universities across the US. Your current ordering system is out-of-date, and you want to design and implement a new ordering and payment tracking system. You would like for your system to track sales rep commission, customer orders, payments, and customer account balances. in your company you have over 100 sales reps on staff to handle your customer orders; they earn a 5% commission on each customer order. When a customer places an order the orders are assigned to the first available sales rep. The sales rep works with the customer to ensure that the orders are correct. Customers sometimes place a second order for additional items; customers may also modify their orders. Each time a customer places an order they may or may not work with the same sales rep. Students may pay for their own orders, but sometimes a student's order is paid for by the university. Most of the time a university pays for faculty orders. However, sometimes a faculty member may want a special cap or gown at an additional cost. When a faculty member adds those extras to their order the faculty member is responsible for the increase in order amount. So, payments can be received directly from both your student and faculty customers as well as from a university. A. (20 points) Draw a data model for the scenario provided above. In your answer, you will need to identify the entities and include the appropriate attributes for each entity. Once you have identified the entities and attributes you will need to create and label the relationships between the entities. Your diagram will need to be \"normalized\" (Lg; including the cardinality, keys, and associate entities required to break up many-to-many relationships). Use appropriate crow's feet notation in your final, normalized, ERD. B. (5 points) Create a set of metadata definitions/entries for your data model components

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Operations Management Journal

Authors: Kris Safarova

1st Edition

9798734741054

More Books

Students also viewed these General Management questions

Question

2. What role should job descriptions play in training at Apex?

Answered: 1 week ago