[Solved]Create 5 Queries Based Database Explain Information One Obtain Running Queries Query Must Q37233574

Create 5 queries based on your database and explain whatinformation one can obtain from running each of the queries. Eachquery must contain at least one of the following:

• Some conditions and sorting
• Multiple fields from multiple tables
• Grouping

Grade for every step is determined by how thoughtful yoursubmission is and how much you are able to relate your project toIST 210 materials. For example, if your queries are simple andshort for step 5, your grade will be lower.

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

/*inserting records*/
insert into Member values (1,’Sachin’, ‘Tendulkar’,2500);
insert into Member values (2,’Yuvraj’, ‘Singh’,4000.50);
insert into Member values (3,’VVS’, ‘Laxman’,10000);
insert into Member values (4,’Sourav’, ‘Ganguly’,8000);
insert into Member values (5,’Suresh’, ‘Raina’,7000);

/*selecting records*/
select * from member;

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

/*inserting records*/
insert into Trainer values (101,’Virat’, ‘Kohli’,10,’Java’);
insert into Trainer values (102,’Ajinkya’,’Rahane’,8,’.Net’);
insert into Trainer values (103,’KL’, ‘Rahul’,3,’Hadoop’);
insert into Trainer values (104,’Rohit’,’Sharma’,6,’Angular’);
insert into Trainer values (105,’MS’, ‘Dhoni’,12,’Full stack’);

/*selecting records*/
select * from Trainer;

Exercise

CREATE TABLE Exercise(

ExerciseID int NOT NULL,

ExerciseName varchar(25),

PRIMARY KEY(ExerciseID));

/*inserting records*/
insert into Exercise values (1001,’Basics ‘);
insert into Exercise values (1002,’Arms’);
insert into Exercise values (1003,’Legs’);
insert into Exercise values (1004,’Yoga’);
insert into Exercise values (1005,’Cardio’);
/*selecting records*/
select * from Exercise;

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 RESTRICT,

FOREIGN KEY(TrainerID)REFERENCES Trainer(TrainerID)

ON UPDATE CASCADE

ON DELETE RESTRICT,

FOREIGN KEY(ExerciseID)REFERENCES Exercise(ExerciseID)

ON UPDATE CASCADE

ON DELETE RESTRICT);

/*inserting records*/
insert into MemberTrainerExercise values (1,101,1001);
insert into MemberTrainerExercise values (2,102,1002);
insert into MemberTrainerExercise values (3,103,1003);
insert into MemberTrainerExercise values (4,104,1004);
insert into MemberTrainerExercise values (5,105,1005);
/*selecting records*/
select * from MemberTrainerExercise;

Member Trainer Exercise PK Member ID PK Trainer ID PK Exercise ID First Name Last Name Fee Due Trainer First Name Trainer Last Name Experience in years Specialization Exercise name Exercise description FK Trainer ID FK Exercise ID Member Trainer Exercise PK,FK1 MemberlD PK,FK2 Irainer ID PK,FK3 Exercise ID Show transcribed image text Member Trainer Exercise PK Member ID PK Trainer ID PK Exercise ID First Name Last Name Fee Due Trainer First Name Trainer Last Name Experience in years Specialization Exercise name Exercise description FK Trainer ID FK Exercise ID Member Trainer Exercise PK,FK1 MemberlD PK,FK2 Irainer ID PK,FK3 Exercise ID

Expert Answer

---

Answer to Create 5 queries based on your database and explain what information one can obtain from running each of the queries. E… . . .