Posts

Showing posts from September, 2026
Image
 This image is an Entity-Relationship Diagram (ERD) for a music-store database, very similar to the PostgreSQL Chinook database . It shows how the different tables are connected. Think of it as a map of the database : each box is a table, and each line shows how tables relate to each other. 1. The tables Each rectangle represents a database table: Table What it stores invoice Customer purchases/invoices invoice_line Individual items/tracks purchased customer Customer information employee Employees/support representatives track Songs/tracks album Albums artist Artists genre Music genres media_type Types of media/file formats playlist Playlists playlist_track Connects playlists to tracks 2. Start with customer At the top: customer | | support_rep_id v employee A customer has a support_rep_id . That means the database can determine which employee is responsible for supporting that customer . For example: Customer: customer_id = 25 name = "John Smith" support_rep_id = 3...