Hi I am creating a database that will help monitor attendance at uni. We were given the following spec.
Each course is made up of a number of modules.
Students enrol in 6 modules.
Each module has a timetable which includes times of classes.
Class can be a lecture, tutorial or lab.
For each class type the date and time are to be held along with topic if it is a lecture, support staff available if lab and video conference if tutorial.
Roll is to be taken at each class to record which students attended.
I am new to object relational db schemas but so far i have created.
Student type - student#, name, address_obj, phone_var
Address type - street, city, county, postcode
Module type - mod#, name
Classes - class#, mod#, classtype, topic, supportstaff, videocon.
I have created tables aswell but not sure if I am on the right track with the types that I have created so far. Can someone have a look at the spec and let me know if the types ive created are correct or if more are needed? Or any advice at all would be much apprecated. Thanks in advance