Answered: Trainer Trainer ID (PK) First Name Last…

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

Related questions

Concept explainers

Question

You have been given the following specifications of a simple database for a local Gym that keeps record of Trainer, Sessions, and Customers.

Give the SQL to create the Session table. You may assume that the Trainer and Customer tables have already been created, and that the TrainerID and CustomerID columns are of the data type VARCHAR2(10). The status of the Session refers to the current state of the Session and can only be Active or Dropped

Trainer
TrainerID (PK)
First Name
Last Name
Address
Phone
Date OfBirth
SessionID (FK)
+H
Session
SessionID (PK)
Session Name
Room Name
Date Started
Status
LeadTrainerID (FK)
CustomerID (FK)
+H
Customer
CustomerID (PK)
Name
Address
ContactPhone

Expert Solution

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions