Beautiful Flowers Company has been running an outdated file system for many years.

It has just employed you as a consultant to advise it on updating its file system to a database. It knows that the initial stages before implementation involve database modelling and database design but does not understand their implications.

(a) Explain to Beautiful Flowers Company the objectives of database modelling in its situation.

(b) Discuss the role and development of E-R diagrams in database modelling.

(c) Explain to the company how database design will be conducted including the function of normalisation.