We consider the following relational scheme:
Personnal ( EmployeeNumber, Name, FirstName, HiringDate , TitleFunction ) of key EmployeeNumber
There are 1000 employees, 25 different functions (title of a function have about an average of 20 characters) equi-distributed between employees (i.e. 40=1000/25 employees having the same function).
A number (like the number of each employee) is an integer coded by 4 bytes.
Give an entity-association scheme correspondent to relational scheme.
Propose another relational scheme.
Give an entity-association scheme correspondent to relational scheme proposed.
Compare the activity (quite theoretical) of the disk (in number of bytes) required for each of both relational.
Indicate the advantages and the inconveniences of the new relational scheme.