XYZ is an internet-based music service that allows customers to purchase music from the store’s online database, and then download immediately to their computers using a specified code. When visiting the website, customers are asked to carry out the following steps:
Step 1: Select music genre Step 2: View artists in a particular genre Step 3: View currently available songs Step 4: Select desired song(s) Step 5: Pay for song(s) by selecting method of payment Step 6: Complete payment details Step 7: Receive a receipt with specified music code Step 8: Download song
(a) Explain how the needs of customers have an impact on the design of the system. 3
(b) Prepare a data dictionary for a table named ‘Customer’. 3
(c) Draw a schema that would demonstrate the logical organisation of data in the XYZ music store database.
Show the nature of relationships and relevant key fields.
A) The customers have an impact on the design because it needs to be user friendly depending on the type of people that are going to use it.
