Calculating the Size of a Table

As a new database administrator, you have been asked to create a large employee database that will store information for 10,000 employees.

Say that you have the following columns defined in the table:

FirstName varchar(50)

LastName varchar(50)

StreetAddress varchar(75)

State varchar(2)

ZipCode varchar(9)

Age int

BirthDate date

How many bytes would you need to store each record? How many bytes would you use to store 10,000 records?