Give me example of AirTable. What does each one look like?

The purpose of this assignment is to give you experience with building a database from your ERD. The organization is the dentist's office from previous modules. Submit all tasks in one document. Include headings in your document.

Instructions

After completing the learning activities for this module, use what you have learned to complete this assignment:

Using your ERD from the previous module, build a database using$$AirTable$($Links to an external site.$).$Add tables, fields, and keys.$$Add sufficient data to your AirTable database to ensure it is working properly.

The organization is a dentist's office. When new patients are seen for the first time, they complete a patient information form that asks for their name, address, phone number, and brief medical history, which are stored in the patient information file. When a patient calls to schedule a new appointment or change an existing appointment, the receptionist checks the appointment file for an available time. Once a good time is found for the patient, the appointment is scheduled. If the patient is a new patient, an incomplete entry is made in the patient file; the full information will be collected when the patient arrives for the appointment. Because appointments are often made far in advance, the receptionist usually mails a reminder postcard to each patient $2$weeks before the appointment.

Consider the information needed for the patient billing system:

$$Patient information $-$The system should be able to retrieve their contact information as well as their age, blood type, occupation, employer information, and insurance carrier information.

$$Insurance carrier information $-$The system should be able to retrieve the$$number of patients on plan and the carrier's$$contact information.

$$Dentist information $-$The system should be able to retrieve information about the dentist.$$

$1.$Tables

Provide documentation showing the tables from your database.

$2.$Fields

Provide documentation showing the fields from your database.

$3.$Primary Keys

Provide documentation showing the primary keys from your database.

$4.$Secondary Keys

Provide documentation showing the fields from your database.

$5.$Data

Provide documentation demonstrating the data that you added to the database.

$6.$Queries

Provide documentation demonstrating queries that show the relationships $($secondary keys$)$working on the database.

$7.$ERD $($Reference The Physical Entity Relationship Diagram$)$

Recreate your previous ERD to accommodate the database