Distributed Database for local health centres using Mssql server 2000 or Oracle 9i

**Title:**The design and implementation of a Distributed Database for GP Surgries. **Keywords **Distributed Database,Internet,DDBMS,Patients,General Practitioners,Records,Integrity,Object Oriented,Replication,Fragmentation Relational,Heterogeneous,Homogeneous,Security **Problem Defination **GP Surgeries within a local area are at present using an individually centralized database, tailor-made for individual [login to view URL] is a problem considering the inadequate resource distribution from the government. On the part of the patient,another problem arises. At present, new patients who want to register with GP Surgeries near his/her residence, can only do so if that surgery has space for new intakes, if not, that patient will have to manually try other GP Surgeries for space/[login to view URL] can be tedious on the part of the patient. **Aim **My aim is to provide a single data source for all GP Surgeries to facilitate and speed-up patients waiting [login to view URL] database should save patients time by reducing the time spend waiting for appointments or registering with a new GP Surgery. To that end,the database must be [login to view URL] database should act as a one-stop information centre allowing GPs and staff(depending on the level of premission)to access,for e.g sensitive client [login to view URL] allows GPs to readily find the data he or she [login to view URL],the database must be easy to [login to view URL] to use,means that any staff within the GP Surgeries should to able to utilize the database project is to provide a single data source for all GP Surgeries,it is crucialthat the maintenance of the database should take less time than the database itself. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive 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). **Deliverables ***Entity diagrams *Use case diagrams *Design and Implementation of Distributed Database for local Health Centres *Testing *User manual *Screen shots *Gantt charts *Design implementation *Security Implementation ## Platform Windows XP or Window 2000 + Internet Explorer 6 or better