Design a database diagram that allows individuals to be assigned membership in one or more groups. Each group can have any number of individuals and each individual can belong to any number of groups. Create additional tables and columns, if necessary. Explain your design decisions. (Draw the diagram in Visio and copy drawing into a word document)
I don't understand what the question is asking can someone please explain?
It's not so much a question as an assignment and the instructions are quite clear. Please post the specific phrase that you don't understand.
Do you get these parts? - design a database diagram using Visio. - Create all the objects necessary to satisfy the requirements - explain the design choices - copy the finished design into a word document
It does mean make up your own scenario. The details are up to you but the key points are: - The Entities: (individual and group) - The relationship between these entities (0,1,or many individuals per group - and 0,1,or many groups per individual)
Life is full of these types of relationships: authors and books citizens and committees people and pets homes and owners etc.
Your assignment is to pick two entities with a many-to-many relationship and model it as database objects. How many tables do you think you need for this?