Question: How do I convert this entity relationship diagram to the second normal form? USER CREDIT_CARD 04 PK Card number Exp_date HT PK Username Password First_name
How do I convert this entity relationship diagram to the second normal form?

USER CREDIT_CARD 04 PK Card number Exp_date HT PK Username Password First_name Last_name Email Phone_number 11 RECOMMEND PK Username REVIEW PK Review ID FK1 |Username FK2 Restaurant_ID Timestamp Review Rating PK Restaurant ID Recommendation RESTAURANT PK Restaurant ID Name # It RESERVATION COMPANY PK Reservation ID FK1 Username + PK Company name Description FK2 Restaurant_ID Start_timestamp End_timestamp Party_size Description Menu Listed_hours Status Street Zip Cuisine_type Restaurant_type Restaurant type = "FC" "TO" O "SD" FOOD_CART SIT_DOWN Capacity TAKE OUT Max_wait_time License
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
