1. Draw a context diagram for the system described in the scenario below.
2. Decompose the data flow diagram until it doesn’t make sense to continue.
3. 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” (i.e, include 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.
4. Create a set of metadata definitions/entries for your data model components
This is the scenario!!!!! Please read this careful.
You own a company that supplies rental graduation attire (i.e., cap, 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 and 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.
