add this to sql information Database Structure

The following tables should already represent the structure of your RetailSales database.

Database: Retail Sales

Table: Ottawa.Customers Table: Ottawa.Suppliers

Column Name Character Type Max Characters Column Name Character Type Max Characters

CUSTOMERID int $($PK$)$ SUPPLIERID int $($PK$)$

FIRSTNAME varchar $100$ SUPPLIERNAME varchar $100$

LASTNAME varchar $100$ ADDRESS varchar $100$

ADDRESS varchar $100$ CITY varchar $100$

CITY varchar $100$ PROVINCE varchar $100$

PROVINCE varchar $100$ POSTALCODE varchar $100$

PHONENUMBER varchar $100$ PHONENUMBER varchar $100$

Table: Ottawa.Products Table: Transactions

Column Name Character Type Max Characters Column Name Character Type Max Characters

PRODUCTID int $($PK$)$ TRANSNUM int $($PK$)$

DESCRIPTION varchar $255$ PRODUCTID int $($FK$)$

COST money CUSTOMERID int $($FK$)$

RETAILPRICE money RETAILPRICE money

SUPPLIERID int $($FK$)$ QUANTITY int

Table Information:

Add the following information into the tables.

Customers Table

CustomerID: $120$

FirstName: Henriette

LastName: Samuel

Address: $120$ Kings Cross Lane

City: Marionette

Province: QC

PostalCode: R$5$T $6$N$8$

PhoneNumber: $611-556-9852$

CustomerID: $121$

FirstName: Rosina

LastName: Strinati

Address: $121$ Hopkins Lane

City: Kingston

Province: ON

PostalCode: U$8$Y $9$L$1$

PhoneNumber: $545-556-9866$

CustomerID: $122$

FirstName: Fillipo

LastName: Candreva

Address: $52$ Ferrari Drive

City: Folliero

Province: BC

PostalCode: Y$9$K $8$K$0$

PhoneNumber: $151-456-7855$

CustomerID: $123$

FirstName: Raffaele

LastName: Spina

Address: $12$ Gianni De Luca St

City: Vulcan

Province: AB

PostalCode: P$908$T$3$

PhoneNumber: $611-556-9852$

Suppliers Table

SupplierID: $779562$

SupplierName: Multimicro Inc

Address: $29$ Multimicro Way

City: Laval

Province: QC

PostalCode: U$8$P $0$Y$7$

PhoneNumber: $819-966-3579$ SupplierID: $688559$

SupplierName: ChrisCo

Address: $73$ Wild Goose Road

City: WaWa

Province: ON

PostalCode: P$0$S $0$A$2$

PhoneNumber: $552-669-9866$

Products Table

ProductID: $6689995$

Description: Logitech Ergo K$860$

Cost: $101\mathrm{.}10$

RetailPrice $150\mathrm{.}00$

SupplierID $779562$

ProductID: $6685585$

Description: High Speed $4$K HDMI Cable, $25$ft

Cost: $12\mathrm{.}00$

RetailPrice $19\mathrm{.}99$

SupplierID $779562$

Transactions Table

TransNum: $55487766$

CustomerID: $122$

ProductID: $6689995$

RetailPrice: $150\mathrm{.}00$

Quantity: $5$

TransNum: $382746$

CustomerID: $122$

ProductID: $6689995$

RetailPrice: $179\mathrm{.}00$

Quantity: $3$