Insert at least 5 spurious records into each table.
Use INSERT INTO command to add at least 5 records toeach of your tables.
Member
CREATE TABLE Member(
MemberID int NOT NULL,
FirstName varchar(25) NOT NULL,
LastName varchar(25) NOT NULL,
FeeDue decimal(5,0),
Primary Key(MemberID));
Trainer
CREATE TABLE Trainer(
TrainerID int NOT NULL,
FirstName varchar(25) NOT NULL,
LastName varchar(25) NOT NULL,
Experience int,
Specialization varchar(30),
PRIMARY KEY(TrainerID));
Exercise
CREATE TABLE Exercise(
ExerciseID int NOT NULL,
ExerciseName varchar(25),
PRIMARY KEY(ExerciseID));
MemberTrainerExercise
CREATE TABLE MemberTrainerExercise(
MemberID int NOT NULL,
TrainerID int NOT NULL,
ExerciseID int NOT NULL,
PRIMARY KEY(MemberID,TrainerID,ExerciseID),
FOREIGN KEY(MemberID)REFERENCES Member(MemberID)
ON UPDATE CASCADE
ON DELETE