Please use SQLiteStudio to showcase the work

Requirements: 1. Select one of the cases from the pool in this document. 2. Study the business scenario and make necessary assumptions. 3. Plan for core features to be supported. 4. Design a database for the data model. 5. Prepare test data and produce test results. 6. Furnish a technical report stating: business needs database design test results assumptions and limitations conclusion . . The College has five well-equipped computer laboratories for lectures and practical exercises. Fixed 90-minute time slots are allocated on daily basis to each of the laboratories. Time slots that have not been allocated to lectures are available for booking. A database is to be created to handle the booking of these resources. Community College Booking Form Office use only Available Date Time Slot Computer Laboratory KMC2307 7 Mar No 7 Mar KMC2307 D Yes Requested by Howard Chu Contact number 9003 0688 Computer laboratories and time slots Computer Laboratory Time Slot KMC0608 A 08:30-10:00 Time Slot E 14:30-16:00 KMC0609 B 10:00-11:30 F 16:00-17:30 KMC2306 11:30-13:00 G 17:30-19:00 KMC2307 D 13:00-14:30 KMC2308 Mondays to Fridays only * sample data for illustration only Additional information: All booking requests are handled on first come first served basis. Entries in a single booking form are handled individually. College office will check availability before confirming a request. If students find difficulties to book a time slot, priority may be set in future. . Assumptions: College office will reserve time slots for all scheduled lectures before the commencement of a semester. No time slot is shared by two or more booking requests. Requirements: 1. Select one of the cases from the pool in this document. 2. Study the business scenario and make necessary assumptions. 3. Plan for core features to be supported. 4. Design a database for the data model. 5. Prepare test data and produce test results. 6. Furnish a technical report stating: business needs database design test results assumptions and limitations conclusion . . The College has five well-equipped computer laboratories for lectures and practical exercises. Fixed 90-minute time slots are allocated on daily basis to each of the laboratories. Time slots that have not been allocated to lectures are available for booking. A database is to be created to handle the booking of these resources. Community College Booking Form Office use only Available Date Time Slot Computer Laboratory KMC2307 7 Mar No 7 Mar KMC2307 D Yes Requested by Howard Chu Contact number 9003 0688 Computer laboratories and time slots Computer Laboratory Time Slot KMC0608 A 08:30-10:00 Time Slot E 14:30-16:00 KMC0609 B 10:00-11:30 F 16:00-17:30 KMC2306 11:30-13:00 G 17:30-19:00 KMC2307 D 13:00-14:30 KMC2308 Mondays to Fridays only * sample data for illustration only Additional information: All booking requests are handled on first come first served basis. Entries in a single booking form are handled individually. College office will check availability before confirming a request. If students find difficulties to book a time slot, priority may be set in future. . Assumptions: College office will reserve time slots for all scheduled lectures before the commencement of a semester. No time slot is shared by two or more booking requests