Dbms Database software management System Project 01 Essay

ACCEPTANCE

First of all I would like to give thanks to a lot to my own teacher that is an excellent lecturer. Under his guidance, I learnt a lot about DBMS concepts. And as a result, I turn into able to finish this task with confidence. My spouse and i am also very thankful to God, my husband, my brother and in addition some of my personal classmates whom helped me a whole lot in doing my job.

(1) HOLDER

HolderID

Term

Telephone

DateOfBirth

OrgName

AgentID(F. K)

ER- DIAGRAM: --

AGENT

AgentID

Name

Streets

City

Express

Postcode

Cell phone

may sell

supervises

buys

occupied by

EMPLOYEE

StaffID

EmpName

ClaimNum (F. K)

belong toassigned to

KEY 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 simply by

OTHER TALK ABOUT

PostalAddress

DeliveryAddress

HolderID (F. K)

HouseNum (F. K)

may include sells

underwrites

CLAIM

ClaimNum

Event

ReceiveDate

EventDriver

EventDate

EventDescription

SettleAmount

PolicyNum (F. K)

StaffID (F. K)

received simply by may obtain

COVER TYPE

CoverNum

Description

PreAmount

PolicyNum (F. K)

rebuilds

be restored

become covered by exam-

ines

EMP_CLAIM

StaffID (F. K)

ClaimNum (F. K)

might cover

(2) ASSUMPTIONS: -

1 . The key address can belong to just one policy holder. 2 . The different address must belong to just one holder.

3. The entity " MAINADDRESS” is definitely allocated " HouseNum” (House Number) like a Primary crucial for exclusive identification. some. The enterprise " RENEWAL” is allocated " ReNum” (Renewal Number) as a Main key to get unique identification. 5. There has to be renewal of each and every policy.

six. The main talk about may relate with one or various other addresses. six. The additional address can relate to only 1 main talk about. 8. Each cover type can be included in only one policy.

9. Every claim may be received simply by one insurance plan.

10. The organization " AGENT” is offered " AgentID” (Agent Identity number) like a primary essential. 11. The entity " CLAIM” is definitely allocated " ClaimNum” (Claim number) like a primary key to uniquely specify the beliefs. 12. The entity " COVER TYPE” is allocated " CoverNum” (Cover number) as a primary key.

(3) RELATIONAL INFO STRUCTURE: -

HOLDER(HolderID, Name, Telephone, DateOfBirth, OrgName, AgentID)

AGENT(AgentID, Brand, Street, City, State, Postcode, Telephone)

MAINADDRESS(HouseNum, Street, City, State, Postcode)

OTHERADDRESS(PostalAddress, DeliveryAddress, HolderID, HouseNum)

POLICY(PolicyNum, Help to make, Model, 12 months, RegNum, MarketValue, ExcessValue, AgentID, StaffID)

EMPLOYEE(StaffID, EmpName, ClaimNum)

RENEWAL(ReNum, StartDate, EndDate, NumOfDays, PayOption, PreAmount, PayAmount, RenewNotice, PolicyNum)

COVERTYPE(CoverNum, Description, PreAmount, PolicyNum)

CLAIM(ClaimNum, Event, ReceiveDate, EventDriver, EventDate, EventDescription, SettleAmount, PolicyNum, StaffID)

EMP_CLAIM(StaffID, ClaimNum)

Note: -- The relational database composition is in 3NF.

(4) RELATIONAL DATABASE PROGRAMA: -

Table Name Discipline dataType Information

HOLDER holderID Number(10) Major Key

Name Text(30)

Cell phone Number(20)...

Recommendations:: -

Pratt, P. L. & Adamski, J. L. (2008). Principles of Database software management (6th Edition).

Thomson Course Technology.

Popular

 Essay upon Are Young adults the Dumbest Generation Ever?
Essay upon Are Young adults the Dumbest Generation Ever?

Paradoxically, all those things is truly continuous is the notion of change. This kind of notion generally tends to apply itself to every possible thought, whether tangible or summary, and…...

 Fundamentals of Hardware and software pieces Essay
Fundamentals of Hardware and software pieces Essay

п»ї Course: IFTH 3 years ago Fundamentals of Computer Hardware and Software Lecturer: Donato Scarborough CFBC: TVEMS Contact Information: Office Location: Horsford Street Campus…...

 Evaluation Workshop 3 Online casino Industry Dissertation
Evaluation Workshop 3 Online casino Industry Dissertation

п»ї The examination of the domain is completely narrowed and pointed out. The table gives general details of the online casino industry in the described domain name and provides…...

 How Father and mother Influence Their Children Research Daily news
How Father and mother Influence Their Children Research Daily news

How Parents Impact Their Children By Brittney Smith How Parents Influence Their Children By Brittney Smith DEP 2004: Class meets by 11: 00 A.…...