Quick simple DB question!

[K1LLSW1TCH]

Hello peeps, well, It's 25 past 8 and I have to get this done by nine. What I have, is a simple Database diagram question but I haven't the first clue about it and the lecturer is going to put my ***** in a vice if I don't at least attempt this question. So what I was asking was if somebody could just tell me what the entities should be, and what should relate to what for the following question. Any help is greatly, greatly appreciated. Cheers in advance and here's the question:

Students take one or more, full-time or part-time
courses. The courses are run by departments and it is possible for a course to be run by
more than one department. Each course consists of a number of units. Lecturers teach
the units, and in some circumstances more than one lecturer will teach a unit. Lecturers,
of course teach on more than one unit. Since the introduction of 'modular' courses, it is
possible for one unit to be included on more than one course. A lecturer may be a course
leader for a particular course.

 

[K1LLSW1TCH]

Cheers for the reply. I'm appreciative that you gave it a go for me but I think my lecturer is after something specific called a relational diagram or something, I can't quite remember the name because I've only had 2 lectures on it.

As long as I've got something to whack down on some paper then that's cool so thanks for the reply. Oh and just so everyone knows I'm not a total retard, I'll tell the lecturer that I don't know what the hell I'm doing so maybe I can get a better understanding on the subject.

Thanks mate.

 

[K1LLSW1TCH]

Again, thanks for the reply. I know what I have to do, I just don't know what the entities will be, what the keys should be, the primary keys, the foreign keys, the fields and the relations.

I've had a bash on paper but I know it's completely wrong because Access can't do many to many relationships.