You should keep your datatypes as small as possible, yet big enough to fit the data you intend to store. The maximum value of an int is 2147483647 (2.147... billion). So if you intend to store values larger than that, you need a bigint column. No need for float or real if you don't intend to store decimal values. Is this a homework assignment?