Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Object Oriented Databases Prentice Hall International Series In Computer Science

Authors: John G. Hughes

1st Edition

0136298745, 978-0136298748

More Books

Students also viewed these Databases questions