I'm trying to define the relationships for a small Access database. The information is attached in the PDF. What would the relationship chart look like?
I'm trying to define the relationships for a small Access database. The information is attached in the PDF. What would the relationship chart look like?
You need to explain the relationships. We don't know anything about your project.
For instance, Students and faculty:
If one faculty can have many students AND One student can have one faculty
therefore one to many relationship.
If one faculty can have many students AND one student can have many faculty
therefore many to many relationship and need to have a junction table.
It looks like the related fields are text fields (ex. Student.StdID related to Grade.StdID). While you can do this, it is not recommended because it is slow. It is better to use numeric fields, preferably Long Integers. (% of my tables have an autonumber field as the PK and a long integer as the FK in the related table).
BTW, an autonumber is just to identify a unique record, it does not have any meaning.
You have as primary keys (it looks like):
Faculty.ID
Grade.ID
Offer.ID
Course.ID
Gets confusing which ID is being used....
Better would be:
Faculty.FacultyID
Grade.GradeID
Offer.OfferID
Course.CourseID
(I would have these as autonumbers)
Or maybe:
Faculty.F_ID
Grade.G_ID
Offer.O_ID
Course.C_ID
Just so there are not a lot of fields in different tables with the same name.
My convention is to use "_PK" and "_FK" suffixes:
Student.StdID_PK is related to Grade.StdID_FK
Sooooo, that is my $0.02