Results 1 to 5 of 5
  1. #1
    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.

  2. #2
    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

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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.

  4. #4
    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

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Yes.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •