If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > need help for ERD

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-13-10, 17:12
cv007 cv007 is offline
Registered User
 
Join Date: Nov 2010
Posts: 3
Red face need help for ERD

Packford’s Storage Company

Packford’s are a storage company that store standard size crates for clients up and down the UK. Clients can request the collection of crates for storage, and also can request the return of crates to any one of a number of delivery addresses. Delivery and collection times are usually on a next day basis. Clients are charged monthly according to the number of deliveries and returns.
Only certain staff have the authority to make orders for crates. Some clients have many branches, and crates are ordered by branch, but billed centrally. Some crates are left for so long that they may not ever be needed. They may be destroyed if the client wishes, but Packford’s want to bear no risk of destroying needed crates.
Management staff are authorised to view all crates and their history with the storage company. They may also obtain statistics on customer usage. Accounts staff may obtain information on customer usage for customer billing. Sales staff are allowed to enter new business.
You are required to model the current business system and propose a new, integrated software system that will include all current functionality and enhancements needed.
Reply With Quote
  #2 (permalink)  
Old 11-13-10, 17:15
cv007 cv007 is offline
Registered User
 
Join Date: Nov 2010
Posts: 3
[QUOTE=cv007;6485276]Packford’s Storage Company

Packford’s are a storage company that store standard size crates for clients up and down the UK. Clients can request the collection of crates for storage, and also can request the return of crates to any one of a number of delivery addresses. Delivery and collection times are usually on a next day basis. Clients are charged monthly according to the number of deliveries and returns.
Only certain staff have the authority to make orders for crates. Some clients have many branches, and crates are ordered by branch, but billed centrally. Some crates are left for so long that they may not ever be needed. They may be destroyed if the client wishes, but Packford’s want to bear no risk of destroying needed crates.
Management staff are authorised to view all crates and their history with the storage company. They may also obtain statistics on customer usage. Accounts staff may obtain information on customer usage for custom billing. Sales staff are allowed to enter new business.
You are required to model the current business system and propose a new, integrated software system that will include all current functionality and enhancements needed

I can not find how much entities will come in this diagram please help me
Reply With Quote
  #3 (permalink)  
Old 11-13-10, 22:45
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
67,804 entities will be in the final ERD diagram, after 406 iterations.

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote
  #4 (permalink)  
Old 11-14-10, 12:36
cv007 cv007 is offline
Registered User
 
Join Date: Nov 2010
Posts: 3
yes but i want what are the entities will come


i find

client
branch
employye
employye privilage
privilage type
order
orderline
crates
status



is that any more
Reply With Quote
  #5 (permalink)  
Old 11-14-10, 14:29
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
Yes.

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On