Assignment 2 Degree of Relationships and Participation for MIS208 Data Analysis

Assignment 2 Degree of Relationships and Participation

If you want to download MIS208 Data Analysis source, click here. 

Set: 14 March 2014                 Due: 21 March 2014

p.102 no:4 

For each of the following pairs of enterprise rules, identify two entity types and one relationship type. State the degree of the relationship in each case

(a) A department employs many persons.

A person is employed by, at most, one department.
-Degree is 1:m

(b) A manager manages, at most, one department.

A department is managed by, at most, one manager.
-Degree is 1:1

(f) A flight-leg connects two airports.

An airport is used by many flight-legs.
-Degree is m:n

(g) A purchase-order may be for many products.

A product may appear on many purchase-orders.
-Degree is m:n

(h) A customer may submit many orders.

An order is for exactly one customer.
-Degree is 1:m

p. 104 no:1

Decide on plausible participation conditions for the entity types in each of the

following: (2 min) Entity types Relationship

(a) House, Person Ownership
-A house must have an owner but a person does not have to own a house

(c) Order, OrderLine Contains (An order may contain several order-lines, each referring to a different item on the order.)
-Order and OrderLine are obligatory to each other.

(e) BankClient, ClientAccount Possesses
-Bank_Client and  Bank_Account are obligatory to each other.

(f) Employee, Skill Has
-Both Employee and Skill are non-obligatory to each other.