GarageDb.txt

CREATE TABLE Rent(Id INTEGER IDENTITY(1,1) 
PRIMARY KEY NOT NULL, Tax INTEGER, 
Description NVARCHAR(50), Date NVARCHAR(50));

CREATE TABLE Electricity(Id INTEGER IDENTITY(1,1) 
PRIMARY KEY NOT NULL, Tax INTEGER, 
Description NVARCHAR(50), Date NVARCHAR(50));

CREATE TABLE Parking(Id INTEGER IDENTITY(1,1) 
PRIMARY KEY NOT NULL, PlaceNumber INTEGER);

CREATE TABLE Owner(Id INTEGER IDENTITY(1,1) 
PRIMARY KEY NOT NULL, FirstName NVARCHAR(50), LastName NVARCHAR(50), Phone NVARCHAR(50));

CREATE TABLE Garage(Id INTEGER IDENTITY(1,1) 
PRIMARY KEY NOT NULL, Number INTEGER, Id_Owner INTEGER FOREIGN KEY 
(Id_Owner) REFERENCES Owner(Id));

CREATE TABLE Positions(Id INTEGER IDENTITY(1,1) 
PRIMARY KEY NOT NULL, Name NVARCHAR(50), Salary NVARCHAR(50));

CREATE TABLE Employee(Id INTEGER IDENTITY(1,1) 
PRIMARY KEY NOT NULL, FirstName NVARCHAR(50), LastName NVARCHAR(50), Id_Position INTEGER FOREIGN KEY 
(Id_Position) REFERENCES Positions(Id))

CREATE TABLE SalaryLog(Id INTEGER IDENTITY(1,1) 
PRIMARY KEY NOT NULL, Date NVARCHAR(50), Id_Employee INTEGER FOREIGN KEY 
(Id_Employee) REFERENCES Employee(Id))

CREATE TABLE RentLog(Id INTEGER IDENTITY(1,1) 
PRIMARY KEY NOT NULL, Id_Garage INTEGER FOREIGN KEY 
(Id_Garage) REFERENCES Garage(Id),  Id_Electricity INTEGER FOREIGN KEY 
(Id_Electricity) REFERENCES Electricity(Id), Id_Rent INTEGER FOREIGN KEY 
(Id_Rent) REFERENCES Rent(Id), ElectricityAmount INTEGER, RentAmount INTEGER, CounterValue INTEGER, Date NVARCHAR(50))

ALTER TABLE Employee ADD Login NVARCHAR(50), Password NVARCHAR(50);