Design and Implementation of a Product Monitoring Service for a Retail Outlet

Initial Entity-Relationship Model

This coursework is about the design and implementation of a product monitoring service for a retail outlet.

Study the ‘PC Land’ case study carefully and then submit the following:

1.      Draw an initial Entity-Relationship model, stating any assumptions you make..
                            
2.      Normalise (to third normal form) the Sales Form. Show all the steps of normalisation clearly. State any assumptions. Now draw an Entity-Relationship diagram for these normalised entities.

3.    Give the Relational Schema (set of tables) that you will create.            
   
4.     Implement and submit printed documentation for the following:    

    (a) Create the tables you have identified for the PC Land database and populate them with appropriate test data of your choice.

    (b) Implement all the product information queries and all the sales process queries. You should provide, for each query, a separate Oracle script AND the  resulting output.

    (c) Now produce two additional queries (Q7 and Q8) which you believe will be useful to the company.

Consider extending your schema with either extra data columns or tables for this purpose. Give a clear textual description of what each of your two queries is  supposed to show. Use your judgement as to what information the queries should contain and how they should be formatted.