Rule of Law Through TechnologyHome

inthemedia forum resources services projects Menu Bar

Team Goals

 

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.

 


Projects | Services | Resources | Forum | In the Media

ROLTT Project: Institutions | Sponsors | Internal | Contact Info


Chicago-Kent College of Law The Rule of Law Through Technology Initiative
is an Interprofessional Project (IPRO) of
Chicago-Kent College of Law,
Illinois Institute of Technology

Powered by Sun MicrosystemsOracle Application Server: InternetThis site is made possible by the generous donations of Sun Microsystems and Oracle, Inc.