bookshop databse

Your task is to design a online dynamic website for ‘Woodbrook Books’. In order to do this you must carry out a systems analysis (overview of the current system ??" the above details are for the benefit of the database so you may have to assume the answers of any others questions that you come up with ??" indicate anything that you have assumed) Part 1 Design (40 marks total) a) Generate a set of noramlisation relations. You should *discuss* each of the stages of the normalisation that the model passes through to get to the final version, even when at any stage you are proposing no change. At each stage clearly show *all* the relations, their attributes, primary keys and foreign keys (but no data values!). State any assumptions that you make. *(20 marks)* b) Using Connolly’s notation, draw an Entity-Relationship Diagram that corresponds to your set of normalisation relations. Show entities and relationships, but not attributes.* (6 marks)* c) Give *one* example where the introduction of subclasses might be suitable in your model **and** discuss (in no more than half a page) how the concepts of Enhanced Entity Relationship Modelling apply to your example. *(4 marks)* d) Data Flow diagram of OLD system *(4 marks)* e) Data Flow Diagram of NEW system. *(4 marks)* f) Overview of current system *(2 marks)* ## 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) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows XP