data base access
Position
Employee`s Position ID
Position
Employee
Employee`s ID
Employee` Name
Employee` Position ID
Employee` Performance
Hire Date
Address
Cars
Car` ID
Car Brand
Bought Price
Bought Date
Mileage
Years
Color
Style
Order
Order ID
Car` ID
Employee` ID
Order Date
Sale Price
Buyer ID
Have Sales
Buyer Info
Buyer ID
Name
Address
Order ID
Buy
Have
Foreign Auto Connect ERD and Relational Schema
Aikelamu Alimujiang, Arthur Pan ERD
Position
Employee`s Position ID
Position
Order
Order ID
Car` ID
Employee` ID
Order Date
Sale Price
Buyer ID
Buyer Info
Buyer ID
Name
Address
Order ID
Cars
Car` ID
Car Brand
Bought Price
Bought Date
Mileage
Years
Color
Style
Employee
Employee`s ID
Employee` Name
Employee` Position ID
Employee` Performance
Hire Date
Address
Relational Schema