flexible and scalable. IBM DB2 can be put on a small server like Linux or Windows NT all the way to an IBM OS390 Mainframe. This range of growth gives it the most scalable capabilities. The database structure to store the Teachers Assistant information is best represented using an Entity Relationship Diagram. This diagram will show tables, fields, field types, primary keys, alternate keys, foreign keys, etc. Fig. 3 shows the database structure used to capture the data required for the Teachers Assistant. The data structure is defined and generated using simple SQL statements. These statements follow the SQL92 standard. One mendation is not to put business logic into the database. This will limit the scope of future applications that may want to take advantage of the same data. The data is
全文预览