Solve This Due to an increase in the number of cases of covid, the Sindh government has decided to establish a centre in each city where patients can obtain vaccine. You must store information in a...

Solve This

Due to an increase in the number of cases of covid, the Sindh government has decided to establish a centre in each city where patients can obtain vaccine. You must store information in a database in such a way that patients receive vaccine bookings first, and then a room is reserved according to a specific schedule. A database schema includes the following tables: the heart (CenterNo, CenterName, city) a bed (roomNo, CenterNo, type) Waiting patiently (PatientID, PatientName, PatientAddress) Reservations (BookingID, PatientID, dateFrom, dateTo, roomNo) Where Center is the primary key, and CenterNo is the secondary key; Room is the secondary key, and (roomNo, Center No) is the primary key; Booking is the secondary key, and (BookingID, PatientID) is the primary key; Patient is the primary key, and PatientID is the secondary key.

2. For the above schema, create an ER diagram that depicts potential relationships between individuals.