Reference no: EM133574199
Assignment: SQL
Introduction
Now that you have a grasp of SQL, let's start to get familiar with a database! Make sure you review the overviews of a variety of database platforms. For this course, we will work with Microsoft SQL Server. In the real world, remember, it's all about the right tool for the right job. Microsoft SQL was chosen for this class because it is well-known in the field, and provides a good foundational understanding of databases with a management tool that is GUI based. (Read more about the Top 10 Databases to Use in 2021).
Directions
I. Download Microsoft Access
II. Use your tables to build your relationships. Refer to the Lecture Video (Panopto) for help.
III. Once your relationship is built, review the ERD Diagram inside Access.
IV. If it is different than your original diagram, write a no more than 1-page summary of what has changed and why.
V. Think about what data is missing from your database, and add one additional source to your design if needed.
Reflect on what has changed during the creation of your datasets.