A database is to be made to store information about a catalogue of CDs. Information to be
Question:
A database is to be made to store information about a catalogue of CDs. Information to be stored about each CD includes title, price, genre, and a list of tracks. Each CD will also have an artist, and each artist may produce several CDs. A track will have a title and a running time (in seconds). Each artist has name and a unique ID and it should be possible to search the database by artist names. Finally, in order to search the catalog by title, each CD will have a number of keywords. Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.
Please provide a detailed diagram with explanation.
Systems analysis and design
ISBN: ?978-1118808177
5th edition
Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth