bookshop databse

Completed Posted Jan 21, 2004 Paid on delivery
Completed Paid on delivery

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

Article Rewriting Engineering Microsoft Access MySQL PHP Research Writing Software Architecture Software Testing Translation

Project ID: #3075619

About the project

6 proposals Remote project Active Jan 22, 2004

Awarded to:

msmughal

See private message.

$21.25 USD in 10 days
(39 Reviews)
3.7

6 freelancers are bidding on average $51 for this job

shashikhanvw

See private message.

$68 USD in 10 days
(19 Reviews)
3.9
saffronvw

See private message.

$68 USD in 10 days
(9 Reviews)
1.7
vw1066911vw

See private message.

$29.75 USD in 10 days
(0 Reviews)
0.0
phoenixtechvw

See private message.

$51 USD in 10 days
(2 Reviews)
0.0
desinz

See private message.

$68 USD in 10 days
(0 Reviews)
0.0