text: CREATE TABLE ItemTypes(
  ItemTypeID INT PRIMARY KEY IDENTITY,
  [Name] VARCHAR(50) 
  )
  
  CREATE TABLE Items(
  ItemID INT PRIMARY KEY IDENTITY,
  [Name] VARCHAR(50),
  ItemTypeID INT NOT NULL
  
  CONSTRAINT FK_ItemTypeID_ItemTypes FOREIGN KEY (ItemTypeID) REFERENCES ItemTypes(ItemTypeID)
  )
  
  CREATE TABLE Cities(
  CityID INT PRIMARY KEY IDENTITY,
  [Name] VARCHAR(50) 
  )
  
  CREATE TABLE Customers(
  CustomerID INT PRIMARY KEY IDENTITY,
  [Name] VARCHAR(50),
  Birthday DATETIME2,
  CityID INT,
  
  CONSTRAINT FK_CityID_Cities FOREIGN KEY (CityID) REFERENCES Cities(CityID)
  )
  
  CREATE TABLE Orders(
  OrderID INT PRIMARY KEY IDENTITY,
  CustomerID INT,
  
  CONSTRAINT FK_CustomerID_Customers FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
  )
  
  CREATE TABLE OrderItems(
  OrderID INT NOT NULL,
  ItemID INT NOT NULL,
  
  CONSTRAINT PK_OrderID_ItemID PRIMARY KEY(OrderID, ItemID),
  CONSTRAINT FK_OrderID FOREIGN KEY (OrderID) REFERENCES Orders(OrderID),
  CONSTRAINT FK_ItemID FOREIGN KEY (ItemID) REFERENCES Items(ItemID)
  )