Slide 13.2: How to construct My Memento by using server-side handheld computing
  Slide 13.4: Mobile Web user interface construction (WML)
  Home


How to Construct My Memento (Cont.)
  1. Oracle9i (Object-) Relational Database Design Database design uses either one of the following two methods:

    • Entity-relationship modeling, dividing your database in two logical parts, entities (such as “customer” and “product”) and relations (such as “buys” and “pays for”).

      •
    • Normalization, a series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database.

  2. Oracle9i (Object-) Relational Database Implementation (SQL)
     An Example of Oralce9i Database Implementation  
    shell> ssh 172.20.2.253
Password:

Last login: Mon Nov  7 12:08:00 2005 from shell.cs.und.no
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005

$ sqlplus userid/password

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Nov 10 11:55:15 2005
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> create table  memento (
  2    time     varchar(32) not null,
  3    temp     number not null,
  4    message  varchar(128) not null);

Table created.

SQL> insert into memento
  2    select  to_char( sysdate, 'HH:MI:SS, DY, MM/DD/YYYY'),
  3      52, 'NCAA playoff——Sioux and Bulldogs'  from  dual;

1 row created.

SQL> commit;
SQL> exit;
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 -
 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

$
†Note that this database design is only an example and it may not be correct for this exercise.
‡The italic text is entered by users.