Deck 3: Database Concepts I

Question 1

Which of the following is not a problem that a normalisation process is designed to overcome?

A)Repeating groups
B)Data anomalies
C)Missing data
D)Data redundancies

Answer 1

C

Question 2

The particular values for a customer are stored in the ____ of a ____ within the customer ________.

A)fields,record,table
B)record,fields,table.
C)fields,record,entity.
D)fields,table,database.

Answer 2

A

Question 3

Which one of the following is not a crucial factor for maximising the benefits offered by relational databases?

A)careful data collection
B)careful data relationship design
C)careful database modelling
D)careful systems implementation

Answer 3

A

Question 4

DBMS stands for:

A)Database Management Scheme
B)Database Management Structure
C)Database Management Software
D)Database Management System

Question 5

If data are captured and stored at their most basic level,then:

A)these data can be used to answer a very limited number of questions when they are aggregated at a certain level.
B)these data can be used to answer quite a few questions when they are aggregated at a certain level.
C)these data cannot be used to answer any question unless they are combined with some other data at a higher aggregated level.
D)these data are not suitable for answering questions.

Question 6

In any organisation,what three characteristics of information are crucial for good decision making and reporting?

A)abundant,qualitative,and quantitative
B)accurate,relevant,and timely
C)frequently collected,broadly covered,and up-to-date
D)rich,complete,and precise

Question 7

Information is:

A)the same as data.
B)data that is processed in a meaningful form
C)Less useful than data.
D)raw facts describing an event.

Question 8

Accurate,relevant and timely information comes from:

A)a properly designed database management system
B)sound data transformation and manipulation processes
C)quality data capture,storage and management
D)correctly normalised data

Question 9

Data can be described as:

A)the same as information.
B)the raw facts relating to or describing an event
C)the primary output of an AIS.
D)more useful than information.

Question 10

In relational database,a connected set of fields that describe a person,place or thing is referred to as:

A)a table
B)a record
C)a file
D)a matrix

Question 11

An employee in one department such as sales wanting to check on inventory levels would have to contact the inventory department and enquire about inventory balances.This indicates an absence of:

A)A centralised database system
B)Information sharing
C)A DBMS
D)A distributed database system

Question 12

An attribute (or column)that uniquely identifies a particular object (or row)in the table is called:

A)Foreign key
B)Unique key
C)Primary key
D)Composite key

Question 13

A table is:

A)a collection of attributes that describe an entity
B)a collection of objects that describe an entity
C)smaller than a field
D)none of the options are correct

Question 14

Relational databases typically store data:

A)in a number of files
B)in a number of tables
C)in a number of fields
D)none of the options are correct

Question 15

How can data about customer contact details and data about their orders be stored in a database?

A)Using a single table called an entity.
B)Only the customer data can be stored in the database.
C)Using at least two tables because there are two entities.
D)By storing the customer details in a table and the orders as a relationship.

Question 16

In relational database,the columns and rows in a table represent,respectively:

A)attributes and objects
B)entities and relationships
C)objects and attributes
D)relationships and entities

Question 17

With regards to a database system,which of the following statements is NOT true?

A)Database systems are being phased out in favour of new legacy systems.
B)A database system allows managers to access and evaluate the data they require to make decisions.
C)A database system enables all the data of the organisation to be contained within one system.
D)A database system helps breaking down functional barriers and facilitates data-sharing.

Question 18

When all data are stored in a central place,which of the following is not essential to ensure data are protected?

A)Data privacy
B)Data security
C)Data backup
D)Data normalisation

Question 19

Data or facts that are processed in a meaningful form become:

A)Intelligence
B)Information
C)Knowledge
D)Wisdom

Question 20

A record is:

A)a connected set of fields that describe a person,place or thing
B)a connected set of tables that describe a person,place or thing
C)smaller than a field
D)none of the options are correct

Question 21

Database systems are designed to:

A)eliminate the repetition of data and the incidence of inconsistent data by ensuring data is structured so that it is stored in multiple locations.
B)eliminate the repetition of data and the incidence of inconsistent data by ensuring data is structured so that it is stored in only one location.
C)increase the repetition of data and the incidence of inconsistent data by ensuring data is structured so that it is stored in multiple locations.
D)increase the repetition of data and the incidence of inconsistent data by ensuring data is unstructured but that it is stored in only one location.

Question 22

Which of the following is NOT a database model?

A)Network
B)Relational
C)SQL
D)Hierarchical

Question 23

"Inconsistencies or errors that exist in a database because of entry or changes" are referred to as:

A)Data inaccuracies
B)Data anomalies
C)Data abnormalities
D)Data irregularities

Question 24

In terms of data redundancy,an important aspect of a relational database is that the tables must be carefully defined to provide __________ with minimum issues.

A)expandability
B)functionality
C)flexibility
D)scalability

Question 25

The process of developing ER diagrams is:

A)Iterative
B)Nondiscretionary
C)Linear
D)Discrete

Question 26

"Data that provide a consistent and correct representation regardless of where they are sourced from within a file system" is referred to as:

A)Data consistency
B)Data integrity
C)Data reliability
D)Data uniformity

Question 27

A ________ key allows the user to search on an attribute other than the attribute(s)that form the primary key:

A)Secondary
B)Composite
C)Foreign
D)Subordinate

Question 28

Which of the following is NOT an instance of data anomalies?

A)Creation anomalies
B)Insertion anomalies
C)Deletion anomalies
D)Modification anomalies

Question 29

Refer to the ER diagram in the previous question.The "charges time to" entity is a result of:

A)The resolution of a many-to-many relationship
B)The resolution of a one-to-many relationship
C)The resolution of a one-to-one relationship
D)The resolution of an unnormalised relationship

Question 30

An entity relationship diagram is a method for depicting:

A)The logical view of a database.
B)The physical view of a database.
C)The relationship between the user interface and the DBMS.
D)An implementation of a client-server system.

Question 31

A database system consists of:

A)Software,hardware,and data
B)Software,hardware,people and data
C)Software,hardware,procedures and data
D)Software,hardware,people,procedures and data

Question 32

Refer to the following ER diagram

The "Charges time to" shape represents a:

A)Relationship
B)Linking entity
C)Data flow
D)Attribute

Question 33

Data redundancy occurs when:

A)we keep data that has not been used by an organisation for a number of years
B)the same data is stored in multiple locations.
C)emails are stored by an organisation for longer than six months.
D)when we have the wrong information stored on a customer file

Question 34

Data anomalies:

A)are inconsistencies or errors that exist in a database because of entry or changes
B)are useful in ensuring the integrity of data
C)provide a useful backup function in a database
D)none of the options are correct

Question 35

Which of the following is less likely to be the job of a database administrator?

A)Define what data is required and how it should be defined and captured.
B)Control access by users to the database
C)Maintain the data dictionary
D)Oversee backup and recovery in the DBMS

Question 36

Which of the following is listed in the order from smallest to largest?

A)field,data,record,file
B)file,field,data,record
C)record,file,data,field
D)data,field,record,file

Question 37

Data redundancy occurs when the same information is stored in multiple locations in an organisation.Which of the following is NOT true?

A)Data redundancy can lead to data inconsistency.
B)Data redundancy can lead to data anomalies.
C)Data redundancy can lead to repeated data.
D)Data redundancy can provide benefits through having two sources of information.

Question 38

Data redundancy:

A)can lead to a number of data anomalies
B)is useful in ensuring the integrity of data.
C)provides a useful backup function in a database.
D)none of the options are correct.

Question 39

The database model of choice for the development of most new information systems today is:

A)relational
B)hierarchical.
C)network.
D)object oriented.

Question 40

In database terms,the instructions and rules that govern the design and use of the software outside programming are referred to as:

A)Procedures
B)Policies
C)Processes
D)Routines

Question 41

Describe the key responsibilities of database administrator,database designers,and systems analysts involved in a database system.

Question 42

Which of the following statement regarding ER diagrams is correct?

A)ER diagrams look at entities and their relationships from a very detailed perspective.
B)ER diagram is a bottom-up way of viewing the organisation.
C)ER diagram is a bottom-up approach of developing a database model.
D)Understanding how to read and interpret E-R diagrams is critical for accountants.

Question 43

What are the three possible types of relationship in ER diagrams? Explain.

Question 44

Student Table

Course Table

The Course_ID in the student table is best described as:
Examine the database tables in Q44.Which of the following statement is true?

A)The relationship between student and course is best interpreted as 1:1.
B)The relationship between student and course is best interpreted as 1:M.
C)The relationship between student and course is best interpreted as M:N.
D)The relationship between student and course cannot be determined.

Question 45

Define relational database and discuss its constituting elements.

Question 46

What is the highest normal form?

A)Third
B)Fourth
C)Fifth
D)Sixth

Question 47

How are 1:N,1:1,and N:M relationships implemented in a database system?

Question 48

What are the two approaches to database design? Discuss their differences and relationship.

Question 49

What are the advantages of database systems?

Question 50

Describe the three types of data anomalies.

Question 51

Student Table

Course Table

The Course_ID in the student table is best described as:
Examine the database tables in Q44.Given that the relationship between the student and the course is 1:1,which of the following statement is correct? (i)Only the Course_ID should be added to the student table (ii)Only the Student_ID should be added to the student table (iii)Course_ID should be added to the student table and Student_ID should be added to the course table.

A)Either (i)or (ii)
B)Both (i)and (ii)
C)Both (ii)and (iii)
D)Both (i)and (iii)

Question 52

What are the four steps in developing ER diagrams?

Question 53

What are the important reasons for database modelling?

Question 54

Student Table

Course Table

The Course_ID in the student table is best described as:
Examine the database tables in Q 44.What is the use of the Course_ID in the student table?

A)To link the student table to the course table
B)To back up Course_ID information in the student table
C)Both to link the student table to the course table and to back up Course_ID information in the student table
D)Neither linking the student table to the course table nor backing up Course_ID information in the student table

Question 55

Which of the following statement regarding normalisation is incorrect?

A)Normalisation is the process of assigning attributes to entities to eliminate repeating groups and data redundancies.
B)The goal of normalisation is to form tables representing entities that promote structural and data independence.
C)Normalisation maximises the efficiency of structure.
D)Normalisation is the top-down view of designing a database.

Question 56

Student Table

Course Table

The Course_ID in the student table is best described as:
Examine the database tables in Q44.If Course_ID is removed from the student table,then when a query is performed on the student table: (i)It is unable to determine the name of the course related to the student (ii)It is unable to determine the ID of the course related to the student (iii)It is unable to determine the course_semester related to the student.

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

Question 57

The following database tables are used
Student Table

Course Table

The Course_ID in the student table is best described as:

A)An attribute
B)A foreign key
C)A primary key
D)A composite primary key

Question 58

Give an example of how data redundancy can occur.

Question 59

Originally,an organisation has sourced all its products from one supplier.Now,the organisation has changed its mind and started to source all its products from various suppliers.This is reflected on an ER diagram as:

A)A change in the relationship between the organisation entity and the supplier entity.
B)A change in the cardinality associated with the supplier side relationship
C)A change in the number of supplier entities
D)A change in the cardinality associated with the organisation side of the relationship

Question 60

How is the design of a relational database determined in an organisation?

A)each department is given an allocation of tables
B)senior management decide how many tables are needed.
C)IT professionals advise on the best design.
D)by modelling the rules that describe how the business works.