Problem
Design a group of database tables for the St. Charles Riding Academy. The academy teaches students to ride by starting them on horses that have been ranked according to their manageability, using a numeric score from 1 to 4. The data you need to store includes the following attributes:
• Student's last name
• Student's first name
• Student's address
• Student's age
• Student's emergency contact information-name and phone number
• Student's riding level-1, 2, 3, or 4
• Horse's name
• Horse's age
• Horse's color
• Horse's manageability level-1, 2, 3, or 4
• Horse's veterinarian's name
• Horse's veterinarian's phone number
Design the tables you would need so they are all in third normal form. Create at least five sample data records for each table you create.