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

These are my database tables can you write triggers for these tables according 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

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 19 21 2012 Proceedings Part 3 Lnai 7198

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284922, 978-3642284922

More Books

Students also viewed these Databases questions

Question

Why We Listen?

Answered: 1 week ago