Sun Apr 1 105 TESTING YOUR UNDERSTANDING Exercise 1-1 A school is planning some

Question

Sun Apr 1 105 TESTING YOUR UNDERSTANDING Exercise 1-1 A school is planning some outdoor activities for its students. The staff wants to create a database of how parents can help. The secretary sets up the database tabl? in Figure 1-7 to keep the information. last_name first_name phonecontributioncontribution2 Smith Green Henry Wang Jane Rob James Li 4623598 Food preparation Driving 8965431 Transport 9576342 9612345 Cooking Camping Gear Cooking Figure 1-7. Initial database table for recording parent contributions What problems can you foresee in making good use of this information? Suggest some better ways that this information could be stored

Explanation / Answer

Solution:

The problem here can arise is this database is that it will create trouble in extracting the contribution of the parent from the database, also if this is mapped with the student table as well, then it would have been better.

Another better way of saving the contribution part will be is to have all the keywords of the contribution in the same column, in the comma separated values(CSV) format.

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.