Payor: You are working for an insurance company and you need a database to help track your quality measure of how many of your clients have a 1 year well child check.You need collect parent name, address and phone numberYou need to know when the child is due for the 1 year visitThere are 3 pediatric practices that your clients can choose from each of which have 2 pediatricians on staff.Each family has determined their preferred communication methodEmailTextMailEach patient is assigned to one of 2 navigators at the insurance company who will provide a reminder via the family’s prefered communication methodYour submission should include:A list of business rules written so that your 'customer' would understand how their database is designed.A crow's foot ERD for your database that demonstrates your understanding ofentitiesattributesrelationshipsnaming conventionsprimary and foreign keysTables showing 3-5 records for each entity.

Business Rule : A business rule characterizes or compels some part of business and consistently sets…

Answered: Payor: You are working for an insurance…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Payor: You are working for an insurance company and you need a database to help track your quality measure of how many of your clients have a 1 year well child check.

You need collect parent name, address and phone number
You need to know when the child is due for the 1 year visit
There are 3 pediatric practices that your clients can choose from each of which have 2 pediatricians on staff.
Each family has determined their preferred communication method

Email
Text
Mail

Each patient is assigned to one of 2 navigators at the insurance company who will provide a reminder via the family’s prefered communication method

Your submission should include:

A list of business rules written so that your 'customer' would understand how their database is designed.
A crow's foot ERD for your database that demonstrates your understanding of
- entities
- attributes
- relationships
- naming conventions
- primary and foreign keys
Tables showing 3-5 records for each entity.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions