Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started