QUESTION ONE [50]

Read the following article and answer the questions that follow:

Hierarchical and Relational Database Accounting Systems: Critical Aspects and Trade-Offs

Although the transition from hierarchical to relational databases marked a crucial turning point in the development of accounting systems, the concept hierarchy has not entirely been abandoned.
Hierarchical coding, is distinct from sequential encoding schemes, may have different implications on the selectivity/accuracy/efficiency of the (Database Accounting System) DAS.

In the late 1970 s, Codd laid down the principles of the relational model and a set of 12 rules to be followed to achieve a relational system. That list has now been reduced to two main rules, stating that a system is relational if (1) it represents data in the form of two-dimensional tables such as the database table and (2) it supports the relational algebra functions of restrict, project, and join. With the relational model, problems like the ordering dependence, the indexing dependence and the access path dependence were resolved. After a few years, the entity/relationship (E/R) model of Chen allowed an improvement in the design and implementation of the relational model. The mathematical rigor and simplicity of these systems have long been their strong points.

The attention paid by companies to relational models has increased over time, and, consequently, many firms have moved from the hierarchical to the relational model. Today, the attention paid to the relational model design is still high, and both theoretical and practical contributions in this sense are aimed at explaining the role of data modelling for an effective relational database design.
Over the last forty years, several database systems have come onto the market, using hierarchical, network, relational, object-oriented, and XML data models. As the performance of relational database systems has continuously improved, the companies have felt the need to convert non-relational database systems into the relational, or to add a relational component to non-relational models.

Such change is due to the following advantages recognized in a relational accounting database system:
• Higher flexibility and data independence;

• The user-oriented languages Data Definition Language (DDL) and Data Manipulation

Language (DML);

• Their relatively simple maintenance and physical storage conditions.

Other advantages of the relational model include minimizing data redundancy, preventing anomalies of data entry and facilitating both the updating and the deleting process.

Adapted from: Carlo Caserio, Luciano Marchi and Gabriele Pulcini. Accounting Information Systems. 2013.

1.1 Determine the evolution of the principles created by Codd, use relevant examples from the article. (10)

1.2 With the use of relevant examples from the article examine why organisations have shifted from hierarchical to relational database. (15)

1.3. In relation to the article discuss the concept of a hierarchical database. (10)

1.4. Elaborate on each type of database language. (15)

QUESTION TWO [25]

2.1 Categorise each of the five functions performed by information systems. (10)

2.2 Determine each of the different information attributes that must be taken into consideration when designing an information system. (15)

QUESTION THREE [25]

3.1 Deliberate on the advantages of the database environment. (10)

3.2 State and discuss each of the events that occur in a typical sale transaction. (15)

Answers to Above Questions on Database Accounting Systems

Answer 1: The principles provided by Codd in relation to relational models are significant from the point of view of revolutionising the field of database management systems. The principles by Codd emphasize on representing data in the form of two dimensional tables or relations. It also emphasizes on the importance of supporting relation algebra functions such as restrict, project and join.

answer
Get experts from the team of writers of Student Life Saviour in South Africa to get best answers for all the above database accounting systems questions.

Content Removal Request

If you believe that the content above belongs to you, and you don’t want it to be published anymore, then request for its removal by filling the details below. It will only be removed if you can provide sufficient evidence of its ownership.

    March
    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    2025
    1950
    1951
    1952
    1953
    1954
    1955
    1956
    1957
    1958
    1959
    1960
    1961
    1962
    1963
    1964
    1965
    1966
    1967
    1968
    1969
    1970
    1971
    1972
    1973
    1974
    1975
    1976
    1977
    1978
    1979
    1980
    1981
    1982
    1983
    1984
    1985
    1986
    1987
    1988
    1989
    1990
    1991
    1992
    1993
    1994
    1995
    1996
    1997
    1998
    1999
    2000
    2001
    2002
    2003
    2004
    2005
    2006
    2007
    2008
    2009
    2010
    2011
    2012
    2013
    2014
    2015
    2016
    2017
    2018
    2019
    2020
    2021
    2022
    2023
    2024
    2025
    2026
    2027
    2028
    2029
    2030
    2031
    2032
    2033
    2034
    2035
    2036
    2037
    2038
    2039
    2040
    2041
    2042
    2043
    2044
    2045
    2046
    2047
    2048
    2049
    2050
    SunMonTueWedThuFriSat
    23
    24
    25
    26
    27
    28
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    1
    2
    3
    4
    5
    00:00
    01:00
    02:00
    03:00
    04:00
    05:00
    06:00
    07:00
    08:00
    09:00
    10:00
    11:00
    12:00
    13:00
    14:00
    15:00
    16:00
    17:00
    18:00
    19:00
    20:00
    21:00
    22:00
    23:00