USE CROWS FOOT NOTATION SET

3. (2 pts) Draw the ERD for the following scenario. The only attribute that you MUST include is the identifier. Be careful with your cardinality and don't forget optionality. Uber, the ride sharing service needs to be able to monitor their drivers and the vehicle they are driving. Uber allows a driver to register and drive many different vehicles. They also allow a vehicle to be driven by many different drivers. Place you ER diagram image below: 4. (4 pts) The order entry form problem. This is a Classic - you need to learn this one. ABC is a small business that sells clothing products online. Develop an ER diagram depicts the sales transaction. For example, a customer buys several different clothing items as depicted in the invoice below. Be sure to include entities and their relationships. Indicate weak entities and show cardinality. Again, be reasonable in the attribute listing you provide but be sure to show the identifier. This is the classic order form data model. Don't forget you can use the lecture notes for reference - page 98 and 152 in the eText examples of this classic product purchase order scenario. [Hint: You should end up with 3 tables if you identify a M:M relationship in your model or 4 tables if you don't.] Place your ER diagram image below