A small library keeps a roster of who will be at the desk each day. They have a database table as shown below.
Week Start___Mon___Tue____Wed_____Thur____Fri
17/10/2011 -- Jane -- Sue -- George -- Sue -- Jane
24/10/2011 -- Jane -- Sue -- Linda -- Sue -- Lee
31/10/2011 -- Sue -- Sue -- Lee -- George --George
a) What problems can you foresee in making good use of this information?
b) Suggest some better ways that this information could be stored. A small library keeps a roster of who will be at the desk each day. They have a database table as shown below.
Week Start___Mon___Tue____Wed_____Thur____Fri
17/10/2011 -- Jane -- Sue -- George -- Sue -- Jane
24/10/2011 -- Jane -- Sue -- Linda -- Sue -- Lee
31/10/2011 -- Sue -- Sue -- Lee -- George --George
a) What problems can you foresee in making good use of this information?
b) Suggest some better ways that this information could be stored.