In the Reservation table below, a room may be reserved sever…

In the Reservation table below, a room may be reserved several times, so the RoomNumber column is not unique. To ensure that a room can only be reserved by only one guest for the day, the minimal primary key consists of which columns? Reservation RoomNumber DateOfStay Guest ModeOfPayment 201 2020-01-10 Guest A cash  202 2020-01-15 Guest B cash 203 2020-01-18 Guest C credit card 204 2020-01-18 Guest D credit card 205 2020-01-19 Guest D credit card 206 2020-01-21 Guest E cash  

Refer to the Supplier table. Which statement correctly chang…

Refer to the Supplier table. Which statement correctly changes Adan Stevens to Maria Stevens? Supplier Table SupplierID CompanyName ContactName CountryID 2 Oshkosh Bgosh Martina Perry 2 3 LittleGuppies Cierra Martinez 1 4 Sugarplum Miranda Adams 2 5 Rosebuds for Girls Adan Stevens 2 6 Lin Ming Co. Linda Ming 3 7 Periwinkle  Sarah Gomez 2