Need Help With a Class

[Alaskanhawg]

I am in an Access Class and I am lost I need help understanding the project. See Below.

Assignment:
You are going to build tables for the following:-


You are about to model a small education institute with the following specs
there are 5 instructors, 8 courses, 3 classrooms, and 40 students

The relationships between them as follows;
Each instructor has one or more courses, each course will be taught in one or more classroom, each classroom will have one or more students, you need to relate the tables using primary/ foreign keys.Insert all required records (5 instructors, 8 courses, 3 classrooms, and 40 students)
in each table to demonstrate the relationships, also the student can take more than one course*** Rules
1) You must enter your name as one of the instructors
2) Each course is taught twice a week for 8 weeks
3) The student cannot be in more than one classroom at the same time** Be creative and simple, you can use more tables if needed such as enrollment or schedule

Can someone get me headed in the right direction please and Thank you for any help.

[orange]

see and workthrough http://www.rogersaccesslibrary.com/T...lationship.zip

[Alaskanhawg]

I still Can not figure out how to do this and my teacher is not being any help. I can email what i have if someone can help me. Thanks in advance

[Alaskanhawg]

Week 2 Database.zip Attached is what i have done so far.

[June7]

Regardless of teacher's competence, a decent tutorial reference should get you through the basics. And this exercise requires mostly elementary relational database concepts. Don't you have a textbook? The tutorials at Roger Carlson's site are good and there are many other sources.

However, consider:

tblStudents
StudentID
LastName
FirstName

tblCourses
CourseID
CourseName

tblInstructors
InstructorID
LastName
FirstName

tblClassrooms
RoomID
RoomNumber
BuildingNumber

tblSchedule
ScheduleID
CourseID
InstructorID
RoomID
StartDate
EndDate
MaxEnroll
ClassDays
ClassTime

tblEnrollment
StudentID
ScheduleID

EDIT: I see you posted as I was composing mine. Think your table relationships are not correct.

[Alaskanhawg]

June7,
Thank you for the quick response. I do have a text book and I have been trying to go off tutorials but the issue that i am running into is creating the schedule that will only allow a student in one class at a time. Are my relationships way off?

[June7]

Yes, I think the relationships are way, way off. Review the PK/FK fields in my suggested model. If you want to assume a single building then the classroom table could be a single field for the room number.

Making sure student is not enrolled in multiple classes at the same time could be a bit tricky and don't think can be managed by table structure alone, which is what you are trying to do with relationships. With the correct table structure, use queries and/or code to analyse student enrollment and prevent overlap. This would take place behind a form for data entry of student enrollment.

[Alaskanhawg]

Thank you. We have not done queries yet so its just tables and relationships so I guess manual entry is what i have to do for now. I will review your suggested model now. Thanks again

[June7]

If instructor expects the table structure to prevent class overlap, I am as lost as you. I am picturing my own enrollment for university classes. I query the website for list of courses and then pick the ones I want. If I goof and pick overlapping classes the site alerts me that I have registration error due to conflicting time and won't allow registering for the conflicting classes.