The database has three tables for tracking horse-riding lessons: Horse with columns:ID - primary keyRegisteredNameBreedHeightBirthDate Student with columns:ID - primary keyFirstNameLastNameStreetCityStateZipPhoneEmailAddress LessonSchedule with columns:HorseID - partial primary key, foreign key references Horse(ID)StudentID - foreign key references Student(ID)LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule.

The objective of the question is to create a SQL query that will generate a lesson schedule from a…

Answered: The database has three tables for…

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....

See similar textbooks

Related questions

Question

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

Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule.

AI-Generated Solution

AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.