+1 646 741 3517 instanthelp123@gmail.com

(solved) Law Associates

$45.00

Referencing Styles : Harvard Law Associates is a large legal practice based in Melbourne. The practice employs nearly forty lawyers who work in a wide variety of specialty areas. A speciality id and description is stored for each speciality. Each lawyer employed by the practice is classified as a partner, an associate or an intern. The practice stores the following information for all lawyers: Name, address, telephone, email, base salary and one area of speciality. For partners, the practice also stores information about th … View More Law Associates is a large legal practice based in Melbourne. The practice employs nearly forty lawyers who work in a wide variety of specialty areas. A speciality id and description is stored for each speciality. Each lawyer employed by the practice is classified as a partner, an associate or an intern. The practice stores the following information for all lawyers: Name, address, telephone, email, base salary and one area of speciality. For partners, the practice also stores information about the percentage of the partnership held by the lawyer and the area of speciality that lawyer leads. Each area of speciality has one partner who acts as a leader (or expert) in that area. For associates, the practice also stores details about the percentage of cases the associate has won. Partners and Associates engage in legal proceedings. The following details about each legal proceeding are stored: identifier, procedure details and the status of the legal proceeding. Each partner or associate may be engaged in a number of legal proceedings and each legal proceeding may have up to five lawyers (partners or associates or both). We also store the percentage of workload of each lawyer in each legal proceeding. Interns undertake prescribed training courses and a record is kept. All training courses are registered and the name of the course, the duration (in days), the start date, the end date and details about the training organisation. Although a course is only offered by one training organisation, these organisations typically offer many courses. We store the name, address, email and Law Society accreditation number for all training organisations. When a lawyer completes a course, the grade received on that course is recorded. Finally, we store details about the qualifications of all lawyers. Each lawyer may have many qualifications and a list of qualifications is stored, including the name of the qualification, its level (undergraduate or postgraduate) and the name of the university offering the qualification. a) An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein methodology as per the study book and tutorials. (15 Marks) b) A list of relations (equivalent to Finkelstein entity list). Produce complete relations for all entities and attributes. Show all primary and foreign keys. Include all attributes that are specifically mentioned and all key attributes. You may need to create primary and foreign keys that are not specifically mentioned. You must use the Finkelstein methodology as per the study book and tutorials. (15 Marks) c) A single SQL statement or multiple statements that create/s the table for the relation training courses for jurors and interns. All key and attribute constraints should be included and data types suitable to each attribute should be chosen. (10 Marks) Produce a set of relations (equivalent to the Finkelstein entity list) in third normal form (3NF) from the following un-normalised relation. Show your working and entitles for 1NF, 2NF and 3NF. You must use the Finkelstein methodology as used in the study book and tutorials. 1. Five marks awarded for each correct SQL statement. 2. Alternative approaches to the model answer could be accepted unless they do not follow the rules / requirements set out in the specification, are poorly optimised or are poorly construct

Reviews

There are no reviews yet.

Be the first to review “(solved) Law Associates”

Your email address will not be published. Required fields are marked *