You were just hired to create a database to record student club and honor society memberships at a university.
The following key points have been agreed:1 Each student is given a unique StudentID2 Each Assoc-Name is unique3 DOB is date of birth4 MaxMem is the maximum approved membership for an association5 The DataJoined field records the date a student became a member of the club or honor society6 Each student may belong to zero, one, or many associations, and each association may have zero, one, or many student members.7 No fields beyond those in the spreadsheet are needed.
The objective of this exercise is to demonstrate an understanding of some basic concepts covered in the course. The exercise is a straight forward application of those concepts there are no hidden complexities should you identify something in the key points or data that adds complexity, contact the instructor before submission you may be over thinking the exercise.
The sample data may not represent all possible values of each field consider the domain of values that may be used in the future as well as the below data.
Your objective is to replace the following report with a relational database. Your submission will consist of a word compatible document, and an Access DB.
