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
give the example of data dictionary

Question: (a) Show two main approaches to identify risk in a project. (b) John finds that IOE recovers some overheads as oncosts on direct staff costs although others are

The terms "test scenario" and "test case" are certain used synonymously. Test scenarios are test cases or test scripts, and the series in which they are to be implemented. Test sce

What is Control Chart? Ans) A statistical method for distinguishing among common and special cause variation exhibited by processes.

Data validity is the reasonableness and correctness of data.

Q. Explain Lines of code - Software Metrics? Lines of code (LOC) is a software metric used to measure the size of a software program by counting the number of lines in the te

Define Test Harness? Ans) A software tool that allows the testing of software components that links test capabilities to perform particular tests, accept program inputs, replica

Why is maintenance of a software important?  The alteration of a software product, after delivery, to correct faults, to improve performance or other attributes, or to adapt th

What are the advantages of horizontal partitioning? i. Software is must be easy to check. ii. Software is handy to maintain. iii. Create fewer side effects. iv. Softwa

Question: (a) Document the information input and output for the events mentioned in the case study on the basis of facts provided. (b) Comment on the fact that barely any