Suggest some better ways that this information could be stored. Exercise 1-2 A s

Question

Suggest some better ways that this information could be stored. Exercise 1-2 A small library keeps a roster of who will be at the desk each day. They have a database table as shown in Figure 1-8. week start Mon TueWed Thur Fri 17/10/2011 Jane Sue George Sue Jane 4/10/2011 Jane SueLinda Sue Lee 31/10/2011 Sue Sue George George Figure 1-&. An initial database table to record roster duties What problems can you foresee in making good use of this information? Suggest some better ways that this information could be stored commando

Explanation / Answer

Problem: it would be a tedious task to find out who was on the desk on a particular date given this structure.

Solution: What we should do instead is save the date, attendant_name and a boolean that tells us whether that day was monday or not.

Data Types:

Date : date

Attendant_name : string

IsMonday : boolean

Roster(Date, AttendantName, IsMonday)

This way we would be able to identify the person on duty using the date with utmost ease.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---