ABSTRACT: This thesis presents a design and implementation of the Enhanced Secure Online Relational Database System (ESORDS). Besides having all the advanced features of its predecessor, SORDS, such as open database connectivity, cross-platform, secure access control, table locking for concurrent transaction and easy-to-use methods for data operation through a user-friendly interface, ESORDS makes every effort to meet the user's needs by adding multiple table views and table transposing. In ESORDS, a variety of tools can be used to create a view, which increases opportunities to cater to different tastes. View creation is limited to the creator of a specified database without bothering normal users, achieving a more user-friendly interface. Table transposing is applied to satisfy the special requirement that multiple parallel tables in the underlying database be viewed at a different angle. This is especially important when statistical analysis needs to be done in the transposed tables but is not allowed in the base tables. In ESORDS, a column can be added in a table at any position instead of the right most position, making table creation much more flexible. Additionally, ESORDS enables a formula to use absolute cell reference, a portable and efficient spreadsheet capability.

To create a table, the table name and the number of the columns initially
contained must be given. If the table name is already taken, the system alerts the user
_li-tGraJed _.'r;Pu J/ianarpda4 Je'trmP" J'p c _mi. ,Jp ftnI