Transcript Document

Presented By:
Guo Lee
Jian Pan
Heng Wang
Mingsang Bae
Ya-Wei Liang
Yuk-Ling Chan
Richmond Manzana
Group: 2
• A licensed franchisee of multiple Medical Evaluation Companies
• Coordinates transitions between Insurance Agents, Examiners and Labs
• Process paramedical exam request from Insurance Company
• Assign applicants to Examiners for physical examination and interview
• Assigning collections of specimen to qualified Lab
CLIENT
Agents
Examiners
IPS
Insurance
Company
Medical Lab
IPS’s database is organized into a series of entities.
•
Person,
• Examining Company,
•
Client,
• Exam Order,
•
Agent,
• Lab,
•
Examiner,
• Test Type,
•
Underwriter,
• Questionnaire.
•
Insurance Company,
•
Broker，
Each entity has a unique number, a unique name, and a set of
attributes that describe it.
IPS has contracts with multiple Examining Companies, each of which has
contracts with multiple Insurance Companies. We keep track of the different
Insurance Companies that each Examining Company has contract with. We
also store the general information of Examining Company like address for
billing purposes.
Examining Company has a network of independent Examiners who
performed paramedical exam on prospect Client of Insurance Company.
Examiner gathers specimen from Client, and passes it to the Lab for
testing. Lab then passes the test results directly to Insurance Company
underwriters for risk assessment.
An Agent may represent multiple Insurance Company through Brokers by contracts.
Client purchases insurance policy from Agent, who then submits Exam request of
Test Types based on the policy purchased to IPS along with Client’s information for
medical evaluation. IPS then assigns Client to an Examiner according to the Exam
requested. A Client may be recommended by multiple Agents.
IPS stores each Client’s personal information such as name, social security number,
policy requested, address, phone number, and birthday. IPS also keeps track of the
completed and uncompleted Test Types that requested for the Clients. In addition,
IPS tracks Client status, Examiner assignment, Exam schedule, Agent success rate,
and billing in order to maximize efficiency and profit.
(1,N)
(1,M)
TEST TYPE
EXAMINING
COMPANY
DESINATES
INSURANCE
COMPANY
(1,N)
(1,N)
PAYS
(1,M)
INCLUDES
(1,1)
AFFILIATES
WITH
CAN BE
CONDUCTED
BY
(1,1)
EXAM
ORDER
(1,N)
(1,N)
(1,N)
BROKER
(1,1)
(1,1)
REQUESTS
(1,M)
CONTRACTS
(1,1)
IS GIVEN TO
(1,N)
EXAMINER
IS
ASSIGNED
TO
(1,N)
(1,N)
(1,M)
SOLD POLICY
TO
(1,N)
WRITES
CLIENT
(0,N)
SENDS
SAMPLE TO
AGENT
PERSON
UNDERWRITER
QUESTIONNAIR
E
d.c.
REVIEWS
REVIEWS
REPORT
LAB
•
Efficiency in information entry, retrieval and processing
•
Allow data monitoring and query
•
Improves data accessibility
•
Marketing, Human Resources and Profitability Analysis
11-15
- Revises EER
diagram
11-11
- Client feedback on
suggested queries
10-22
DP Review I
10-25
- EER Feedback
- Contacts Silvia
for revising
EER diagram
10-26
Revises EER
Diagram Due
- Relational
design
finalizes
11-18
DP Review II
- Queries Finalizes
11-4
11-13
11-16
- Relational
Design
Begins
- Quantitative
analysis on
queries
- finalizes 5
queries with
analysis
-Proposes &
selects
queries
- Revises
Relational
design
- Presentation
slide ready