SQL> DESCRIBE Participant
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 PNUMBER				   NOT NULL NUMBER(38)
 NAME					   NOT NULL VARCHAR2(50)

SQL> DESCRIBE Competition
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 CDATE					   NOT NULL DATE
 PLACE					   NOT NULL VARCHAR2(20)

SQL> DESCRIBE Result
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 PNUMBER				   NOT NULL NUMBER(38)
 CDATE					   NOT NULL DATE
 PLACE					   NOT NULL VARCHAR2(20)
 POINTS 					    NUMBER(38)

SQL> SELECT * FROM Participant;

   PNUMBER NAME
---------- --------------------------------------------------
       113 Alice
       115 Bob
       120 Chris

QL> SELECT * FROM Competition;

CDATE	  PLACE
--------- --------------------
16-FEB-09 Birmingham
16-FEB-09 Nottingham
17-FEB-09 London

SQL> SELECT * FROM Result;

   PNUMBER CDATE     PLACE		      POINTS
---------- --------- -------------------- ----------
       113 16-FEB-09 Nottingham 		  20
       115 16-FEB-09 Nottingham 		  30