Create and label the relationships between the entities

Assignment Help Basic Computer Science
Reference no: EM131254021

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.

Reference no: EM131254021

Webflix maintains customer data in a 2d-array

WebFlix maintains customer data in a 2D-array called WF. Where the rows correspond to the customers and the columns correspond to films that it rents. An entry WF[i,j] indicat

Design an iterative and a recursive function

Design an iterative and a recursive function called replicate_iter and replicate_recur respectively which will receive two arguments: times which is the number of times to r

Write a program to scan

Write a program to scan 2 integer numbers from user, then check for below conditions: a). If both the numbers are equal, print a message "Both numbers are equal". b). If first

Performance over time

It's important to monitor your servers'' performance over time. But, what are the most important aspects to monitor and how often? As a network administrator, how do you bes

How to allow mobile access to organizational system

How to allow mobile access to organizational system users (employees, contractors, and business partners), Use of cloud resources such as processing and data storage outside t

A precision engineering company consumes

A precision engineering company consumes 50,000 units of a component per year. The ordering, receiving and handling costs are Rs.3/- per order, while the trucking cost are Rs.

Based on the example for program execution

Based on the example for program execution presented in Workshop 1 Presentation 4, write a program to add the numbers 3 and 5. Your program should store number 3 in memory-a

How silicon-based semiconductors revolutionized computing

New materials frequently lead to new technologies that change society. Describe how silicon-based semiconductors revolutionized computing.

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd