FamousPeople

CREATE TABLE Celebretiers (CelebretyID INTEGER PRIMARY KEY AUTOINCREMENT,Name TEXT,DateOfBirth TEXT, 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");

CREATE TABLE City (CityID INTEGER PRIMARY KEY AUTOINCREMENT, CityName TEXT, CountryID INTEGER);
INSERT INTO City (CityName, CountryID) VALUES ("Detroit",1);

INSERT INTO Celebretiers (Name, DateOfBirth, CityID, salary, ProfessionID, Creation, ReleaseDate) VALUES ("Eminem","1972-17-10",1,800000,2,"Not Afraid","2010-05-06");
SELECT * FROM Celebretiers;