Search⌘ K
AI Features

Appendix A

Explore the car_crash DataMart schema to understand its star schema design and the role of each table within Azure Data Studio. Learn how core tables like D_CONTRIBUTING, D_DATE, D_LOCATION, D_TIME, D_VEHICLE, and F_COLLISIONS relate to one another, enhancing your ability to work with sample data and queries in this environment.

Understanding the car_crash DataMart

This appendix provides a quick reference for the course’s sample database and should help the reader understand the schema of the DataMart used in our sample queries.

Sample data

The following image shows the tables in our ...