We will create an application to manage the system of a cd shop.
Firstly we have the CD that might be a mix of singles or an album and is identified by an id, title, number of tracks, record company and description. A track has title, length, and the singer/s or band. A CD has at least 5 tracks.
This cd might belong to one single artist or a band. If a singer it is identified by an id, name, surname, nickname (if any) and if band it is identified by id and name.
CDs have Category that is identified by an id and description that includes genres of music (ex. alternative, rock, r&b, pop etc).
We have also a branches that are identified by an id, name, address, contact phone number and contact email.
Our shop has its own customers that are identified by id, name, surname, birthday, email.
In the database all CDs available is a branch shop are stored and number of copies. Moreover, for each customer we keep trace of the CD and the branch where he/she bought it.
Requirements are attached