Dbms Database Management System Assignment 01

ACKNOWLEDGEMENT

First of all I would like to thank a lot to my teacher who is an excellent lecturer. Under his guidance, I learnt a lot about DBMS concepts. And as a result, I become able to complete this assignment with confidence.
I am also very thankful to God, my husband, my brother and also some of my classmates who helped me a lot in completing my assignment.

(1) HOLDER
HolderID
Name
Telephone
DateOfBirth
OrgName
AgentID(F.K)
ER- DIAGRAM :- AGENT
AgentID
Name
Street
City
State
Postcode
Telephone

may sell supervises buys occupied by EMPLOYEE
StaffID
EmpName
ClaimNum (F.K) belong to assigned to
MAIN ADDRESS
HouseNum
Street
City
State
Postcode
RENEWAL
ReNum
StartDate
EndDate
NumOfDays
PayOption
PreAmount
PayAmount
RenewNotice
PolicyNum (F.K) POLICY
PolicyNum
Make
Model
Year
RegNum
MarketValue
ExcessValue
AgentID (F.K)
StaffID (F.K) occupies sold by underwritten by OTHER ADDRESS
PostalAddress
DeliveryAddress
HolderID (F.K)
HouseNum (F.K) may have sells underwrites

CLAIM
ClaimNum
Event
ReceiveDate
EventDriver
EventDate
EventDescription
SettleAmount
PolicyNum (F.K)
StaffID (F.K)

received by may receive COVER TYPE
CoverNum
Description
PreAmount
PolicyNum (F.K) renews

be renewed be covered by exam- ines EMP_CLAIM
StaffID (F.K)
ClaimNum (F.K) may cover

(2) ASSUMPTIONS :-

1. The main address can belong to only one policy holder. 2. The other address must belong to only one holder.

References: :- Pratt, P.J. & Adamski, J.J. (2008). Concepts of Database Management (6th Edition). Thomson Course Technology.