Ch4 Practise Q's - Database Concepts II Flashcards
The process of normalisation has ______ outcomes and _____ steps to achieve those outcomes:(LO1)
A three; two
B three; three
C three; four
D none of the options are correct.
B three; three
First normal form is summarised as which of the following?(LO1)
A A field name may not be used more than once.
B Repeating values for a field in a single record must be stored in an array.
C There is only one row in the table for each value of primary key.
D All of the options are correct.
C There is only one row in the table for each value of primary key.
A table in third normal form must not have:(LO1)
A abstractive dependencies.
B binding dependencies.
C transitive dependencies.
D substitutive dependencies.
C transitive dependencies.
A table in second normal form must not have:(LO1)
A partial dependencies.
B transitive dependencies.
C abstractive dependencies.
D binding dependencies.
A partial dependencies.
The development of an enterprise model is:(LO3)
A a once off process involving three steps.
B an iterative process involving three steps.
C an iterative process involving six steps.
D none of the options are correct.
C an iterative process involving six steps.
An enterprise model is prepared by:(LO3)
A connecting normalisation results for each part of the organisation.
B combining the ER diagrams and normalisation results for each part of the organisation.
C evaluating the database requirements for each part of the organisation.
D none of the options are correct.
B combining the ER diagrams and normalisation results for each part of the organisation.
The use of the word semantics, in the context of this chapter, means the:(LO2)
A precise wording of design.
B language in which the database is implemented.
C underlying business logic of the data.
D order of the fields in the entities.
C underlying business logic of the data.
Another way to model data is to use:(LO4)
A the REA (resources–events–agents) Accounting Model.
B the ERA (events–resources–agents) Business Model.
C the REA (resources–events–agents) Business Model.
D none of the options are correct.
A the REA (resources–events–agents) Accounting Model.
REA database modelling is based on the premise that:(LO4)
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.
C in every exchange in a process there is a resource, event and agent involved.
When building a traditional accounting system using REA, the REA model is:(LO5)
A implemented as it is.
B implemented as a relational database.
C implemented as business processes.
D implemented as an ER model.
B implemented as a relational database.
One of the REA model’s greatest advantages is that it:(LO5)
A is extremely easy and cost effective for any business to implement.
B enables all staff to better understand customer needs.
C can store both non-financial and financial data.
D enables businesses to identify which staff are the busiest.
C can store both non-financial and financial data.
A client–server system distributes computing functions between two types of ________ and _______ processes: servers and clients.(LO6)
A dependent; autonomous
B dependent; non-autonomous
C independent; autonomous
D independent; non-autonomous
C independent; autonomous
The client-server architecture is based on three major components, namely:(LO6)
A PCs, servers and network.
B hardware, software and people.
C hardware, software and communications middleware.
D computers, network, and people.
C hardware, software and communications middleware.
The software that effects transmission of data and control between client and server is called:(LO6)
A communications middleware.
B a front-end application.
C a back-end application.
D none of the options are correct.
A communications middleware.
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.(LO6)
A (i) and (iii)
B (i) and (ii)
C (ii) and (iii)
D (i), (ii) and (iii)
D (i), (ii) and (iii)
