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

Software development plan , Phone Company (WLPC) is a provider of wireless ... Phone Company (WLPC) is a provider of wireless phone service in the US with 100,000 customers serving mostly small markets. WLPC has just purchased additional airwaves in the US, C

What is recovery testing, What is recovery testing? Recovery testing is... What is recovery testing? Recovery testing is a system test that forces the software to fail in a various of ways and verifies that recovery is properly done.

Assumptions of the execution-time component model, What are the assumptions... What are the assumptions of the execution-time component model? The execution-time component is based on the several assumptions: (1) Tests show the environment in which the

Explain scm, What is SCM? Software Configuration Management is a set of... What is SCM? Software Configuration Management is a set of activities carried out for identifying, organizing and controlling alters throughout the lifecycle of computer softwa

What is the advantages of iterative model, What is the advantages of Iterat... What is the advantages of Iterative model This model is useful when less manpower is available for software development and release deadlines are tight. It's best suited for in

SRS, i want to make a case study of any topic of SRS but i am little confus... i want to make a case study of any topic of SRS but i am little confuse about SRS plz give me Idea how to work in SRS and how to select a model

Why testing is vital with respect to software, Why testing is vital with ... Why testing is vital with respect to software?

Draw the context level dfd for the safe home software, Draw the Context lev... Draw the Context level DFD for the Safe home Software. User commands Alarm type Telephone Number tone Sensor status Display Information

Advantage of using prototype software development model, What is the advant... What is the advantage of using prototype software development model instead of waterfall model? The waterfall model: This is the classic SDLC model, with a sequential and line

How abstraction used in stepwise refinement, Q. How Abstraction used in ste... Q. How Abstraction used in stepwise refinement? Abstraction:- Abstraction permits one to concentrate on a problem at some level of generalization without regard to irrelevant l