|Phone Table||Sale Table|
|Relational Database||Data Warehouse|
Case Study:Melanie is a marketing graduate who joined Health Scotland. She has been working as Personal assistant (PA) for last five years with great interest in Web design. Over time she learned how to do this on her own and the management trusted her to manage, update and even build some pages on her own using an application called Dreamweaver. She enjoys this and has successfully done many pages making sure always she shows the pages she created to management and gets a lot of feedback before she publishes it online. Now there is a big health event coming up in which advance needs to be put online regarding heart attack risks and how to avoid them. She is excited because this will be a big and challenging project but she can do it. She just wants to make sure she gets the right information and right feedback from the experts and management so she has scheduled three meetings a week in which she will show the pages for feedback and at every stage of development.