Get Instant Help From 5000+ Experts For

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
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.

sales chat
sales chat