Help Please (1 Viewer)

[Beetle]

Hey guys

can anyone tell me how to calculate the size of a database, just being given a data dictionary? Its no where to be seen in the textbook so please can someone help me?
Help Really much appreciated !

 

[wicked_65]

first of all you add up all the sizes (in the size field in the data dictionary) and referring to the 2005 paper qs13, the total would be 60, which is 60 bytes. So that means it takes 60 bytes to store one record. If the qs says it needs to store 100 records, then the answer is 60 x 100 = 60 000bytes, which is approxiamtely 60KB (or 58.59375 KB to be precise) as 60 000 bytes = (60 000/1024) KB

 

[wicked_65]

first of all you add up all the sizes (in the size field in the data dictionary) and referring to the 2005 paper qs13, the total would be 60, which is 60 bytes. So that means it takes 60 bytes to store one record. If the qs says it needs to store 100 records, then the answer is 60 x 100 = 60 000bytes, which is approxiamtely 60KB (or 58.59375 KB to be precise) as 60 000 bytes = (60 000/1024) KB. So the key is to add up all the field sizes and then check the qs to see how many records it requires. Then u must provide the answer in the units required, meaning if the answer "how man Kilobytes are needed" do not provide the answer in bytes, but kilobytes

 

[Vicsta]

what?? ok first of all paper 2005 q13 theres nothing on anything about sizes of a database, an secondly i dont think theres anything about calculacting the size of a database anywhere in the syllabus and thats why theres nothing in the book... just so u dont stress to much i dont think theres gonna be any questions even relating to that

 

[seremify007]

I've seen questions in the past where you've had to calculate it.

Let me just say this- you guys are really on the ball for this IPT exam Even I can't remember if I was this "into" it.