Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2014

    Entity Relationship Modelling (Urgent)

    Wright & Wong Legal Services (WWLS) is a law firm, taking cases from a variety of clients. You are requested to design a database system that will allow WWLS to manage their cases. You have been given the following information about the way the firm operates.

    - WWLS staff consists of lawyers and secretaries. Lawyers work on cases, while secretaries provide assistance to lawyers , while some secretaries assist only one lawyer, some of them assist multiple lawyers.
    - the database must maintain all contact details of lawyers and secretaries, the qualification and specialization (e.g. civil law, family law, criminal law...) of the lawyers, and their hourly rates , as well as common details such as name, gender, date of birth...
    -The details of each case must be recorded, including a summary, description, category(see specialization list above) and status ...
    -Each case is assigned to one or more lawyers , and each lawyer tends to be working more than one case at a time.
    -Client are the people who bring their case to WWLS. Clients may have multiple cases with the firm at one time, and multiple clients may be involved in a single case.
    -Client details need to be stored, including name, contact details, gender, marital status ...
    -Details of any evidence related to a case must also be stored. This includes a description, notes, and any photographs, scanned documents or digital files necessary.
    -If a client brings a case to WWLS but no lawyer is available to take it, a secretary may place it into a list of "pending cases" , secretaries are entirely responsible for maintaining this list.
    -A client may only have one pending case at a time, and only one client can be involved with a pending case (if/when the case is assigned to a lawyer, it becomes a normal case)


    Based on the above details, you are required to draw a logical E-R diagram for WWLS and then convert it to a physical E-R diagram. Clearly show all primary and foreign keys, necessary attributes, relationship and their types on the diagram (or accompanying entity description). Remember to state any assumptions you make.

    Please teach me how to design it @.@
    email me @

  2. #2
    Join Date
    Nov 2004
    out on a limb
    So what have you done so far
    What are you struggling with
    What do yoy think yoy need to refine
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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