Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started