1. Verify the structure of existing databases
Databases must be streamlined to work at an efficient and convenient level. Let us say that a refugee receives an interview and speaks about three incidents that the interviewer must record. If such incidents are simply extra fields in the same table as the interviewee's data, a static number of incidents would be the only way to record such information. The database would be limited to a certain number of incidents (let us say five), and, if some incidents are not used, the remaining empty incidents take additional space in the database. Certain methods exist to overcome such obstacles in database design. These methods are known as normalizing a database.
2. Export the table stucture
Often called the schema of a database, the tables are exported to the database systems to begin the creation of a database management system. Our project involves exporting the database to both Microsoft Access and Oracle database systems.
2. Import data into the new table structure
The database team can import the data collected from previous databases into the new structure.
3. Create forms in Microsoft Access
Forms are the manner that users generally input data into a database. They give the user a simple, graphical user interface (GUI) to place data into a rather complex database.
4. Begin creating forms in Oracle
Work on the forms in Oracle can begin along side the Microsoft Access work. This ensures a level of continuity between the forms.
5. Receive further information from ABA: CEELI
Further information from the American Bar Association: Central and East European Law Initiative (ABA: CEELI) gives the team a chace to finish the forms for the Microsoft Access database.
6. Send out final version of Microsoft Access database
After the completion of the Microsoft Access database, ABA: CEELI can begin to use the newer version.
7. Continue work on the Oracle database
As a crucial step, the database team will continue to create a very powerful and easy to use Oracle version of the same database. This database will also include a connection to a geographic information system (GIS) component. Both technologies will provide the best solution to the problem.