Introduction
Next week we will build our database in a popular database management system, but before we get there, it’s important you understand what is happening in SQL. Every database system is slightly different, so if you have a strong understanding of the underlying concepts, it becomes easier for you to troubleshoot between different databases.
Note: While we are learning about joins and unions, you do not use those when creating a database. They are used for building reports and querying the database, which we will learn practice in future units.
Directions
Test the dataset you have selected to build the database for your assignments using Microsoft Access
The process is to import your datasets into Access to test and make sure it is ready for SQL.
Submit the .ACCDB file for grading.