Find row size for the student table and the space required for the entire table. Assuming a 80% fill factor estimate primary data files. Ignore storage requirements for indexes , views and constraints.

Expected step answers are

• Number of rows in a page
• total number of pages required for the table
• Total Table size in KB or MB
• Total file size in Kb or MB

The student table has following 3 columns.

Student Table:

Id BIGINT not null

Name NCHAR(20) not Null

Branch NVARCHAR (64) null

The table contains : 100000 rows .