Overview
This week will complete the next unit of Dr. Chuck's PostgreSQL course.
Goals for Week 10
Complete each of the following:
- Watch all the videos in Data Relationships.
- Take notes. We will have a quiz on this unit when you arrive in class on Monday. You will be permitted to use paper notes while taking this quiz.
A Look at Real World Database Schema
After finishing watching all of Dr. Chuck's unit 2 videos yesterday, I started thinking about the project I want to do next week involving many-to-many relationships.
I want to create a database for
Beatles's songs. I did a web search on song track database fields
,
which lead me to
MusicBrainz
Database / Schema. Poke around in here to get a feel for what a real world
database schema looks like.