Student booking system sql plus question:?

J

Jam

New member
Hi

I am creating a student system for my tennis club, i need the following

Reports and facilities required:

Insert and update data:
maintain membership details and record subscription payments

Reports required:
provide a record of court bookings

Management Reports required:
minimal list of members
court bookings per week

Questions:
1.Have i done this right below?
2.What is the realtionship i need to define between the tables: memberhsip,courts,bookings and coaches table below?


/*******************/
memberhsip details:
full, student, OAP, off-peak, junior, racquets only, fitness only
/*******************/
CREATE TABLE membership (
mstudentid VARCHAR(10) NOT NULL,
mmembershiptype VARCHAR(10) NOT NULL,
paymentreceived boolean,
paymentmethod varchar2(30),
paymentamount NUMBER(10,10) NOT NULL,
induction boolean,
mhealthcomments varchar2(200),
mgender varchar2(1),
msurname varchar2(30),
mfistname varchare(30),
maddressline1 VARCHAR(40),
maddressline2 varchar2(40),
mtown Varchar2(20),
mpostcode varchar2(6),
mcontactnumber number(7,15),
memergencynumber number(7,15)
);

/*******************/
Courts details:
type of court ie squash or tennis, type of surface – tennis only, location, comments;
/**********************/
CREATE TABLE Courts (courtid VARCHAR(10) NOT NULL,
courtname VARCHAR(80),
courtSurfacetype VARCHAR(80),
courtlocation varchar2(30),
courtcomments varchar2(300),
);


/**********************/
Bookings details:
type of booking;
/**********************/
CREATE TABLE Bookings (bookingid VARCHAR(10) NOT NULL,
bookingtime date NOT NULL)
);

/**********************/
Coach details:
contact details, type of coach, qualifications, awards;
/**********************/
CREATE TABLE Coaches (coachid VARCHAR(10) NOT NULL,
chealthcomments varchar2(200),
cgender varchar2(1),
csurname varchar2(30),
cfistname varchare(30),
caddressline1 VARCHAR(40),
caddressline2 varchar2(40),
ctown Varchar2(20),
cpostcode varchar2(6),
ccontactnumber number(7,15),
cemergencynumber number(7,15),
coachtype varchar2(50),
qualifications varchar2(50),
awards varchar2(50)
);

Thanks in advance

Tovia Singer
 
Back
Top