SQL - Sprachentabelle #48

CREATE TABLE land (
LNR varchar(15)PRIMARY KEY  NOT NULL,
Name varchar(255) NOT NULL
);
CREATE TABLE sprache(
SprachID INT NOT NULL auto_increment,
Name varchar(255) NOT NULL,
PRIMARY KEY(SprachID)
);


CREATE TABLE laendersprache (
FOREIGN KEY (LNR) REFERENCES land(LNR) PRIMARY KEY,
FOREIGN KEY (SprachID) REFERENCES sprache(SprachID),
Anteil float(3,2)
);

INSERT INTO 
	land(LNR, Name)
VALUES
	('GER', 'Germany'),
	('CHE', 'Swiss'),
	('A', 'Austria');
	
INSERT INTO 
	sprache(Name)
VALUES
	('German'),
	('Italian'),
	('French');


INSERT INTO 
	laendersprache(Name, SprachID)
VALUES
	('GER', 1),
	('CHE', 1),
	('CHE', 2),
	('CHE', 3);