Advertisement
BojidarDosev

ez2

Nov 10th, 2021
1,558
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.45 KB | None | 0 0
  1. CREATE TABLE Employees (EmployeeID INTEGER PRIMARY KEY autoincrement,Name text, DateOfBirth text, AddressID INTEGER, Salary REAL, DepartmentID INTEGER, Occupation text, Manager INTEGER);
  2. CREATE TABLE Departments( DepartmentID INTEGER PRIMARY KEY autoincrement, DepartmentName text);  
  3. CREATE TABLE Cities( CityID INTEGER PRIMARY KEY autoincrement, CityName text);  
  4. CREATE TABLE Adress(AdressID INTEGER PRIMARY KEY autoincrement, Text text, CityID INTEGER);
  5.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement