2.21 LAB - Create LessonSchedule table with FK constraints The database contains a Horse table, with columns: ID integer, primary key Registered Name - variable - length string The database contains a Student table, with columns: ID - integer, primary key FirstName variable-length string LastName - variable-length string Create a third table, named LessonSchedule, with columns: HorseID - integer with range 0 to 65 thousand, not NULL, foreign key references Horse (ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student (ID) Lesson DateTime - date/time, not NULL Primary key is (HorseID, Lesson DateTime)

2.21 LAB - Create LessonSchedule table with FK constraints The database contains a Horse table, with columns: ID integer, primary key Registered Name - variable - length string The database contains a Student table, with columns: ID - integer, primary key FirstName variable-length string LastName - variable-length string Create a third table, named LessonSchedule, with columns: HorseID - integer with range 0 to 65 thousand, not NULL, foreign key references Horse (ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student (ID) Lesson DateTime - date/time, not NULL Primary key is (HorseID, Lesson DateTime)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns only the Trading_Symbol column from every row in the table.
Salesforce. 12.
create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id varchar(30),CONSTRAINT FK_salesman_id FOREIGN KEY (salesman) REFERENCES salesman(salesman_id)); i keep getting this…
Database Schema The schema for the Ch07_FACT database is shown below and should be used to answer the next several problems. Click this image to view it in its own tab. FIGURE P7.56 THE CH07_FACT ERD CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num FK2 Pat_ID Check_Out_Date Check_Due_Date Check_In_Date >0-----H- Pat_FName Pat LName Pat_Type BOOK AUTHOR PK Book_Num PK Au ID Book_Title Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_BirthYear WRITES PK,FK1 Book Num PK,FK2 Au ID The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book,
Code SQL
A forcign key in a relational database table is a(n): A Set of attribute values in a table. B Combination of attributes in a table. 'C Altribute in one table that is an attribute in another table. D Column ofa table.
assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns all the columns from the rows where Trading_Symbol starts with "SU".
Scenario: The owner of Al Musana Hotel would like to have a database tables that will help him manage the clients and rooms in his building. He wants to record the information about his clients and its occupancy. The hotel has three different room types which are available for daily rent only. As the Database Designer, perform the following tasks to help the owner of the hotel: Create the CLIENTS table using the specification below: Table Name: CLIENTS Field Name/ Data Type column name Size Constraints CID Number 8 PRIMARY KEY CName Varchar2 25 NOT NULL Validate to accept Male or Female only Gender Varchar2 10 Address Varchar2 25 Contact Number 15 Стуре Varchar2 15
Assume that a database has a table named Stock, with the following columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price moneyWrite a Select statement that returns the Trading_Symbol column only from the rows where Purchase_Price is greater than $25.00.
Q4. Problem Statement You are managing a database for a movie production company. The database includes information about actors, directors, movies, movie cast, and ratings. Write a query for updating the ratings of all movies directed by 'Lankesh' to a new rating of 3 in a database that contains information about actors, directors, movies, movie casts, and ratings. The following table is already created, and the records are inserted into the table. The Sample records are given below Input Format The input records are already prepopulated, as given in the problem statement. Output Format The output should display the updated RATING table after the ratings for movies directed by 'Lankesh' have been changed to 3. Movie ID Review Stars 1 4 2345 3 4 6 4 3 Refer to the sample output for the column headers. Sample Input Sample Output DFocus BE
Assume that the Authors table is already built in the database with the following specifications: Authors: Column Name Data Type constrains Authors ID Author Name Varchar2(10) |Varchar2(30) Primary key Unique You Need to Create the Books table with the following specifications Column Name Data Type Constrains ISBN Book Title Book Price Author id Number (10) Varchar2(40) Number (4,2) Varchar2(10) Primary key Not Null referencing the Author_ID in the Author Table Complete the create statement by drag and drop the correct word: Create Table lblank (ISBN Number (10) plank, Book Title Varchar2blank ) Not Null, Book Price Number(4, 2), Auther IR blank (10) references Jolank (blank ); Author ID Books Number||Authors Not Nul Varchar2| Primary Key 40 h (United States)
0o. You Normalized database up to 3 nf. .