DATABASE

Background Home Sweet Home (HSH) is a chain of stores selling an extensive range of household goods from stores located throughout the UK. The company recognises the growing importance of e-commerce in the consumer market and in a bid to remain ahead of its competitors, HSH has decided to expand into this area and offer customers the opportunity to purchase items from a Web site. It should be possible for a customer to log onto the HSH Web site, select and purchase their required items and pay for them. The items would then be delivered to the customer at home. HSH aims to make shopping from its Web site easy for its customer by stocking the goods they require, offering them a wide range of alternatives and keeping then informed them about new products coming onto the market. The company requires a database system to meet these aims. The database needs to store information about products in stock and products that will shortly be coming onto the market, track the stock of products available and record orders made by the company's customers. The Final Report Your final task is to implement your database design using Oracle. You will need to perform the following activities: · Convert your relational model into an SQL database using the notes from the workshop (posted on Blackboard as Database Implementation in the Workshops folder). · Populate your database with some sample data · Test your database. You will need to consider testing the database for two aspects, first the integrity of the data and secondly that the database meets the information requirements. For the second aspect you need to create and run SQL queries that produce the information required. You do not need to consider the formatting of the data. The final report will document the activities you have undertaken. It requires the following chapters: Chapter 1: Introduction - one page description of the aims and objectives of the report Chapter 2: The EAR Data Model. The ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform ORACLE using SQL