Tuesday, September 24, 2019

Suitability of a relational database structure rather than a Essay

Suitability of a relational database structure rather than a spreadsheet table - Essay Example This research is about determining the suitability of a relational database structure over a spreadsheet table for storing and accessing data for a local arts centre. The local arts centre wants to store and access the information on the various classes and/or workshops offered, the tutors, their specialist areas and the people who sign up for the classes. In this scenario there are two main technology options; we can build a spreadsheet structure for managing these operations or we can develop a relational database system to deal with the operations of the local arts centre. The database can be developed using the spreadsheet and relational database structures. In case of effective development and handling of data and its effective manipulation we have seen that relational database structure offers more facilities and functions. However, the spreadsheet structure is also effective in case of small data management because it is easy to produce and manage. But, in case of huge or complex data management and handling we will surely require the relational database structures. Thus, the local arts centre should choose relational database structure for storing the data.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.