Educational CourseBook Database Relationships

[jason73503]

Greetings,

I'm trying to develop a database for data-entry of Course Books used by our institutions and related materials and vocabulary for each unit within the Course Books.

I would like your insights of Database Normalization Theory to see if this approach is the most effective as I am experiencing difficulty in entering data into my main data-entry form "frmBookDetails"

The basic premise is to add a single Course Book under a "BookID" and that Book should have many related "Units".

Each "Unit" has many "Vocabulary" and "Materials" associated with them.

Within the "frmBookDetails" I would like to somehow relate the "Units" separately as in the attached img "qryBookUnits" so that I can move from one "Unit" record to the next within the main form.

 

[jdraw]

Further to Uncle Gizmo's comments/advice I recommend you write a brief description of your "business" in plain English. Keep it simple and business oriented --not quasi-database forms fields etc.
You know your business and readers don't, so clarity is key.

Also, a brief description of each of your identified tables may be helpful to you and readers.
For example, I'd like to hear more about your Vocabulary --not sure what it really represents.

 

[jason73503]

Thank you for your advice and recommendations. Let me try again here 

The user-group for this database application is for teachers and administrators at a school of foreign languages.
The basic premise is to build a database of materials that we use for different levels and courses, and each level and course uses a different book. Much like the following example:

A1 (Basic) Grammar // CourseBook: MyGrammar 1
A1 (Basic) Reading // CourseBook: MyReading 1
B2 (Intermediate) Grammar // CourseBook: MyGrammar 2
B2 (Intermediate) Reading // CourseBook: MyReading 2
…etc.
Now for each CourseBook, there are many Units (or Chapters) along with Unit Names that I want to associate Materials to use in the class with. For example,
A1 Grammar // MyGrammar 1 // Unit: 1 // Unit Name: Grammar for Beginners
A1 Grammar // MyGrammar 1 // Unit: 2 // Unit Name: More Grammar for Beginners
…etc.
As said above, one of the main purposes of this database is to associate Materials to the different Units within each CourseBook. For example:
A1 Grammar // MyGrammar 1 // Unit: 1 // Unit Name: Grammar for Beginners // Material: Activity 1
A1 Grammar // MyGrammar 1 // Unit: 1 // Unit Name: Grammar for Beginners // Material: Activity 2
A1 Grammar // MyGrammar 1 // Unit: 2 // Unit Name: More Grammar for Beginners // Material: Act 1
A1 Grammar // MyGrammar 1 // Unit: 2 // Unit Name: More Grammar for Beginners // Material: Act 2
…etc.
Lastly, as an additional bonus . Each unit generally has anywhere between 8-10 Vocabulary words that the students must learn (memorize). So I also want to associate many Vocabulary words to each Unit as well.
I suppose my question is whether my relationships match the above criteria. I believe I have achieved my basic desire in a possible round-about way according to my queries and current structures, but I’m not sure if it’s completely optimized and/or normalized. Granted, I might have gotten ahead of myself in my determination to get it working during my learning curve, but I hope you guys can give me further my understanding of good relationships.

The database is too large to upload, but if you want to review it (please do) it's available at the following link:

h.t.t.p.s://drive.google.com/open?id=0B-juuORLTO4kU05zNUlBVkJWLUE