CREATE TABLE Items
(LocalId  INT IDENTITY(1, 1),
 GuidId   UNIQUEIDENTIFIER,
 ItmDescr NVARCHAR(50)
);
CREATE TABLE Clients
(LocalId   INT IDENTITY(1, 1),
 GuidId    UNIQUEIDENTIFIER,
 FirstName NVARCHAR(50),
 LastNaem  NVARCHAR(50),
 BirthDate DATETIME,
 CityGuid  UNIQUEIDENTIFIER
);
CREATE TABLE Cities
(LocalId  INT IDENTITY(1, 1),
 GuidId   UNIQUEIDENTIFIER,
 CityName NVARCHAR(50)
);
CREATE TABLE Sales
(LocalId    INT IDENTITY(1, 1),
 GuidId     UNIQUEIDENTIFIER,
 ClientGuid UNIQUEIDENTIFIER,
 ItemGuid   UNIQUEIDENTIFIER,
 Quantity   INT,
 SaleDate   DATETIME
);