Jump to content
Sign in to follow this  
syira86

Tlg Ajar Database Admin

Recommended Posts

askum..sy nk mintak tlg ....tlg ajar sy cmne nk wat execrise nie...plz

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 database if all five tables are estimated to have about 10000 rows.

Share this post


Link to post
Share on other sites

amboi 3x..... (ikut cara izuan ali...)

senang nya kojer... <_<

kalau ya pun nak minta tolong... adik kenela bagi idea dulu...

tunjukkan lah skill yang adik ada dulu..

bagi cadangan di buat database tu dari ape, cadang nak guna bahasa apa..

jangan terus bagi soalan periksa kat kami disini...

nanti topik nie akan terus berkubur.. sebab tak ada yang nak jawab... :huh:

Edited by TJ-Ariff

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...