Please specity which knowledge is insufficient if there is any. Thanks. Chapter
ID: 3904380 • Letter: P
Question
Please specity which knowledge is insufficient if there is any. Thanks.
Chapter 1: DBMS (5 points) A long-time volunteer public skating coordinator for an ice arena in Madison wants to store information about many public skating events at this ice arena over the year so that he could provide some concrete reports to the director board every quarter. Not surprisingly, the volume of data compels him to think about using a database system. However, he wants to pick the features of a database management system (DBMS) to fit his needs only, i.e., he wants to buy/use a DBMS ! with the fewest possible features. He plans to run it as a stand-alone application on his laptop. Of course, he does not plan to share his data with anyone. Indicate which of the following DBMS features he should choose/pay for, in each case also indicate why he should (or should not) pay for that feature in the DBMS system he plans to buy. 1. Concurrency control. 2. Crash recovery 3. A reporting tool (tools used for data visualization or geneting reports from stored data). 4. A query language.Explanation / Answer
1.It is a standalone laptop application so there is no need of concurrency control
as this deals with multiple transaction happening concurrently which may not
be the case in this scenario.
2.Crash Recovery:This is a very complex activity which tries to recover lost data if
there is a crash amid many transactions.The kind of usage mentioned here is just
some information on skating events and reports.The imformation seems to be mostly
static and not much of transaction are there so there is no need of such complex
mechanism.
3. Reporting Tool - Data visualization and reporting seems useful as in this case
for report generarion is an activity and also some graphical representations will be
useful
4. SQL quuery language: This is bery much required because without this we can not
interact with the DBMS programatically. For generation of custome reports , creatin tables euc this is very much required.