Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CREATE TABLE Customer ( CustomerID INT PRIMARY KEY NOT NULL, Phone_number VARCHAR(10) UNIQUE NOT NULL, FirstName VARCHAR(225) NOT NULL, LastName VARCHAR(255) NOT NULL, Sex VARCHAR(10)

CREATE TABLE Customer ( CustomerID INT PRIMARY KEY NOT NULL, Phone_number VARCHAR(10) UNIQUE NOT NULL, FirstName VARCHAR(225) NOT NULL, LastName VARCHAR(255) NOT NULL, Sex VARCHAR(10) NOT NULL, Age TINYINT NOT NULL, CHECK (Age>= 16) -- Customers should be 16 years old at least. );

CREATE TABLE Membership ( MembershipID INT PRIMARY KEY NOT NULL, CustomerID INT FOREIGN KEY REFERENCES Customer(CustomerID), Membership_level VARCHAR(255) NOT NULL, Joining_date DATE NOT NULL, Expiration_date DATE NOT NULL );

CREATE TABLE Manager ( ManagerID INT PRIMARY KEY NOT NULL, FirstName VARCHAR(255) NOT NULL, LastName VARCHAR(255) NOT NULL, Salary DECIMAL(6,2) NOT NULL, Age TINYINT NOT NULL, CHECK (Age> 25) -- to be a manager employee should be older than 25. );

CREATE TABLE Coach ( EmployeeID INT PRIMARY KEY NOT NULL, FirstName VARCHAR(255) NOT NULL, LastName VARCHAR(255) NOT NULL, Sex VARCHAR(10) NOT NULL, Salary DECIMAL(6,2) NOT NULL, Age TINYINT NOT NULL, CHECK (Age >18) -- Employees must be greater than, or equal to 18 );

CREATE TABLE Schedule ( ScheduleID INT PRIMARY KEY NOT NULL, CustomerID INT FOREIGN KEY REFERENCES Customer(CustomerID), EmployeeID INT FOREIGN KEY REFERENCES Coach(EmployeeID), Activity VARCHAR(255), Date VARCHAR(255) );

CREATE TABLE Payment ( PaymentID INT PRIMARY KEY NOT NULL, CustomerID INT FOREIGN KEY REFERENCES Customer(CustomerID), Amount DECIMAL(6,2) NOT NULL );

Can you populate (fill them in data) this tables

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

Nested Relations And Complex Objects In Databases Lncs 361

Authors: Serge Abiteboul ,Patrick C. Fischer ,Hans-Jorg Schek

1st Edition

ISBN: 3540511717, 978-3540511717

More Books

Students also viewed these Databases questions