Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need Help with EER Diagram and Tables Expand / Collapse
Author
Message
Posted Sunday, November 29, 2009 10:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, November 29, 2009 10:24 PM
Points: 1, 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
Post #826002
Posted Wednesday, December 16, 2009 8:51 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 20,696, Visits: 32,330
First, save MIS some money, use Microsoft SQL Server instead of Oracle!

We are a Microsoft SQL Server forum, after all.




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)
Post #835171
Posted Wednesday, December 16, 2009 8:58 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:58 PM
Points: 31,075, Visits: 15,519
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
Post #835185
Posted Wednesday, December 16, 2009 7:03 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 10:33 PM
Points: 35,259, Visits: 31,740
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #835517
Posted Thursday, April 28, 2011 9:07 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 10:57 PM
Points: 4,237, Visits: 4,290
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/

Post #1100317
Posted Friday, December 30, 2011 8:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 30, 2011 11:18 PM
Points: 3, 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?
Post #1228401
Posted Friday, December 30, 2011 8:40 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 6:53 PM
Points: 1,932, Visits: 1,589
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).


Dev

Devendra Shirbad | BIG Data Architect / DBA | Ex-Microsoft CSS (SQL 3T)
*** Open Network for Database Professionals ***

LinkedIn: http://www.linkedin.com/in/devendrashirbad
Post #1228420
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse