Create an ER Diagarm for this relationship
On diagram identify Pk,Ak,FK etc
Employee(Employee_id,Employee_name,Employee_address,Emloyee_birthdate,Employee_phoneNo,Employee_Schedule,Emloyee_type)
Warehouse (Warehouse_id,employee_type)
Rent-a-ride (location_id,employee_type)
Corporate (department,employee_type)
Order (order_id,order time,order date,order total,,order shipdate,warehouse_ID,rental_id)
Rental (Rental_id,rental start date,rental end date,location_id,vid)
Vehicle (Vid,vehice make,vehicle model,vehicle year,vehiclecolor,vehicle milage,vehicle loation,vehicle class)
Supplier (Supplier_id,supplier name, supplier address, supplierphoneno)
Product (Product_id,product description,unit price,supplierid)
Shopper (sid, sname, saddress order_id,)
Renter (rid, rname, raddress, account tier,vid)
Expert Answer
An answer will be send to you shortly. . . . .