In the music school asignments
1)If one teacher can teach in multiple courses?
2)do i need to keep track of capacity or any course?
3)if capacity needs to be tracked is it a good idea to put it in course table or to create a seprate table somthing like room
sir,after creating a access file when i move that access file to another storage location and open that file its completely blank,showing no previous data.can you please tell me the reason and how to avoid that and is it possible to get previous data back.
I tried to solve your questions-
1)Yes one teacher can each multiple courses
2)You do not need to track the capacity of the courses necessarily but if you wish you can,
3)Yes this will be a good idea if you create a table named class_room.That will give you the details of the class location and the capacity.
Hope this will help and if you still have any problem please feel free to discuess.