List Entities Scenario Adding Attributes Entity Create Database Diagram Showing Relationsh Q37209819

List all the entities in this scenario below by addingattributes for each entity. Create a database diagram showingrelationships including cardinality.

1-Insurance Company: An insurance company offers both grouppolicies to employers and individual and family policies toindividual purchasers. The company uses a preferred providernetwork of physicians and hospitals, all of which have agreed tothe company’s rate structure (allowable amount) for services. Thecompany reimburses providers according to the rate structure lessdeductible and copays on a fee for service basis. All allowablecharges, copays, deductibles, and coverages are dictated by aninsurance plan and the company offers a number of plans with someplans being strictly employer

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.