Design a database diagram that allows students to be assigned study-group membership for one or more courses.
Question:
Design a database diagram that allows students to be assigned study-group membership for one or more courses. Each course can have any number of students and each student can be in any number of courses. You can create additional tables and columns, if necessary. Indicate the relationships between tables and identify the primary key and foreign key in each table. Explain your decisions and your final design.
b) Modify your design for part a to keep track of the assignment for each student in each course. Each student can be given multiple assignments in each course. Each course has a unique set of assignments for the students to complete. you can create additional tables and columns if necessary. Indicate the relationships between tables and identify the primary key and foreign key in each table. Explain your decisions and your final design.
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart