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
USE OF SOFTWARE PACKAGE: The concept of applications software and were told about software packages and their types. In other words, the discussion implies that instead of wri

Q. Design black box test suits for a function that checks whether a character or string upto ten characters in a palindrome? Ans Following may be the test cases: - Try wit

How can you create the new system  System is to be computerised. Following will be created: (i)                 All DVD and CD data will be stored on a database   (ii)

Problem solving is a critical skill for success in business—in fact it’s often what you are hired and paid to do. This article explains the five problem solving steps and provides

Determine the process of Software Review - This is an evaluation technique which involves bringing together a group of technical personnel to analyze a software artifact to im

I NEED HELP WITH DESIGN A CIRCUIT ON ALTIUM 09 AND PROGRAMMING WITH DESCRIPTION FOR ALL THE STEPS

Determine in verify about CAPABILITY MATURITY MODELS In this model anapproach for improving Software process is devised. It isn't concerned which life cycle modeis followed for

Question 1 What is SSAD? Explain in detail Question 2 Explain any three limitations of the agile process Question 3 Describe continual integration Question

Q. Describe the various steps of the reuse-oriented model? The reuse-oriented model, also called reuse-oriented development (ROD), is a method of software development in which

Software Quality Assurance and Software Quality Control SQA verifies if the process that is followed to form a product is effective and does not have process defects while SQC