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.

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.

NOTE: We use PART MARKING for the relations and will mark four relations chosen at random.

c) A single SQL statement or multiple statements that create/s the table for the relation LAWYER. All key constraints should be included and data types suitable to each attribute should be chosen.

 

Posted Date: 3/2/2013 2:11:03 AM | Location : United States

Ask an Expert

Related Discussions:- Prepare er diagram for the system, Assignment Help, Ask Question on Prepare er diagram for the system, Get Answer, Expert's Help, Prepare er diagram for the system Discussions

Write discussion on Prepare er diagram for the system
Your posts are moderated

Write your message here..

Related Questions

Explain equivalent size measure software metrics, Q. Explain Equivalent siz... Q. Explain Equivalent size measure software metrics? Equivalent size measure:- Models makes no distinction between a new software and the portion being reused. The equivalent

What is customer (end user), What is Customer (end user)? Ans) The organ... What is Customer (end user)? Ans) The organization or individual, internal or external to the producing organization that takes the product.

What is requirements definition description, What is Requirements Definitio... What is Requirements Definition Description Output of requirements of engineering process is Requirements Definition Description (RDD). Requirements engineering can be defined

List the guidelines for data design, List the guidelines for data design. ... List the guidelines for data design. i. Apply systematic analysis on data. ii. Determine data structures and related operations. iii. Establish data dictionary. iv. Us

Differentiate between object oriented and function oriented, Differentiate ... Differentiate between object oriented and function oriented design .  Function-oriented design relies on recognizing functions which transform their inputs to make outputs. I

Software Testing Methodologies, Write a program and identify DU path for Te... Write a program and identify DU path for Telecom domain

Define coupling and discuss various types of coupling, Define coupling and ... Define coupling and Discuss various types of coupling? Define coupling. Discuss various types of coupling. Ans: A Coupling is the measure of the degree of interdepende

What are the types of requirements, What are the Types of Requirements ... What are the Types of Requirements There are numerous categories of the requirements. On the basis of their priority, requirements are classified into below 3 types: 1.

What are the characteristics of software measurement, What are the characte... What are the characteristics of software measurement? Measured property Object of measurement Source of measure Purpose measurement Context of measurement.

Name certain common tools which are used for load testing, Name certain com... Name certain common tools which are used for load testing. - Rational Performance Tester by IBM Rational - Open STA an Open Source tool - LoadRunner by HP - Silk Perfo