The database has three tables for tracking horse$-$riding lessons:

Horse with columns:

ID $-$ primary key

RegisteredName

Breed

Height

BirthDate

Student with columns:

ID $-$ primary key

FirstName

LastName

Street

City

State

Zip

Phone

EmailAddress

LessonSchedule with columns:

HorseID $-$ partial primary key, foreign key references Horse$($ID$)$

StudentID $-$ foreign key references Student$($ID$)$

LessonDateTime $-$ partial primary key