CREATE TABLE Buyer
(
BuyerID numeric(10) PRIMARY KEY,
LastName varchar(50),
FirstName varchar(50),
);

CREATE TABLE Orders
(
OrderID numeric(10),
BuyerID numeric(10) REFERENCES Buyer(BuyerID),
OrderDate varchar(10),
PRIMARY KEY(OrderID, BuyerID)
);

CREATE TABLE Merchandise
(
MerchandiseID numeric(10) PRIMARY KEY,
Name varchar(50),
Price money
);

CREATE TABLE OrderItem
(
OrderID numeric(10),
MerchandiseID numeric(10),
Quantity numeric(10),
CONSTRAINT OrderItem_pk PRIMARY KEY (OrderID,MerchandiseID),
CONSTRAINT order_fk FOREIGN KEY (OrderID) REFERENCES Orders,
CONSTRAINT merchandise_fk FOREIGN KEY (MerchandiseID) REFERENCES Merchandise
);