Insert Least 5 Spurious Records Table Use Insert Command Add Least 5 Records Tables Member Q37097200

Insert at least 5 spurious records into each table.

Use INSERT INTO command to add at least 5 records toeach of your tables. Member Trainer Exercise PK Member ID PK Trainer ID PK Exercise ID First Name Last Name Fee Due Trainer First Name Trainer Las

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

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.