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
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? Recovery testing is a system test that forces the software to fail in a various of ways and verifies that recovery is properly done.

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

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 This model is useful when less manpower is available for software development and release deadlines are tight. It's best suited for in

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


Draw the Context level DFD for the Safe home Software. User commands Alarm type Telephone Number tone Sensor status Display Information

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

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