HSCEXAMQ+Kyle

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) The needs of the customer impacts of the design of the system, as they will be the ones using the system, customers, have many demogrpahics for the design on the system to consider, the parameters of want the customer wants may not meet the budget or feasibility study for the design of the system, futhurmore, the target audience, in basis of customer for the design of the system maybe me computer illiterate, require a user friendly GUI etc, and therefore there wants and needs have an impact on the design of the system. (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. (5)