This project is concerning a study case needed to be analysed, and broke down. I have to define attributes, entities, draw ER diagram, and Normalise. As well as identifying main processes, insert, updating, deleting rules. Validate reports, queries, views integrity, sharing and security. I have to define location of tables, access requirements, and fragmentation strategy. And finally i should find the factors affecting decisions and find what decision should i take and why. Also it needs SQL code should be covered and it has to be in 'ANSI' compliant form.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) it should be simple and clear please, the project is from page 13 til 25, please keep it clear and simple. 3) All the requiremnts of the project are all stated in the questions, remember the SQL should be in 'ANSI' form