mis 2

qwerty564

assignment2_1.doc

Home >Business & Finance homework help >Management homework help >mis 2

MIS343 Assignment#2

Objective: Logical modeling.

Due: 6:00PM, Monday, May 8th, 2017

Description (Total: 50 points)

1. Page 157, Review Question #5, #11.

2. Page 158, Problems and Exercises #4a. (No need to diagram the functional dependencies.)

Note: This is to transform the entity-relationship diagram for Problem and Exercises 17b in Chapter 2 to a relational schema. The entity-relationship diagram is as follows:

3. Page 159, Problems and Exercises #11a. (No need to diagram the functional dependencies.)

Note: This is to transform the enhanced entity-relationship diagram for Problem and Exercises 12 in Chapter 3 to a relational schema. The law firm enhanced entity-relationship diagram is as follows:

image2.emf

Brought ByBrought Against

Plaintiff?=Y

Defendant?=Y

LEGAL ENTITY

LE No

LE Name

LE Net Worth

Person Or Org

LE Type (Plaintiff? Defendant?)

PLAINTIFF

Requested

Judgement

DEFENDANT

CASE

Case No

Date Opened

Date Closed

JudgmentDesc

LE Type:

Answer the above questions and solve the problems. Write your answers or draw the graphic models in a MS Doc file.

////////////////////////////////////

If you use the 11th edition of the “Modern Database Management”, the following is the corresponding questions for this assignment:

1. Page 192, Review Question #5, #11.

2. Page 193, Problems and Exercises #4a. (No need to diagram the functional dependencies.)

Note: This is to transform the entity-relationship diagram for Problem and Exercises 15b in Chapter 2 to a relational schema. The entity-relationship diagram is as follows:

3. Page 194, Problems and Exercises #11a. (No need to diagram the functional dependencies.)

Note: This is to transform the enhanced entity-relationship diagram for Problem and Exercises 15 in Chapter 3 to a relational schema. The law firm enhanced entity-relationship diagram is as follows:

image4.emf