Add a patient table for your Shoreline database. Include the following fields: Patient ID, Birth Date, Fee, Address, Phone Number, and Provider

Step 1: create a table to contain patients using the field information above.

Step 2: Add the sample records below.

Step 3: Include a screenshot showing successful completion.

Step 4: Write minimum of 500words with 2 citations identifying the significance of the Provider field/values in this table. How does this lend itself to database relationships? Where is the relationship between the two tables? How do field values and relationships lend themselves to normalization? At what level do you think this is normalized?

Step 5:In your written piece, add the relationship between the two tables to the database.