Planet Tables

1. Planets.txt

<PRE>

DROP TABLE planet;

CREATE TABLE planet (name VARCHAR2(10),

id VARCHAR2(5),

distance_km NUMBER,

orbperiod_days NUMBER,

discoverer VARCHAR2(8),

datediscovery NUMBER,

radius_km NUMBER,

mass_kg NUMBER,

rotperiod_days NUMBER,

CONSTRAINT id_pk PRIMARY KEY (id));

INSERT INTO planet (name,id,distance_km,orbperiod_days,radius_km,mass_kg,rotperiod_days)

VALUES ('Mercury','I',57910000,87.97,2440,330000000000000000000000,58.6);

INSERT INTO planet (name,id,distance_km,orbperiod_days,radius_km,mass_kg)

VALUES ('Venus','II',108200000,224.7,6052,4870000000000000000000000);

INSERT INTO planet (name,id,distance_km,orbperiod_days,radius_km,mass_kg,rotperiod_days)

VALUES ('Earth','III',149600000,365.26,6378,5970000000000000000000000,0.99);

INSERT INTO planet (name,id,distance_km,orbperiod_days,radius_km,mass_kg,rotperiod_days)

VALUES ('Mars','IV',227940000,686.98,3397,642000000000000000000000,1.03);

INSERT INTO planet (name,id,distance_km,orbperiod_days,radius_km,mass_kg,rotperiod_days)

VALUES ('Jupiter','V',778330000,4332.71,71492,1900000000000000000000000000,0.41);

INSERT INTO planet (name,id,distance_km,orbperiod_days,radius_km,mass_kg,rotperiod_days)

VALUES ('Saturn','VI',1429400000,10759.5,60268,568000000000000000000000000,0.45);

INSERT INTO planet VALUES ('Uranus','VII',2870990000,30685,'Herschel',1781,25559,86800000000000000000000000,-0.72);

INSERT INTO planet VALUES ('Neptune','VIII',4504300000,60190,'Adams',1846,24766,102000000000000000000000000,0.67);

INSERT INTO planet VALUES ('Pluto','IX',5913520000,90800,'Tombaugh',1930,1137,12700000000000000000000,-6.39);

</PRE>

2. Moons.txt

<PRE>

DROP TABLE moon;

CREATE TABLE moon (name VARCHAR2(10), mid VARCHAR2(5),

id VARCHAR2(5), Distance_km NUMBER, Orb_Period_days NUMBER,

Discoverer VARCHAR2(15), Date_Disc NUMBER,

Other_Names VARCHAR2(25), Radius_km NUMBER, Mass_kg NUMBER,

CONSTRAINT mid_pk PRIMARY KEY (mid,id),

CONSTRAINT id_fk FOREIGN KEY(id) REFERENCES planet(id));

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Other_Names,

Radius_km, Mass_kg) VALUES ('Moon','I','III',384000,27.32,

'Luna',1738,73500000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Phobos','I ','IV',9000,0.32,

'Hall ',1877 ,11,10800000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Deimos','II','IV',23000,

1.26,'Hall',1877,6,1800000000000000);

INSERT INTO moon VALUES ('Metis','XVI','V',128000,0.29,'Synnott',1979,

'1979 J 3',20,95600000000000000);

INSERT INTO moon VALUES ('Adrastea','XV','V',129000,0.3,'Jewitt',1979,

'1979 J 1',10,19100000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Amalthea','V','V',181000,

0.5,'Barnard',1892,94,7170000000000000000);

INSERT INTO moon VALUES ('Thebe','XIV','V',222000,0.67,'Synnott',1979,

'1979 J 2',50,777000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Io','I','V',422000,

1.77,'Galileo',1610,1821,89300000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Europa','II','V',671000,

3.55,'Galileo',1610,1565,48000000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Ganymede','III','V',1070000,

7.15,'Galileo',1610,2634,148000000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Callisto','IV','V',1883000,

16.69,'Galileo',1610,2403,108000000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Leda','XIII','V',11094000,

238.72,'Kowal',1974,8,5680000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Himalia','VI','V',11480000,

250.57,'Perrine',1904,93,9560000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Lysithea','X','V',11720000,

259.22,'Nicholson',1938,18,77700000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Elara','VII','V',11737000,

259.65,'Perrine',1905,38,777000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Ananke','XII','V',21200000,

-631,'Nicholson',1951,15,38200000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Carme','XI','V',22600000,

-692,'Nicholson',1938,20,95600000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Pasiphae','VIII','V',23500000,

-735,'Melotte',1908, 25,191000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Sinope','IX','V',23700000,

-758,'Nicholson',1914,18,77700000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Pan','XVIII','VI',134000,

0.58,'Showalter',1990,'1981 S 13',10);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Atlas','XV','VI',138000,

0.6,'Terrile',1980,'1980 S 28',15);

INSERT INTO moon VALUES ('Prometheus','XVI','VI',139000,0.61,'Collins',1980,

'1980 S 27',46,270000000000000000);

INSERT INTO moon VALUES ('Pandora','XVII','VI',142000,0.63,'Collins',1980,

'1980 S 26',42,220000000000000000);

INSERT INTO moon VALUES ('Epimetheus','XI','VI',151000,0.69,'Walker',1980,

'1980 S 3',57,559000000000000000);

INSERT INTO moon VALUES ('Janus','X','VI',151000,0.69,'Dollfus',1966,

'1980 S 1',89,1980000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Mimas','I','VI',186000,

0.94,'Herschel',1789,199,37500000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Enceladus','II','VI',238000,

1.37,'Herschel',1789, 249,73000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Tethys','III','VI',295000,

1.89,'Cassini',1684,530,622000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Telesto','XIII','VI',295000,

1.89,'Smith',1980,'1980 S 13',15);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Calypso','XIV','VI',295000,

1.89,'Pascu',1980,'1980 S 25',13);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Dione','IV','VI',377000,

2.74,'Cassini',1684,560,1050000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Helene','XII','VI',377000,

2.74,'Laques',1980,'1980 S 6 .. Dione B',16);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Rhea','V','VI',527000,

4.52,'Cassini',1672,764,2310000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Titan','VI','VI',1222000,

15.95,'Huygens',1655,2575,135000000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Hyperion','VII','VI',1481000,

21.28,'Bond',1848,143,17700000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Iapetus','VIII','VI',3561000,

79.33,'Cassini',1671,718,1590000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Phoebe','IX','VI',12952000,

-550.48,'Pickering',1898,110,4000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Cordelia','VI','VII',50000,

0.34,'Voyager 2',1986,'1986 U 7',13);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Ophelia','VII','VII',54000,

0.38,'Voyager 2',1986,'1986 U 8',16);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Bianca','VIII','VII',59000,

0.43,'Voyager 2',1986,'1986 U 9',22);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Cressida','IX','VII',62000,

0.46,'Voyager 2',1986,'1986 U 3',33);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Desdemona','X','VII',63000,

0.47,'Voyager 2',1986,'1986 U 6',29);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Juliet','XI','VII',64000,

0.49,'Voyager 2',1986,'1986 U 2',42);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Portia','XII','VII',66000,

0.51,'Voyager 2',1986,'1986 U 1',55);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Rosalind','XIII','VII',70000,

0.56,'Voyager 2',1986,'1986 U 4',27);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Belinda','XIV','VII',75000,

0.62,'Voyager 2',1986,'1986 U 5',34);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Puck','XV','VII',86000,

0.76,'Voyager 2',1985,'1985 U 1',77);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Miranda','V','VII',130000,

1.41,'Kuiper',1948,236,65900000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Ariel','I','VII',191000,

2.52,'Lassell',1851,581,1350000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Umbriel','II','VII',266000,

4.14,'Lassell',1851,585,1170000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Titania','III','VII',436000,

8.71,'Herschel',1787,789,3530000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Oberon','IV','VII',583000,

13.46,'Herschel',1787,761,3010000000000000000000);

INSERT INTO moon VALUES ('Caliban','XVI','VII',7200000,

-930,'Gladman',1997,'1997 U 1',30,22);

INSERT INTO moon VALUES ('Sycorax','XVII','VII',12200000,

-1280,'Gladman',1997,'1997 U 2',60,20);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Naiad','III','VIII',48000,

0.29,'Voyager 2',1989,'1989 N 6',29);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Thalassa','IV','VIII',50000,

0.31,'Voyager 2',1989,'1989 N 5',40);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Despina','V','VIII',53000,

0.33,'Voyager 2',1989,'1989 N 3',74);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Galatea','VI','VIII',62000,

0.43,'Voyager 2',1989,'1989 N 4',79);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Larissa','VII','VIII',74000,

0.55,'Reitsema',1989,'1989 N 2',96);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Other_Names, Radius_km) VALUES ('Proteus','VIII','VIII',

118000,1.12,'Voyager 2',1989,'1989 N 1',209);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km, Mass_kg) VALUES ('Triton','I','VIII',355000,

-5.88,'Lassell',1846,1353,21500000000000000000000);

INSERT INTO moon (name, mid, id, Distance_km, Orb_Period_days, Discoverer,

Date_Disc, Radius_km) VALUES ('Nereid','II','VIII',5513000,360.13,

'Kuiper',1949,170);

INSERT INTO moon VALUES ('Charon','I','IX',20000,6.39,'Christy',1978,

'1978 P 1',586,1900000000000000000000);

</PRE>