questions

a. Paul can use server side scripting, to store an index of snogs to be played. Client side scripting can be used to store each users playlists, containing there songs, this is used to keep the playlists separate per user. sever side scripting can be used to output the songs. Paul can use server side processing to handle events, passed by the users. Paul will also need a database to log the songs provided by users, as well as a database to hold the songs that are originally available.

explain why server side processing would be used to allow the customers to add songs to a playlist? (4 marks)
most-up to date list
work together in real time
reduce duplication
don't need specific software on the client side
pual can manage the process more effectually
reduces the processing load in the users computer

b. A selection of songs that Pual has stored and the rules that should be followed when generating a playlist, can be seen in Section 4 of the information Booklet. Devlop an algorithm using pseudicide that meets the rules to generate a playlist. (10 marks)

begin
open database connection
time = songlength(i) - 25
if time < then 60s:
minute ++
store songname
store time
store rating
index++

if rating = :

end




pual should use SSL (1)
paul should use a firewall (1)
paul should sanatize his inputs, to stop SQL injection (1)
paul should not use client side scripting for sending payment details, this allows for XSS
paul should store user data in other tables
paul should encrypt the user data (1)
paul should keep the server