Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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

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

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter2: Data Models
Section: Chapter Questions
Problem 10P
See similar textbooks
icon
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.

    1. You need collect parent name, address and phone number
    2. You need to know when the child is due for the 1 year visit
    3. There are 3 pediatric practices that your clients can choose from each of which have 2 pediatricians on staff.
    4. Each family has determined their preferred communication method
      1. Email
      2. Text
      3. Mail
    5. 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

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Table
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS