Database Design and Mapping for a Music Management System

Identifying Main Entities:Musicians: Storing information about artists (Name, Phone Number, Address). Instruments: Storing details about musical instruments and their key/pitch. Songs: Storing song titles and author details. Albums: Storing album titles, copyright dates, and identifiers. Defining Relationships & Actions:Linking Musicians to Instruments they play. Linking Musicians to Songs they perform. Linking Musicians to Albums they produce. Linking Instruments to Songs where they are used. Linking Songs to Albums they belong to. Converting (Mapping) ERD to Tables:Creating dedicated tables for each entity (Musician, Instrument, Song, Album).