How would these tables be shown/drawn in Erwin?
CUSTOMER_TABLE
CustomerID (PK)
CustomerName
CustomerStreet
CustomerCity
CustomerState
CustomerZip
CreditLine
SalesRepID (FK) of SALES_REP _TABLE
ORDER_TABLE
OrderID (PK)
CustomerID (FK) of CUSTOMER_TABLE
CustomerPO (This means the Customer Purchase Order Number)
OrderDt
DueDt
ShipDt
ORDER_LINE_TABLE
OrderID composite (PK), (FK) of ORDER_TABLE
ProductID composite (PK), (FK) of PRODUCT_TABLE
OrderQuantity
PRODUCT_TABLE
ProductID (PK)
ProductDescription
StockQuantity this is the amount of the product we have in ourwarehouse.
It’s not provided in the data, so make up an arbitrary amount.
PRICE_HISTORY_TABLE
ProductID Composite Primary Key
StartDt Composite Primary Key
EndDt
UnitPrice
FABRICATED_TABLE
ProductID composite (PK), (FK) of PRODUCT_TABLE.ProductID
PartID composite (PK), (FK) of PRODUCT_TABLE.ProductID
PartQuantity quantity of PartID that goes into ProductID (example,2 tires in one
bicycle)
PRODUCT_SUPPLIER_TABLE
ProducID composite (PK), (FK) of PRODUCT_TABLE
SupplierID composite (PK), (FK) of SUPPLIER_TABLE
VendorPartID this is the ID the Vendor (i.e., Supplier) uses intheir system),
similar to CustomerPO in the ORDER_TABLE.
ProductCost this is the amount we paid the Vendor for theproduct
PurchasedQuantity
SUPPLIER_TABLE
SupplierID (PK)
SupplierName
SupplierStreet
SupplierCity
SupplierState
SupplierZip
EMPLOYEE_TABLE
EmployeeID (PK)
EmpFirstName
EmpLastName
EmpJobTitle
EmpStreet
EmpCity
EmpState
EmpZip
EmpHireDate
ManagerID (FK) unary to EmployeeID
EMPLOYEE_COURSE_TABLE
EmployeeID composite (PK), (FK) of EMPLOYEE_TABLE
CourseID composite (PK), (FK) of COURSE_TABLE
CompletionDate
COURSE_TABLE
CourseID (PK)
CourseDescription
SALES_REPRESENTATIVE_TABLE
EmployeeID (PK), (FK) of EMPLOYEE_TABLE
CommissionRate (hint: only employees with commission rates shouldbe added to
this table).
Expert Answer
Answer to How would these tables be shown/drawn in Erwin? CUSTOMER_TABLE CustomerID (PK) CustomerName CustomerStreet CustomerCity …