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 a program and identify DU path for Telecom domain

what is software decomposition? what are its techniques?

What is the use of CMM? Capability Maturity Model is used in assessing how well an organisation's processes permit to complete and manage latest software projects.

what is design assignment

INFORMATION STORAGE  AND RETRIEVAL SOFTWARE: IBM (International Business Machines Corporation) was one of the earliest to invest money to develop software packages intended fo


Define metrics. Metrics is explained as the degree to which a system component, or process possesses a given attribute.

Question: (a) With the aid of a labeled diagram, briefly describe the phases of the "Unified software development life cycle" and state the output of each phase. (b) Describ

Describe the various elements of data design? i. Data object - The data objects are identified and relationships among various data objects are represented using ERD or data di

How many types of traceability in software engineering? i. Source traceability - These are generally the links between requirement to stakeholders who suggests these requiremen