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

Requirements specification, effects of nativity in requirements specificati... effects of nativity in requirements specification

Write down any four application of a stack, Write down any four application... Write down any four application of a stack. (i)  Conversion of infix to postfix form (ii)  Reversing of a line. (iii) Removal of recursion (iv) Evaluating post fix expression

Design a digital system to produce a pwm , Task You have to design a d... Task You have to design a digital system to produce a PWM signal that produces pulses at a frequency in the range 50 Hz -100 Hz . The pulses will be between 1 ms and 2 ms du

Develop a software architecture, Develop a software architecture for the Ca... Develop a software architecture for the Case Study.   a. Identify the major 'design forces' () affecting the system, and discuss the 'architectural response' you think most   ap

What are the common activities in design process, What are the common activ... What are the common activities in design process? i. System structuring - The system is subdivided into principle subsystems components and communications among these subsy

Differentiate between failures and faults, Differentiate between failures a... Differentiate between failures and faults.   Failure:- Failure is the departure of external results of program operation from requirements. So failure is dynamic. Failure can

What is stress testing, What is Stress testing - It checks the robustn... What is Stress testing - It checks the robustness of application. - It verifies that application consistently provides satisfactory performance under unfavourable and extre

Performing validation testing, What are the conditions exists after perform... What are the conditions exists after performing validation testing? After performing the validation testing there exists two conditions.  The function or performance charact

List the process maturity levels in seis cmm, List the process maturity lev... List the process maturity levels in SEIs CMM. Level 1: Initial - Few processes are explained and individual efforts are taken. Level 2: Repeatable - To track cost schedul

How is the state diagram helpful to an engineer, Problem: a) Assume a w... Problem: a) Assume a washing machine. List all possible states of the washing machine. Draw a state diagram showing also the events triggering the change of states where poss