Purchase Solution

ER Diagram Developed

Not what you're looking for?

Ask Custom Question

Develop an ER diagram for the following:

A database used in an order-entry system is to contain information about customers, items, and orders. The following information is to be included:

? For each customer:
Customer number (unique)
"Ship-to" addresses (several per customer)
Balance
Credit Limit
Discount

? For each order:
Heading information
Customer number
Ship-to address
Date of Order

? Detail lines (several per order):
Item Number
Quantity ordered

? For each item:
Item number (unique)
Manufacturing plants
Quantity on hand at each plant
Stock danger level for each plant
Item description

For internal processing reasons, a "quantity outstanding" value is associated with each detail line of each order; this value is initially set equal to the quantity of the item ordered and is progressively reduced to zero as partial shipments are made. Again, design a database for this data. State assumptions you make regarding dependencies.

Purchase this Solution

Solution Summary

The expert examines ER diagram development. Database for order-entry systems are examined.

Purchase this Solution


Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Basic Networking Questions

This quiz consists of some basic networking questions.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.