The workshop is designed to help you anticipate possible questions, review what you've learned, and begin learning how to put your knowledge into practice.
1: | Name three types of data relationships. |
A1: | One-to-one, one-to-many, many-to-many. |
2: | Because many-to-many relationships are difficult to represent in an efficient database design, what should you do? |
A2: | Create a series of one-to-many relationships using intermediary mapping tables. |
Explain each of the three normal forms to a person who works with spreadsheets and flat tables.