TID3123 DATABASE ADMINISTRATION

1
TID3123 DATABASE ADMINISTRATION ASSIGNMENT 1 A
TID3123 database is estimate to have five tables
such as TOPIC1, TOPIC2, TOPIC3, TOPIC4 and
TOPIC5. TOPIC1 has three columns num, with
integer data type, topic, with 25 byte character
data type and description, with 100 byte
character data type. TOPIC2 has four columns the
first three columns are same with the TOPIC1
table, the last column is price with money data
type. TOPIC3 has two columns action, with 50
byte character data type and date, with datetime
data type. TOPIC4 has three columns bil, with 5
byte character data type, name, with 25 byte
character data type and marks, with float data
type. TOPIC5 has four columns the first three
columns are same with the TOPIC4 table, the last
column is grade with 1 byte character data type.
As a database administrator you have to
estimate how much disk space (in Megabyte)
required for the TID3123 database if all five
tables are estimated to have about 10000 rows.
Due date 10/8/2008 in class