CREATE TABLE Student (
sid VARCHAR(10) NOT NULL PRIMARY KEY,
sname VARCHAR(80),
address VARCHAR(80)
) ENGINE=InnoDB;


CREATE TABLE Course (
cid VARCHAR(10) NOT NULL PRIMARY KEY,
cname VARCHAR(80),
teacher VARCHAR(80)
)ENGINE=InnoDB;


CREATE TABLE Signup (
sid VARCHAR(10) NOT NULL,
cid VARCHAR(10) NOT NULL,
PRIMARY KEY (sid,cid),
FOREIGN KEY (sid) REFERENCES Student(sid),
FOREIGN KEY (cid) REFERENCES Course(cid)
)ENGINE=InnoDB;




INSERT INTO Student (sname, sid, address) VALUES ('Ole Olesen', 'L1234', 'Hjemmevej 7'),
						('Rikke Richardsen', 'L2345', 'Udvej 9'),
						('Søren Sørensen', 'J0007', 'I dybet 13'),
						('Ulrikka Funder', 'B7117', 'Skovvej 11'),
						('Niels Bohr', 'nbi', 'Blegdamsvej'),
						('H.C. Ørsted', 'HCØ', 'Rudkøbing apotek'),
						('Issac Newton','in', 'London');
						


INSERT INTO Course (cid, cname, teacher) VALUES ('W2', 'Web Publishing with Databases', 'Martin Elsman'),
						('GP', 'Introduction to Programming', 'Morten Rhiger'),
						('XML', 'XML Processing', 'Thomas Hildebrandt'),
						('Dat0', 'Funktionsprogrammering med SML', 'Nils Andersen'),
						('Dat1F', 'Multiprogrammering', 'VIPer fra DISTLAB');
						





INSERT INTO Signup (sid, cid) VALUES 	('L1234', 'W2'),
					('L2345', 'W2'),
					('J0007', 'W2'),
					('J0007', 'GP'),
					('L2345', 'GP'),
					('nbi','W2'),
					('L1234','Dat0'),
					('HCØ','GP'),
					('in','W2'),
					('L2345','Dat1F');