Does my ERD look ok?

[jpanther36]

week5 ERD - zip.zip

Hello everyone,


I am new to MS access, as you can tell from my ERD. Can anyone just take a look at my ERD and give me some pointers on how I could improve? I don't have Visio or some other software that would make my diagram look better, so I had to use MS Word. Any help would be greatly appreciated. Thank you.

[CJ_London]

interpreting this it is saying to me


A student has one advisor and one major and can be in many classes
each class can have many sections
each faculty has many qualified
each qualified has many sections

I would be consistent with your naming convention (PK/FK or ID) but is a matter of personal preference. Description is a reserved word and also used in a number of your tables. suggest change these to something more meaningful such as MajorDesc, ClassDesc etc

the two fields in enrolment need to be individually indexed (dups OK) and jointly indexed (no dups) to ensure a student can't enrol twice for the same class. Custom would also be to include a primary key field although you can use the no dups index as a primary key. much discussion online as to which is more efficient

Whether is describes your business and processes clearly enough is down to you!