HELLLOOO THE ATTRIBUTES AND ENTITIES ARE ALREADY PROVIDED, NO SQL PLS I JUST WANT TO SEE THE THIS IN AN ERD

Entities:

CUSTOMER$\_$T

CustomerID

CustomerName

CustomerStreet

CustomerCity

CustomerState

CustomerZip

CreditLimit

SalesRepID

ORDER$\_$T

OrderID

CustomerID

$($PK$)$

$($FK$)$ of EMPLOYEE$\_$T

$($PK$)$

$($FK$)$ of CUSTOMER$\_$T

CustomerPONumber $($This means the Customer Purchase Order Number$)$

OrderDate

DueDate

ShipDate

ORDER$\_$LINE$\_$T

OrderID

ProductID

OrderQuantity

composite $($PK$),($FK$)$ of ORDER$\_$T

composite $($PK$),($FK$)$ of PRODUCT$\_$T

PRODUCT$\_$T

ProductID

$($PK$)$

ProductDescription

UnitPrice

StockQuantity this is the amount of the product we have in our warehouse. It is not

provided in the data, so make up an arbitrary amount.

FABRICATED$\_$T

ProductID

PartID

PartQuantity

PRODUCT$\_$SUPPLIER$\_$T

ProducID

SupplierID

composite $($PK$),($FK$)$ of PRODUCT$\_$T$.$ProductID

composite$($PK$),($FK$)$ of PRODUCT$\_$T$.$ProductID

quantity of PartID that goes into ProductID $($example$,2$ tires

In one bicycle$)$

composite $($PK$),($FK$)$ of PRODUCT$\_$T

composite $($PK$),($FK$)$ of SUPPLIER$\_$T

VendorPartID this is the ID the Vendor $($i$.$e$.,$ Supplier$)$ uses in their system$),$ similar to

CustomerPONumber in the ORDER$\_$t$.$

ProductCost

this is the amount we paid the Vendor for the product

PurchasedQuantity

SUPPLIER$\_$T

SupplierID

SupplierName

SupplierStreet

SupplierCity

SupplierState

SupplierZip

EMPLOYEE$\_$T

EmployeeID

$($PK$)$

$($PK$)$

EmployeeFirstName

EmployeeLastName

EmployeeJobTitle

EmployeeStreet

EmployeeCity

EmployeeState

EmployeeZip

EmployeeHireDate

ManagerID

$($FK$)$ unary

EMPLOYEE$\_$COURSE$\_$T

EmployeeID

CourseID

composite $($PK$),($FK$)$ of EMPLOYEE$\_$T

composite $($PK$),($FK$)$ of COURSE$\_$T

CompletionDate

COURSE$\_$T

CourseID

$($PK$)$

CourseDescription

SALES$\_$REPRESENTATIVE$\_$T

EmployeeID

$($PK$),($FK$)$ of EMPLOYEE$\_$T

CommissionRate $($hint: only employees with commission rates should be added to this

table$).$