Lab 1

# The University of Texas

CS 327e

Fall 2001

### Lab 4

Due: 2001-11-12 Monday 8.30 a.m. by email to TA.

Purpose:

a) Get familiar with physical space estimation.

For this lab, develop a MS-Excel spreadsheet for:

a) Chapter 8 Problem 8

Assume:

Table: RESERVATION (4 per week, 14 weeks per semester, 56 reservations per semester)

Attribute Data Type (bytes)

RES_ID INT 4

RES-DATE DATE 8

USER_ID CHAR(11) 11

LA_ID CHAR(11) 11

Table: INV_TRANS (80 per week, 14 weeks per semester, 1,120 transactions per semester)

Attribute Data Type (bytes)

TRANS_ID INT 4

TRANS_TYPE CHAR(1) 1

TRANS_PURPOSE CHAR(2) 2

TRANS_DATE DATE 8

LA_ID CHAR(11) 11

USER_ID CHAR(11) 11

ORDER_ID INT 4

TRANS_COMMENT CHAR(50) 50

Table: TR_ITEM (240 per week, 14 weeks per semester, 3,360 per semester)

Storage

Attribute Data Type (bytes)

TRANS_ID INT 4

ITEM_ID NUMBER(8,0) 8

LOC_ID CHAR(10) 10

TRANS_QTY INT 4

Table: LOG (5,000 per week, 14 weeks per semester, 70,000 reservations per semester)

Storage

Attribute Data Type (bytes)

LOG_DATE DATE 4

LOG_TIME CHAR(12) 12

LOG_READER CHAR(1) 1

USER_ID CHAR(11) 11

Table: ITEM (890 identified)

Storage

Attribute Data Type (bytes)

ITEM_ID NUM(8,0) 8

TY_GROUP CHAR(8) 8

ITEM_UNIV_ID CHAR(7) 7

ITEM_DESCRIPTION CHAR(10) 10

ITEM_QTY INT 4

VEND_ID CHAR(5) 5

ITEM_STATUS CHAR(1) 1

ITEM_BUY_DATE DATE 8

Table: INV_TYPE (15 rows in this table --- see Table 7.2, 7.3 in Chapter 7.)

Storage

Attribute Data Type (bytes)

TY_GROUP CHAR(8) 8

TY_CATEGORY CHAR(2) 2

TY_CLASS CHAR(2) 2

TY_TYPE CHAR(2) 2

TY_SUBTYPE CHAR(2) 2

TY_DESCRIPTION CHAR(35) 35

TY_UNIT CHAR(4) 4

Submit:

a) Submit an MS-Excel spreadsheet named lab4xxxx.xls, where “xxxx” is the last 4 digits of your SSN. After zipping it up, send it as an attachment in an email to the TA.

Home Page