I ran across this questions trying to dive into a computer measurements worksheet online and for the life of me could not figure it out. This is the question:
Assume each record in a database requires 1Kib and there should be approximately 5 million records that need to be stored. Estimate the amount of storage needed in gibibytes for the database.
Any help would be extremely appreciated because I'm completely lost on this question even though it sounds like it should be simple. Thanks in advance.
Best Answer
The following would be an estimate that assumes full pages and doesn't take into consideration any database overhead (page header, etc.) or compression. It would be simple math
5,000,000kb / 1024 = 4882.8125mb
4882.8125mb / 1024 = 4.76837158203125gb
But, I agree with other comments - you should create a test database and see how close the numbers match up.