Question: Hi, can you please decribe these tables in sql programme and give me screen shot of it ? I mean i need a screen shot

Hi, can you please decribe these tables in sql programme and give me screen shot of it ? I mean i need a screen shot of structure of these tables after describe command. Thank you

create table Sports(Sport_ID NOT NULL, Sport_Name varchar(25) NOT NULL, constraint pk_sports PRIMARY KEY(Sport_ID));

create table Trainers(Trainer_ID NOT NULL, Trainer_Name varchar(25) NOT NULL, Trainer_Surname varchar(20) NOT NULL, Age number check(age <=40),Hire_date DATE NOT NULL, Salary numeric(8,2), constraint pk_trainers PRIMARY KEY(Trainer_ID),Foreign Key(Sports_Id) References Sports(Sports_Id));

create table Members(Member_ID NOT NULL, Member_Name varchar(25) NOT NULL, Member_Surname varchar(20) NOT NULL, Age NOT NULL,Email UNIQUE,constraint pk_members PRIMARY KEY(Member_ID),Foreign Key(Trainer_Id) References Trainers(Trainer_Id), Foreign Key(Sports_Id) References Sports(Sports_Id));

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!