Database Purpose: To tack the doctors office visits.
Business Rules : One doctor can see many patients on the same day.
One patient can see only one doc in a day.
Many patients can have the same Insurance.
One Insurance ID can have many patients on it (All family members are on one insurance)
One Insurance company can have many patients.
For Doctors we record multiple phone numbers.
For patients we record only one phone number.
For each Doctor, we also record the specialty.
One doctor has only one specialty.
There can be many doctors with the same specialty.
List all fields that violate the third normal form.
Redesign the database that includes at least the information in the table
Design should meet the business rules and design requirements.
Design must be in third normal form.
Provide names to fields and tables based on recommended naming conventions.
Specify the primary key fields in each table by placing an asterisk beside the fields.
Draw a line between the fields of each table to show the relationships between each
Specify which table is one the one side of the relationship by placing a one next to the field where the line starts.
Specify which table is on the many side of the relationship by placing a crow's feet symbol next to the field where the line ends.