Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3.8 LAB - Create LessonSchedule table with FK constraints Two tables are created: 1. Horse with columns: ID - integer, primary key RegisteredName - variablelength

image text in transcribed

3.8 LAB - Create LessonSchedule table with FK constraints Two tables are created: 1. Horse with columns: ID - integer, primary key RegisteredName - variablelength string 2. Student with columns: ID - integer, primary key FirstName - variable-length string - LastName - variable-length string Create the LessonSchedule table with columns: - HorselD - integer with range 0 to 65 thousand, not NULL, par tial primary key, foreign key references Horse(ID) - StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) - LessonDateTime - date/time, not NULL, partial primary key If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically. Note: Table and column names are case sensitive in the auto-grader

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Building The Data Warehouse

Authors: W. H. Inmon

4th Edition

0764599445, 978-0764599446

More Books

Students also viewed these Databases questions

Question

plan for before, during and after;

Answered: 1 week ago

Question

6. Explain the strengths of a dialectical approach.

Answered: 1 week ago