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
What is software testing The testing process focuses on the logical internals of the software, ensuring that all statements have been tested, and on the functional externals, t

Q. What is structured programming and why is it important? Ans. Structured programming is a term that was coined in the late 1960's to mean programming without using go to st

public static void mergesort(int x[],int y[])

Micro CDS/ISIS Application: In libraries there are a number of repetitive operations. If one Miens the procedures for ordering, receiving, processing and circulating a book, o

Name some Software Standards Numerous terms related to software engineering are regularly standardised by organisations like IEEE (Institute of Electrical and Electronics Engi

What are the benefits of modular design? Changes made during testing and maintenance becomes manageable and they do not affect other modules.

Distinguish between alpha and beta testing.  Alpha and beta testing are the types of acceptance testing.  Alpha test: The alpha testing is attesting in which the version o

Glass box testing is the similar as white box testing. It's a testing approach that consider the application's program structure, and derives test cases from the application's prog

The University needs to develop an online student registration system for new CAO entrants. This system will allow new students to enroll in their university course. Each student i

What are the various testing activities? i. Test planning ii. Test execution iii. Test case design iv. Data collection v. Effective evaluation