Homework
Consider the following potential schema for a group membership database for a church or other organization:
member(memberID, firstName, lastName, street, city, state, zipcode, groupTitle, groupTime, groupTopic)Here, the member lives at an address with other family members, all of whom tend to also be members of the organization. Members may participate in any number of groups. Do the following exercises for this schema:
- Do you see any potential data redundancy here? If so, give 1 or 2 examples.
- What are the functional dependencies? List them in the form A -> B, C, meaning A functionally determines B and C.
- Is this schema in BCNF? If so, explain why, if not, decompose it so that it is.
Personal Database Project
Create a BCNF database schema for your chosen semester project and build a corresponding Access database file for it. Include 5-6 sample records in each table. There are no hard-and-fast rules as to how complicated or large your database should be, but you should have at least three tables, at least one 1-m relationship and at least one m-m relationship.
What to turn in
Use Knightvision to submit your solution. Attach a Word document for the homework and an Access document for the PDP solution.
Back to the top
