Database description contain four tables of database and schema.

[RamiNaama]

@omaranBazna I added a docx file containing the database description and the tables that we may need for the system. Also, there are schema picture.

[omaranBazna]

@RamiNaama I have some questions : 1-What do you mean by CHECKBOX List type, is there any type like this in SQL types? 2-For the availability table, you highlight the last column, I see what you mean by it the idea is the professor won't add availability for the availability table if he is not available at this time 3- did you need to add a column availability type (in-person - online) for the availability table?

Thanks

[omaranBazna]

@RamiNaama When the professor adds availability, he should provide two time slots, because each course is most likely taught twice a week, and if the course has a lab the professor should provide availability to the lab, so the single availability row should have ( slot1 ,slot1_type, slot2, slot2_type , lab_slot ,lab_slot_type)

[RamiNaama]

@RamiNaama I have some questions : 1-What do you mean by CHECKBOX List type, is there any type like this in SQL types? 2-For the availability table, you highlight the last column, I see what you mean by it the idea is the professor won't add availability for the availability table if he is not available at this time 3- did you need to add a column availability type (in-person - online) for the availability table?

Thanks

[RamiNaama]

@omaranBazna 1- My description was incorrect; my idea was to create a list with boolean values, but for now I have changed them to LIST type or even STRING. 2-"Is_Ava" binary dynamic variable will change its value each iteration, which is whether the Ava_ID can take a specific slot or not. 3- Need_Lab, Availability_Type, Is_Ava added to Availability table. Check please and let me know!

[RamiNaama]

Modified docx file, added shema picture.