Database Schema and Pseudo Help?

[dalgic]

Hi there,

I currently need to answer two technical questions for a job. If anyone kind enough here to guide me on the questions and maybe give some examples, I will really appreciate it. Thanks

Questions:

1) Please describe in psuedo code exactly how you would solve the following problem.

We have a dynamic online magazine. Each page of the magazine contains an image and an article. Your problem is to dynamically colour the article text and the article background to match the colours that are present in the image, making considerations for readability and accessibility. Justify your choice of colour and explain any extensions to this that you feel would enhance the solution.

2) A new client has asked for a new website which hosts articles written by users. The articles will be mainly media and technology based, and will be about all things music, including bands, songs, products and interviews.

Users sign up with the following data: email, name, password. Articles contain the following data: title, content, photo. Articles also have one or more comments, left by users. There are static pages of the site, which are controlled through a CMS, and they have the following data: title, content. Some users are granted moderation rights, and others are admins.

Design a database schema which will support this site (this can be written descriptions of each table, UML is not required), and explain any design decisions you have made. Also, note any probable changes to the site the client will want to make, and how they will affect this database design. Is it a good idea to design a database schema that takes into account these possible future additions? Why?

[ryanhellyer]

Hi Dalgic,
I'd like to help, but I know very little about databases, hopefully someone else will be able to help though.

Good luck