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

Artificial intelligence, what are the PEAS of E-mail agent what are the PEAS of E-mail agent

What does validation represent, What does Validation represent? Validat... What does Validation represent? Validation shows the set of activities that ensure that the software that has been built is satisfying the customer needs.

Discuss in details about integration testing, Discuss in details about Inte... Discuss in details about Integration testing. It is a systematic procedure to construct the program structure. Incremental integration - The program is built and tested i

What are the different architectures developed during bpe, What are the dif... What are the different architectures developed during BPE? Data architecture framework for the information requires of a business. Application architecture incorporates the

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

What is a test build manager, Test Build Managers deliver present software ... Test Build Managers deliver present software versions to the test environment, install the application's software and relate software patches, to both the application and the opera

What is the meaning of system engineering, What is the meaning of System En... What is the meaning of System Engineering? System Engineering means designing, deploying, implementing and operating systems which include hardware, software and user.

Explain token count, Token count: -  A program is considered to be series o... Token count: -  A program is considered to be series of tokens and if we count the number of tokens, some interesting results might be emerge. Tokens are classified as either opera

What are the properties of srs, What are the properties of SRS? i. Corr... What are the properties of SRS? i. Correct - The SRS must be built up to date while  appropriate requirements are identified. ii. Unambiguous - When the requirements are pro

Explain about function count - software metrics, Q. Explain about Function ... Q. Explain about Function count? Function count:- It measures the functionality from the user point of view that is on the basis of what the user requests and receives in ret