Information Modeling Assignment, Assignments of Data Mining

Download Information Modeling Assignment and more Assignments Data Mining in PDF only on Docsity!

INDIVIDUAL PROJECT

ASSIGNMENT ON

INFORMATION MODELLING

CWID- 10472558

Ananta Kumari

MIS - 631

Another method is to design supertype and subtype tables. This is possible when both share the same attributes. Eg:- Tax terms w.r.t to employees where employees are the supertype and full time/ hourly employees are subtypes. Multiple attributes when a subtype has more than one supertype. Besides is an example of this where a subtype discriminator has been used. This leads to the supertype to be a member of one subtype over another. Exercise 1: Discuss the database table options available when implementing subtype associations. Supertype/subtype pattern where all content is stored in a single table.

C

DEPARTMENT

PROJECT^ EMPLOYEE

D

Selected Semantics- EXERCISE 2

• (^) An employee must belong to one and only one department (if a Department is dissolved, the Employee instances must be assigned to another department or be terminated).
• (^) A project need not have anyone assigned to it.
• (^) An employee need not be assigned
• (^) to a project.

SHIPPING

ORDER

C

PART

SUPPLIER

Selected Semantics- EXERCISE 3

• (^) A shipping order must include at least one line item
• (^) A line item represents a part from a given supplier Shipping Order Line Item Supplier Part

LINE ITEM

REL

Example 5

DOCTOR

PATIENT

SYMPTOM D

REL

APPOINTMENT

C

C

BILL

PAYMENT

INSURANCE

COMPANY

UNINSURED^ SUBSCRIBER

SE

C

D

C

Selected Semantics

• (^) A patient need not have insurance
• (^) Both patient and/or the insurance company may make payments
• (^) A bill can have several payments associated with it

Exercise 6

JOB TITLE #1... JOB TITLE #N^ BENEFITS

EQUIPMENT

OWNERSHIP

DEPARTMENT

EMPLOYEE

JOB

CLASSIFICATION

SUPERVISOR SUPERVISEE^

OFFICE

C EQUIPMENT

D

C

SE

D

REF

SE

PURCHASING AN AUTOMOBILE

UPDATE OWNER NAME

SUPER CONTRACT

SUB CONTRACTS (AUTOMOBILE OWNER)

FIRST NAME LAST NAME

UPDATE AUTOMOBILE

INSURANCE

COVERAGE

ZIPCODE (IMPLEMENTATION)

TENURE

UPDATE AUTOMOBILE INSURANCE

COVERAGE

EXERCISE 8: Contract

Development

• (^) Develop the specifications for a major activity, such as purchasing a new home or purchasing an automobile
• (^) The solution should contain a contract map, with a set of interrelated contracts.
• (^) Each contract (super & sub) is to be fully specified in terms of its {invariants, pre- conditions, post-conditions, triggers}
• (^) Any major activity is OK keeping in mind the requirement for a contract map, with a specification for a super contract and at least 2 subcontracts.

SUPERTYPE

Invariant(always applies).

PRE-CONDITION POST-CONDITION TRIGGER

Owner name and The automobile, Automobile has a The automobile insurance is related insurance and new owner on day company has to automobile. owner exist. of purchase and a approved and ( direct nexus) Only that particular new insurance updated the owner automobile has a policy. name and specific owner Insurance for insurance for that name and a automobile is insurance through specific(fixed bound to renewal. clearance of policy) insurance. documents. Every Automobile The owner owns should have one this automobile owner and auto only and is not a insurance. part of any other insurance policy.