database

Set Relationships Between Tables in Access $$ Question Set

$1-$Creating One$-$to$-$Many Relationships In Microsoft Access, if you have two tables: Customers $($CustomerID$)$ and Orders $($OrderID$,$ CustomerID$),$ how would you set a one$-$to$-$many relationship between them?

$2-$Creating Many$-$to$-$Many Relationships

$$ A$)$ How do you handle a many$-$to$-$many relationship between two tables $($for example, Products and Categories$)$ in Access? What additional table is required, and what fields would it contain?

$$ B$)$ You have two tables: Students and Courses. A student can enroll in multiple courses, and a course can have many students. What is the best way to model this many$-$to$-$many relationship in Access?