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

What are the properties of the software, What are the properties of the sof... What are the properties of the software? Software is engineered, not manufactured. Software is free of wear out. Most software is built as required rather than being asse

Write sql code to make the changes, Assuming that all the tables have been ... Assuming that all the tables have been created as given in the relational schema, write SQL code to make the following changes in the structure of the tables: (i) Make the empl

What is the utilisation of cmm, What is the utilisation of CMM? Capabil... What is the utilisation of CMM? Capability Maturity Model is used in assessing how fine an organisation's processes permit to complete and manage latest software projects

Explain rad model, RAD Model Rapid Application Development Model is ... RAD Model Rapid Application Development Model is the method of incremental model. Achieves the high speed development using component based construction. Phases

Construct an e-r diagram, Construct an E-R Diagram for the application desc... Construct an E-R Diagram for the application described on the next page. Include any additional assumptions you made about the application requirements. The assumptions may not dir

Differentiate between function oriented design, Q. Differentiate between fu... Q. Differentiate between function oriented design and object oriented design. Ans. Function oriented design:- Function oriented design strategy relies on decayed the system i

Configuration management, Configuration Management: Because of several ... Configuration Management: Because of several reasons, software changes during its life cycle. As a result of the changes made, many versions of the software exist at one time.

State the level 3 of kpas, State the level 3 of KPAs Level 3 KPAs: ... State the level 3 of KPAs Level 3 KPAs: 1)   Organisation Process Focus (OPF): Organisations responsibility is fixed for software process activities which improve the ul

What are the benefits of prototyping, What are the benefits of prototyping?... What are the benefits of prototyping? i. Prototype uses as a basis for deriving system specification. ii. Design quality can be better. iii. System can be handled efficie

What quality would you look for when hiring a test engineer, What qualities... What qualities would you look for when hiring a test engineer? - Test to break attitude - Desire for quality and attention to details. - Tact and diplomacy when dealing w