Prepare er diagram for the system, Software Engineering

Assignment Help:

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.

 


Related Discussions:- Prepare er diagram for the system

Name the types of software system requirements, What are the types of Softw...

What are the types of Software system requirements ? Functional requirements: Services the system should be required. Non-functional requirements: Constraints on the servi

What are 5 common problems in software development process, What are 5 comm...

What are 5 common problems in software development process? 1. Bad requirements - These requirements are unclear, too general, incomplete, or not testable. They cause problem

Distinguish between verification and validation, Distinguish between verifi...

Distinguish between verification and validation. Verification refers to the set of activities that make sure that software correctly executes a specific function. Validation re

What is regression testing, What is regression testing? Regression test...

What is regression testing? Regression testing is the re-execution of some subject texts that have already been conducted to make sure that changes have not propagated unintend

What do you mean by reverse engineering, Q. What do you mean by REVERSE ENG...

Q. What do you mean by REVERSE ENGINEERING? REVERSE ENGINEERING:-It is a process of analyzing software with a outlook to understanding its design and specification. In t

What are the tools mainly used for information gathering, What are the tool...

What are the tools are mainly used for information gathering 1.  Record review: A review of recorded documents of organisation is performed.Manuals procedures, forms and book

Illustrate the example of data dictionary of payroll, Illustrate the exampl...

Illustrate the example of Data dictionary of payroll Data dictionary of payroll may include below fields: PAYROLL   = [Payroll Details] = @ employee name + employee + id

List the important properties of a modular system, List the important prope...

List the important properties of a modular system.    Desirable properties are:- Every module is a well defined subsystem useful to others Every module has a well defined single

Why is srs also known as blackbox specification of system, Q. Why is SRS al...

Q. Why is SRS also known as the blackbox specification of system ? Ans: SRS document is a contract among the development team and the customer once the SRS document is approv

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd