Prepare er diagram for the system, Software Engineering

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







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
Related Questions

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

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 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? i. System structuring - The system is subdivided into principle subsystems components and communications among these subsy

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 - It checks the robustness of application. - It verifies that application consistently provides satisfactory performance under unfavourable and extre

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. Level 1: Initial - Few processes are explained and individual efforts are taken. Level 2: Repeatable - To track cost schedul

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