EERD - EERD Semester Project PDF

Preview

Summary

EERD Semester Project...

Description

EERD Daimler Trucks (Frankisa Surani)

CUSTOMER Customer_ID (PK) Invoice_No. (FK) First_Name served_byLast_Name C_Street_Address C_City C_State/Province/Other C_Country C_Postal_Code C_Email_Address C_Phone_No

paid_by

pays

required_by CREDIT_PM CR_Card_No (PK) CR_Payment_ID (FK) CR_Card_Name CR_Card_Type CR_Expiration_Date CR_Payment_Amount CR_PM_Date

requires

placed_by communicated_by

INVOICE Invoice_No. (PK) VIN_No. (FK) Dealer_ID(FK) Transaction_Date Balance_Due Downpayment_Amount

communicated_to

places communicated_by

Cash?= "Y"

Payment Type:

o Check?= "Y"

CASH_PM Receipt_No. (PK) CA_Payment_ID (PK) CA_Amount CA_PM_Date

Debit?= "Y" communicated_by

communicated_to Trade_In?= "Y"

acquired_by communicated_by

sells sold_by

DAIMLER_TRUCKS Subsidiary_Company_Name (PK) Dealership_ID (FK) Customer_ID (FK) Invoice_No. (FK) VIN_No. (PK) Model_Name

Loan?= "Y"

DEBIT_PM D_Card_No (PK) D_Payment_ID (PK) D_Card_Name D_Card_Type D_Expiration_Date D_Payment_Amount D_PM_Date

Model_Name =

CHECK_PM CH_No. (PK) CH_Payment_ID (PK) CH_Amount CH_Bank_Name CH_Bank_Routing_No. CH_Account_No. CH_PM_Date

TRADE_IN_PM Trade_VIN_No. (PK) T_Payment_ID (PK) Make Model Year Trade_In_Amount Trade_In_PM_Date

LOAN_PM L_ID (PK) L_Payment_ID (PK) L_Amount L_PM_Date L_Bank_Name L_Street_Address L_City L_State/Province/Other L_Country L_Postal_Code L_Email_Address L_Phone_No

acquired_through

d

"Duonic"

"Cascadia" "Star_4900" FREIGHTLINER_CASCADIA FLC_VIN_No. (PK) FLC_Engine FLC_Color FLC_Performance FLC_Wheels FLC_Weight_Capacity FLC_Fuel_Economy FLC_Price

"5700XE"

"122SD"

WESTERN_STAR_4900 WS4_VIN_No. (PK) WS4_Engine WS4_Color WS4_Performance WS4_Wheels WS4_Weight_Capacity WS4_Fuel_Economy WS4_Price

FREIGHTLINER_122SD FLSD_VIN_No. (PK) FLSD_Engine FLSD_Color FLSD_Performance FLSD_Wheels FLSD_Weight_Capacity FLSD_Fuel_Economy FLSD_Price

WESTERN_STAR_5700XE WS5_VIN_No. (PK) WS5_Engine WS5_Color WS5_Performance WS5_Wheels WS5_Weight_Capacity WS5_Fuel_Economy WS5_Price

FUSO_CANTER_9C18_DUONIC FC_VIN_No. (PK) FC_Engine FC_Color FC_Performance FC_Wheels FC_Weight_Capacity FC_Fuel_Economy FC_Price

communicated_to

communicated_by

communicated_to

Credit?= "Y"

communicated_to

DEALERSHIP Dealership_ID (PK) VIN_No. (FK) Invoice_No. (FK) D_Street_Address D_City D_State/Province/Other D_Country serves D_Postal_Code D_Email_Address D_Phone_No. Business_Hours

DAIMLER_PAYMENT (PM) Payment_ID (PK) Invoice_No. (FK) Customer_ID (FK) Total_Amount Payment_Type(Credit?, Cash?, Debit?, Loan?, Trade_In?, Check?)...