SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Need Help with EER Diagram and Tables


Need Help with EER Diagram and Tables

Author
Message
princess_tahseen
princess_tahseen
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 0
Hi I am taking MIS class and i need help with the EER diagram and i tried making it myself but teacher told me that it is a process diagram not an ER diagram please help me here is what i have tried: please
click on this link http://yfrog.com/j2mytryj


and here is what another try here is the link http://yfrog.com/2s2ndxj

please let me know which one is correct i am having trouble defining the entities...and i also need to create table with attributes and normalize it...please help!

Here is the scenario:
MIS Corporation owns and operates nine large hardware stores and one centralized warehouse in major metropolitan areas of the west United States. The stores carry a wide variety of hardware merchandise for sale to the individual and business. The stock is stored in bins and is located by an inventory number in the warehouse.

Whenever a retail store needs merchandise, a four-part merchandise request form is completed. One copy is kept by the store, and three copies are mailed to the warehouse the next day. If the merchandise requested is on hand, the goods are delivered to the store, accompanied by the third copy of the request. The second copy is filed at the warehouse. The fourth copy is forward to accounts receivable for cost and revenue calculation.

If the quantity of goods on hand is not sufficient to fill the order, the warehouse sends the quantity available and notes the quantity shipped on the request form. A purchase memorandum for the shortage is then prepared by the warehouse. At the end of each day, all the memos are sent to the purchasing department.

When ordered goods are received, they are checked at the receiving area of the warehouse, and a receiving report is prepared. One copy of the receiving report is retained at the receiving area, one is forwarded to accounts payable, and one is filed at the warehouse with the purchase memorandum.

When the purchase memoranda are received from the warehouse, purchase orders are prepared. Vendor catalogs are used to select the best source for the requested goods, and the purchase order is prepared and mailed. Copies of the order are sent to account payable and the receiving area. One copy is retained in the purchasing department.

When receiving report arrives in the purchasing department, it is compared with the purchase order on file. It is also checked with the invoice before the invoice is forwarded to accounts payable for payment.

Each week a report of the open purchase orders is prepared to determine if any action should be taken on overdue deliveries. This report is prepared manually after scanning the file of outstanding purchase orders.

The company has been successful in this field. Each retail store acquires its merchandise from the company's centrally located warehouse. Consequently, the warehouse must maintain an up-to-date and well-stocked inventory ready to meet the demand of the individual stores.

The company wishes to hold its competitive position with similar stores of other companies in its market area. Therefore, MIS Company must improve its purchasing, inventory, and selling procedures. The number of company's store, the number of inventory items carried, and the volume of business has been providing pressures to change from basically manual data processing routines to a computerized processing system.

After several discussions with the company's executive board, Nancy Tsai, the chief executive office of MIS Company, has decided to install several minicomputers in stores and warehouse in the late 1990s. Most of the applications that have been installed on the computer are in the accounting and financial areas. Most of these application programs are purchased from a software vendor company that has modified the programs to meet the requirements of the MIS Company.

The computer applications at MIS Company have generally been successful. The software has enabled the company to reduce its paper work burden and improve its response to individual stores. In addition management is able to obtain better information concerning costs, sales, and profit.

Nevertheless, managers at MIS Company are dissatisfied with several aspects of the computer systems. While the applications have helped improved the operations management function, there has been little impact on middle management and still less on top management. Nancy Tsai and the other managers at MIS Company have come to realize that there are basic limitations to traditional file processing systems. Some of these limitations are (1) uncontrolled redundancy, (2) inconsistent data, (3) inflexibility, (4) limited data sharing, (5) poor enforcement of standards, and (6) excessive program maintenance.

Now the competition in hardware retailing has intensified. Competitors such as Home Base and Home Depot seem to response more rapidly than MIS Company to new business opportunities. Therefore, after analyzing the current individual file processing systems, the company's data processing consulting firm – the Oaks Associates has suggested replacing the existing systems with an integrated database management systems using Oracle.

The recommendation of the Oaks Associates stated that the new database management systems should have the following characteristics: (1) minimal data redundancy, (2) consistency of data, (3) integration of data, (4) sharing of data, (5) ease of application development, (6) uniform, security, privacy, and integrity controls, (7) data accessibility and responsiveness, (8) data independence, and (9) reduced program maintenance.

Nancy Tsai has accepted the excellent advice given by the Oaks Associates. She is intended to purchase Oracle as the MIS Company's database management systems. She has just hired your team for the data processing department. Your responsibility is to design a database oriented merchandise distribution systems to collect the information about inventory levels for the warehouse and individual stores, vendor, accounts payable, and accounts receivable. Nancy Tsai expects that your database design is flexible to handle both large volume transactional processing reports for the operation management and ad hoc reports for the top management.

===========
Please see the http://yfrog.com/06captureobp‏ document this is my new updated version please let me know if i have any mistakes as far as the tables and attributes and also the normalization
here is the tables
MIS Corporation
Attributes
CompanyID
Description

Hardware Stores
Attributes
StoreNo
StoreAdd
StorePhone
CustNo

Warehouse
Attributes
WarehouseNo
WarehouseAdd
WarehousePhone

Customers
Attributes
CustNo
CustLname
CustFname
CustAdd
CustPhone

Transactions
Attributes
TransNO
TransDate
ProductNO



Product
Attributes
ProductNo
ProductDescription
SerialNumber
Model Number

Purchase Order Item
Attributes
POINo
ProductNo
POIDescription
POIQuantaty
POIPrice
PurchaseNo

Purchase
Attributes
PurchaseNo
PurchaseDate
VendorNo
InvoiceNo
StaffNo
POINo

Vendor
Attributes
VendorNo
VendorAdd
VendorPhone
VendorType


Invoice
Attributes
InvoiceNo
InvoiceDate
InvoiceAmount
VendorNo
PurchaseNo

Payment
Attributes
PaymentNo
PaymentDate
PaymentAmount
VendorNo
PurchaseNo
InvoiceNo
StaffNo

Staff
Attributes
StafftNo
SLname
SFname
StoreNo
Hiredate
Saddress


Order
Attributes
OrderNo
OrderDate
CustomerNo
Cust_paymentNo
OLIno



Order Line Item
Attributes
OLineNo
ProductNo
OLineDescription
OLineQuantaty
OLinePrice
OrderNo

Cust_Payment
Attributes
Cust_PaymentNo
Cust_PaymentDate
Cust_PaymentAmount
StoreNo
OrderNo
StaffNo
Lynn Pettis
Lynn Pettis
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39844 Visits: 38563
First, save MIS some money, use Microsoft SQL Server instead of Oracle!

We are a Microsoft SQL Server forum, after all. ;-)

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63468 Visits: 19115
An ER diagram is typically built to show the relationships in the tables. If you have those tables, those are what would appear in the ER diagram and be related to each other.

This might help you: http://www1bpt.bridgeport.edu/~jelee/courses/CS450_F09/CPSC450-ExerciseLab1-Supporting-EER.pdf, but really you need to go back and study what an ER diagram is and then how that relates to a real business model.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87260 Visits: 41113
I suspect the real problem is simply definition... just like people call most tissue you can blow your nose in "Kleenex" even when made by a different company, so goes things like ERD's and the like. There are about 20 different types of ERD's and, yes, some of them look like process flow charts and others look like table relationship diagrams. Both can qualify as an ERD because a person, place, or thing can be an "entity" and so can tables.

I suspect the type of ERD your instructor is looking for doesn't have much to do with "data modeling"... rather it's likely more like a table relationship diagram being sought after.

Here's an example of that...
http://rapidapplicationdevelopment.blogspot.com/2007/06/entity-relationship-diagram-example.html

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Welsh Corgi
Welsh Corgi
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10248 Visits: 4894
Original Post was removed.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
kavyap.kp
kavyap.kp
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 4
i am working on e learning and certification i have this prob on maintaining the details of students who have registered for the various courses,courses they have completed,and if they are pursuing, i need 3 columns for every course for every student is there a solution for it?
Dev
Dev
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3510 Visits: 1602
kavyap.kp (12/30/2011)
i am working on e learning and certification i have this prob on maintaining the details of students who have registered for the various courses,courses they have completed,and if they are pursuing, i need 3 columns for every course for every student is there a solution for it?


Please start another thread for your problem Else reader will be confused with original case (MIS).
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search