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

These are my database tables can you write triggers for these tables and made a UML diagram

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!