Deck 4: Database Concepts II

Question 1

Subject Table

Department Table

Refer to the tables in Q2.How many attributes are present in the Lecturer Table?

A)4
B)5
C)6
D)30

Answer 1

B

Question 2

To maximise the flexibility of the database structure in the business environment,achieving the _______ normal form is sufficient.

A)Third
B)Boyce-Codd
C)Fourth
D)Fifth

Answer 2

A

Question 3

Normalisation is the process of ____________ to eliminate repeating groups and data redundancies.

A)assigning primary keys to database tables.
B)assigning attributes to entities.
C)assigning foreign keys to database tables.
D)assigning relationships to entities.

Answer 3

B

Question 4

The goal of normalisation is to form tables that promote:

A)structural and query independence
B)relational and data independence
C)structural and data independence
D)relational and query independence

Question 5

Normalisation is a modelling technique used specifically for which type of database?

A)Hierarchical
B)Network
C)Relational
D)Object oriented

Question 6

What normal form is the Lecturer Table at?
Lecturer Table

Subject Table

Department Table

A)First normal form
B)Second normal form
C)Third normal form
D)The table is not at any normal form.

Question 7

Subject Table

Department Table

Refer to the tables in Q2.The best attribute to be chosen as the primary key for the Lecturer Table is:

A)Surname
B)Surname and Given_Name
C)Lecturer_Code
D)Given _Name

Question 8

Subject Table

Department Table

Refer to the tables in Q2.What best describes the relationship between the entities Subject and Lecturer?

A)A lecturer can teach no subjects but may also teach many subjects
B)A lecturer always teaches at least one subject
C)A lecturer always teaches only one subject
D)A lecturer can,but does not have to,teach only one subject

Question 9

Subject Table

Department Table

Refer to the tables in Q2.How many records are present in the Lecturer Table?

A)4
B)5
C)6
D)30

Question 10

A table in second normal form must not have:

A)Partial dependencies
B)Transitive dependencies
C)Abstractive dependencies
D)Binding dependencies

Question 11

Controlled redundancies:

A)are allowed for the convenience of structuring data,data manipulation or reporting
B)should be prevented at all costs
C)permit the formation of tables that promote structural and data independence
D)none of the options are correct

Question 12

Which normal form is sufficient for most business applications?

A)Second normal form
B)Third normal form
C)Fourth normal form
D)Fifth normal form

Question 13

For more convenient and quicker structuring,manipulating or reporting,one can:

A)Pursue the highest normal form possible through normalisation.
B)Eliminate data redundancies.
C)Leave the repeating groups as they are.
D)Create controlled redundancies via lower forms of normalisation.

Question 14

The process of normalisation has ______ outcomes and _____ steps to achieve those outcomes:

A)three;two
B)three;three
C)three;four
D)none of the options are correct

Question 15

A table in third normal form must not have:

A)Abstractive dependencies
B)Binding dependencies
C)Transitive dependencies
D)Substitutive dependencies

Question 16

If we want a table to have no repeating groups,what should we do?

A)Select a primary key that uniquely identifies each line in the table.
B)Remove duplicated records in the table.
C)Create another table and transfer the duplicated instances into the new table.
D)Create foreign keys in the table.

Question 17

__________ can be removed by making the non-key attribute that an attribute is dependent on a primary key in a new table with the attribute and by leaving the non-key attribute as a foreign key in the existing table so the attribute is dependent on the primary key but via a non-key attribute.

A)Data redundancies
B)Partial dependencies
C)Repeating groups
D)Transitive dependencies

Question 18

Redundancies that are allowed for the convenience of structuring data,data manipulation or reporting are referred to as:

A)Restricted redundancies
B)Controlled redundancies
C)Normalised redundancies
D)Partial redundancies

Question 19

Normal forms higher than 3NF are often not performed because:

A)the process usually requires artificial assumptions that rarely hold in the business environment
B)the process is too time-consuming
C)the process requires special knowledge in database design that is not generally available in the everyday business environment
D)the process is for academic use only

Question 20

__________ occurs where one attribute is dependent on another,but neither is part of the primary key.

A)Partial dependency
B)Transitive dependency
C)Data redundancy
D)Repeating group

Question 21

Which of the following is true?

A)The REA model can store non-financial data and financial data.
B)The ER model can store only financial data.
C)The REA model can store only non-financial data.
D)The ER model can store non-financial data or financial data,but not at the same time.

Question 22

With respect to REA models,which of the following statements is NOT true?

A)REA models the exchanges in the various processes in an organisation and brings these exchanges together to form an enterprise system.
B)REA models concern the developing of the dualities between resources,events and agents.
C)REA models assists the development of database structures that can be used to capture the details of a business process.
D)REA models have been implemented in actual accounting systems in practice.

Question 23

If an organisation decided to open up its database to its suppliers,it must: (i)Discuss with the suppliers how electronic connections are done (ii)Discuss with the suppliers how relevant costs are shared (iii)Discuss with the suppliers what data are actually needed by them

A)(i)(ii)
B)(ii)(iii)
C)(i)(iii)
D)(i)(ii)(iii)

Question 24

The software that effects transmission of data and control between client and server is called:

A)communications middleware
B)a front-end application
C)a back-end application
D)none of the options are correct

Question 25

When building a traditional accounting system using REA,the REA model:

A)is implemented as it is
B)is implemented as a relational database
C)is implemented as business processes
D)is implemented as an ER model

Question 26

Refer to the diagram in Q27.The resource that decreases is:

A)Customer order
B)Inventory
C)Customer payment
D)Cash

Question 27

A client-server system distributes computing functions between two types of ________ and _______ processes: servers and clients

A)dependent;autonomous
B)dependent;non - autonomous
C)independent;autonomous
D)independent;non - autonomous

Question 28

Refer to the diagram in Q27.The resource that increases is:

A)Customer order
B)Inventory
C)Customer payment
D)Cash

Question 29

The attitude of businesses towards using REA to implement accounting systems is best described as:

A)Keen
B)Positive
C)Reluctant
D)Negative

Question 30

Which of the following statements about the REA model is incorrect?

A)The REA model emphasises the recording of debits and credits within a relational database environment
B)The REA provides a structured approach for modelling business processes
C)The REA model consists of resources,events,and agents.
D)The REA model provides a template for a data model that can be applied in an accounting information system.

Question 31

Which of the following is NOT true about the differences between REA and ER diagrams?

A)ER diagrams do not have events.
B)REA diagrams do not show cardinalities.
C)In an REA diagram,entities are sorted into separate columns.
D)Both REA and ER diagrams show relationships.

Question 32

Duality in the REA model refers to:

A)Debits equalling credits when recording a transaction
B)The relationship between events that bring about an increase and decrease in resources
C)An event can only relate to one resource and each event can only relate to one other event
D)Each event needing two related agents - an internal and external agent

Question 33

When developing an enterprise model,which of the following sequence is correct?

A)Normalisation -> Construct ER Model -> Review ER Model -> Consolidate ER Model
B)Construct ER Model -> Consolidate ER Model -> Normalisation -> Review ER Model
C)Construct ER Model -> Normalisation -> Consolidate ER Model-> Review ER Model
D)Construct ER Model -> Review ER Model -> Normalisation -> Consolidate ER Model

Question 34

The process of developing an enterprise model is:

A)incremental
B)interlocking
C)iterative
D)agile

Question 35

REA database modelling is based on the premise that:

A)revenues,expenses and accrual items need to be identified for effective modelling
B)in every exchange in a process there is a revenue,event and agent involved
C)in every exchange in a process there is a resource,event and agent involved
D)none of the options are correct

Question 36

In the REA diagram shown below,the event that causes an increase is:

A)Customer order
B)Inventory
C)Customer payment
D)Cash

Question 37

When developing an enterprise model,the connectivities and cardinalities are primarily based on:

A)The general narrative of the organisation's operations.
B)The revision from areas of the organisation with ownership of the operations,policies,and processes.
C)The Normalisation process.
D)The consolidation of ER diagrams.

Question 38

Refer to the diagram in Q27.The event that causes a decrease is:

A)Customer order
B)Inventory
C)Customer payment
D)Cash

Question 39

It is proposed that there are common patterns of inflows and outflows in every exchange.All such exchanges can be best represented by:

A)ER
B)REA
C)Relational database
D)Client-server model

Question 40

One of the REA model's greatest advantages is that:

A)It is extremely easy and cost effective for any business to implement.
B)It enables all staff to better understand customer needs.
C)It can store both non-financial and financial data.
D)It enables businesses to identify which staff are the busiest.

Question 41

In a client-server architecture,the concept of 'fat' means:

A)The computer conducts most of the processing
B)Generous space exists in the computer case for extra components
C)Bulky laptops
D)More power consumption

Question 42

In a client-server system,which of the following software is loaded into the client computers?

A)Front-end application software
B)Back-end application software
C)Communications middleware
D)Groupware

Question 43

What are the normal forms beyond the third normal form? Are these normal forms used in general business scenarios?

Question 44

Describe two differences between ER model and REA model.

Question 45

The client-server architecture is based on three major components,namely:

A)PCs,servers,and network
B)Hardware,software,and people
C)Hardware,software,and communications middleware
D)Computers,network,and people

Question 46

What is primary key? How can we design a good primary key?

Question 47

Describe the concept of duality in REA.

Question 48

Briefly describe the nature of the REA Accounting Model.

Question 49

Client-server systems can normally be classified as:

A)Single-tier and multiple-tier
B)Two-tier and three-tier
C)Internal-tier and external-tier
D)Single-tier and two-tier

Question 50

Which of the following combination regarding the client-server architecture is correct?

A)A thin client with a fat server
B)A thin client with a thin server
C)A fat client with a fat server
D)Any combination of thin and fat clients and servers is fine.

Question 51

In a client-server architecture,the concept of 'thin' means:

A)Slim tower design of the computer case
B)Laptop computers are less bulky
C)The computer conducts minimal processing
D)The computer runs on less power

Question 52

When is an enterprise model ready for database implementation?

Question 53

Discuss the three major components of the client-server architecture.

Question 54

Discuss the outcomes of the first,second,and the third normal forms and the actions required to achieve them.

Question 55

In an e-commerce environment: (i)An organisation can open up its database to its suppliers (ii)An organisation can allow its employees to access internal databases from outside of the company (iii)An organisation can open up its database to its customers

A)(i)& (iii)
B)(i)& (ii)
C)(ii)& (iii)
D)(i), (ii)& (iii)

Question 56

What basic problems does the second normal form solve?

Question 57

In a client-server system,the client's request is handled by intermediate severs that coordinate the execution of the client request with other servers.This is known as a:

A)Single-tier client-server system
B)Two-tier client-server system
C)Three-tier client-server system
D)Multiple-tier client-server system

Question 58

Illustrate the process of enterprise model development.