Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

USE GYM; 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,

USE GYM;

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 );

These are my gym database tables can you write triggers for these tables accodring to sql server syntax

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

Relational Database Design A Practical Approach

Authors: Marilyn Campbell

1st Edition

1587193175, 978-1587193170

More Books

Students also viewed these Databases questions

Question

5. Recognize your ability to repair and let go of painful conflict

Answered: 1 week ago