sql

CREATE TABLE Celebretiers (CelebretyID INTEGER PRIMARY KEY AUTOINCREMENT,Name TEXT,DateOfBirth TEXT,CountryID INTEGER, CITYID INTEGER, Salary REAL, ProfessionID INTEGER, Creation TEXT, ReleaseDate TEXT);

CREATE TABLE Profession (ProfessionID INTEGER PRIMARY KEY AUTOINCREMENT, ProfessionName TEXT);
INSERT INTO Profession (ProfessionName) VALUES ("Actor");
INSERT INTO Profession (ProfessionName) VALUES ("Singer");
INSERT INTO Profession (ProfessionName) VALUES ("Writer");
INSERT INTO Profession (ProfessionName) VALUES ("Character");

CREATE TABLE Country (CountryID INTEGER PRIMARY KEY AUTOINCREMENT, CountryName TEXT);
INSERT INTO Country (CountryName) VALUES ("USA");
INSERT INTO Country (CountryName) VALUES ("France");
INSERT INTO Country (CountryName) VALUES ("UK");

CREATE TABLE City (CityID INTEGER PRIMARY KEY AUTOINCREMENT, CityName TEXT, CountryID INTEGER);
INSERT INTO City (CityName, CountryID) VALUES ("Detroit",1);
INSERT INTO City (CityName, CountryID) VALUES ("New York",1);
INSERT INTO City (CityName, CountryID) VALUES ("Besanson",2);
INSERT INTO City (CityName, CountryID) VALUES ("Yate",3);
INSERT INTO City (CityName, CountryID) VALUES ("Stanford",3);
INSERT INTO City (CityName, CountryID) VALUES ("Miami",1);
INSERT INTO City (CityName, CountryID) VALUES ("Jersey",1);
INSERT INTO City (CityName, CountryID) VALUES ("Wisconsin",1);

INSERT INTO Celebretiers (Name, DateOfBirth,CountryID,CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("Eminem","1972-17-10",1,1,800000,2,"Not Afraid",2010);
INSERT INTO Celebretiers (Name, DateOfBirth, CountryID,CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("50cent","1975-06-07",1,2,185000,2,"In Da Club",2003);
INSERT INTO Celebretiers (Name, DateOfBirth, CountryID,CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("DMX","1970-18-12",1,2,160000,2,"Party Up",1999);

INSERT INTO Celebretiers (Name, DateOfBirth, CountryID,CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("Viktor Ugo","1802-26-02",2,3,NULL,3,"The Man Who Laughs",1869);
INSERT INTO Celebretiers (Name, DateOfBirth, CountryID,CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("J. K. Rowling","1965-31-06",3,4,6000000,3,"Harry Potter",1997);
INSERT INTO Celebretiers (Name, DateOfBirth, CountryID,CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("William Shakespeare","1564-23-04",3,5,NULL,3,"Hamlet",1603);

INSERT INTO Celebretiers (Name, DateOfBirth, CountryID,CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("Superman","1995-13-01",1,1,5000000,4,NULL,NULL);
INSERT INTO Celebretiers (Name, DateOfBirth, CountryID,CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("Iron Man","1970-03-10",1,2,10000000,4,NULL,NULL);
INSERT INTO Celebretiers (Name, DateOfBirth, CountryID,CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("Hulk","1995-13-01",1,6,100,4,NULL,NULL);

INSERT INTO Celebretiers (Name, DateOfBirth, CountryID,CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("Henry Kavil","1983-05-05",1,7,1000000000,1,"Superman",1978);
INSERT INTO Celebretiers (Name, DateOfBirth, CountryID,CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("Robert Junior","1965-04-04",1,2,100000000,1,"Iron Man",2008);
INSERT INTO Celebretiers (Name, DateOfBirth, CountryID,CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("Mark Raffalo","1967-22-11",1,8,1700000,1,NULL,NULL);

SELECT * FROM Celebretiers;