City Guilds Model Questions Vol1 2022 Information Technology Question 20
Practice objective / multiple choice question 20 from the 2022 City Guilds Model Questions Vol1 Information Technology examination.
A company stores employee data in a table EMP with attributes EmpID (int, 4 bytes), Name (varchar, average length 12 characters), DeptID (int, 4 bytes), Salary (decimal, 8 bytes), and HireDate (date, 4 bytes). The table is in 1NF and contains 5 000 employee records. To achieve 3NF, the table is decomposed into EMP (EmpID, Name, DeptID, Salary, HireDate) and DEPT (DeptID, DeptName) where DeptName is a varchar with average length 15 characters. Assume each varchar field uses actual length plus 1 byte overhead, and each row incurs a 2‑byte record header. There are 20 distinct departments. Calculate the total storage required for the two tables, expressed in megabytes (MB) to three decimal places.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2022 Information Technology Question 20. It is one of the objective questions from the 2022 City Guilds Model Questions Vol1 Information Technology examination.
Difficulty level: Hard .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.