Data Fundamentals

Front 1

A collection of data stored in a logical, organised manner is called a:

Back 1

Database

Front 2

A database primarily used for day to day data entry e.g. recording a sale is regarded as what type of data processing system?

Back 2

Online Transactional Processing system (OLTP)

Front 3

A field in one relational database table that is linked to the primary key in another table in order to create a relationship is:

Back 3

A foreign key

Front 4

Which of the following statements is true of an Object-Oriented Database Management System (OODBMS)?

Back 4

Object Oriented DBMS's store and retrieve whole objects Object identifiers are managed behind the scenes (OID) An Object Oriented DBMS can be resource intensive (memory) Object Oriented DBMS's preserve object relationships.

Front 5

A similar concept to the Hierarchical database model was the ________model, which enable a child record to have more than one parent. (7 letters)

Back 5

Network

Front 6

An early database model that allows a child record to have only one parent is called a _______database model. (12 letters)

Back 6

Hierarchical

Front 7

Having the same data stored in more than one place in a relational database is referred to as data

Back 7

redundancy

Front 8

In a Network database model, the parent node is referred to as the

Back 8

owner

Front 9

One of the major problems associated with a Hierarchical database was that it contained lots of_____data

Back 9

redundant

Front 10

What database model links tables together using the concept of PRIMARY and FOREIGN KEYS? (10 letters)

Back 10

RELATIONAL

Front 11

A flat file database primarily consists of unrelated files

Back 11

True

Front 12

The Network database model reduced the amount of redundant data

Back 12

True

Front 13

What database model notation does this diagram represent (b)?

Back 13

Object-Oriented (UML)

Front 14

What database model notation does this diagram represent (c)?

Back 14

Information Engineering

Front 15

What database model notation does this diagram represent (d)?

Back 15

Barker Notation

Front 16

What database model notation does this diagram represent (e)?

Back 16

Chen

Front 17

What database model notation does this represent (a)?

Back 17

Integration DEFinition for Information Modelling (IDEF1X)

Front 18

In a NETWORK database model, the link that connects the parent node and the child node together is referred to as a ___? (3 letters)

Back 18

set

Front 19

The first type of database that offered data security that was provided and enforced by the DBMS was what? (12 letters)

Back 19

Hierarchical

Front 20

Select each statement that is true of a Flat file database from the list.

Back 20

Consists of only one file or tableIs one of the earliest forms of databaseA simple database program whose records have no relationship to one anotherA plain text file that stores multiple records separated by delimitersHas a throw everything into one big table design

Front 21

Given the crowsfoot notation shown, use the Internet and locate another name for this notation. 2 words(11 11)

Back 21

Information Engineering

Front 22

Entities in an ERD, are depicted as rectangles, and the names given are___ ? (8 letters)

Back 22

Singular

Front 23

Given the table shown below, I could add a new student without adding a paper on the same row.

Back 23

False

Front 24

The image depicts what kind of relationship if each table is read from both ways?

Back 24

Many-To-Many

Front 25

Given the table shown below, I could delete a paper without deleting a student on the same row.

Back 25

Correct, PaperID is part of a joint primary key, therefore the PaperID value cannot be empty (NULL). This is referred to as a DELETE anomaly The correct answer is 'False'.

Front 26

You need to modify values in more than one location in a database. This could cause spelling inconsistencies. This is what is known as an UPDATE anomaly True or False

Back 26

True

Front 27

When reviewing analysis documentation the key to identifying possible entities is to identify

Back 27

nouns

Front 28

A pair of tables bears a one-to-one relationship when:A single record in the first table is related to only one record in the second table, and a single record in the second table is related to one or more records in the first table. True or False?

Back 28

False

Front 29

This relationship indicates that a customer must have one or more orders. True or False

Back 29

False

Front 30

The entity "VEHICLE_PART" name is derived from the names of other two entities. This style of entity naming occurs mostly from which of the two types of relationship categories:

Back 30

Ownership-OrientedCorrect, usually the VEHICLE_PART entity would only have two fields, the primary key from the VEHICLE entity and the primary key from the PART entity. They are each FOREIGN KEYS in the VEHICLE_PART table, and may together form the PRIMARY KEY in the VEHICLE_PART table.

Front 31

To resolve many-to-many relationships in a Conceptual ERD, you need to create an Answerentity.

Back 31

Correct, the primary keys from both outer tables are then placed as foreign keys in the new associative table. This creates the relationship between all three entities.The correct answer is: Associative

Front 32

When you represent an entity on a diagram it represents a single record. True or False?

Back 32

False

Front 33

Entities in an ERD, are depicted as rectangles, and the names are capitalised and singular. True or False

Back 33

True

Front 34

One-to-One relationships are a common ocurrance in relational databases. True or False?

Back 34

Correct, this is rare. The two tables are usually made into one bigger table and queries (views) are created to make the data available to who ever has permission to view that subset of the data.The correct answer is 'False'.

Front 35

When referring to Relationship Context Categories, which one of the following relationship names is NOT an indication of an Action-Oriented relationship?

Back 35

has

Front 36

When referring to Relationship Context Categories, which one of the following relationship names is NOT an indication of an Ownership-Oriented relationship?

Back 36

sellCorrect, because the relationship name indicates a form of action (Action-Oriented) relationship exists between the two entities. Action-Oriented names indicate that something happens, like an event. In the case of the word "sell", we would record the fact that one entity sold items to another entity.

Front 37

The entity "VEHICLE_PART" name is derived from the names of other two entities. This style of entity naming occurs mostly from which of the two types of relationship categories:

Back 37

Ownership-Oriented

Front 38

Which set of attributes are the repeating group for this dataset?

Back 38

paper_code + final_grade Correct , You can see that the one student "Jill" has many papers courses and grades. So the repeating group is the many side of the relationship.

Front 39

When referring to Relationship Context Categories, which one of the following relationship names is NOT an indication of an Action-Oriented relationship?a. visitb. has c. teachd. performe. make

Back 39

hasCorrect, "has" is not a doing word (action or event)

Front 40

Which one of the following, does NOT refer to the rules of First Normal Form (1NF)a. Data item cannot be broken down any further (atomic)b. No Repeating Groupsc. No partial dependencies Correct. This rule refers to Second Normal Form (2NF).d. Each row must have a unique identifier (Primary Key).e. Each column has an unique name

Back 40

No partial dependencies

Front 41

(Google Research Question) In database normalization, which one of the following is NOT a recognised normal form?a. 4th Normal Formb. 2nd Normal Formc. 6th Normal Formd. Boyce Codd Normal Form (BCNF)e. 3rd Normal Formf. 5th Normal Formg. None, they are all recognised normal forms h. 1st Normal Form

Back 41

None, they are all recognised normal forms

Front 42

Ensuring that each column has an unique name is undertaken during which normal form process?a. 3NFb. 2NFc. 1NF d. 0NF

Back 42

c. 1NF

Front 43

Cardinality specifies two business rules. Select the two rules from the list below:

Back 43

The minimum number of each entity that can participate in the relationshipThe maximum number of each entity that can participate in the relationship.

Front 44

Showing the exact number of how many of each entity can be related to another entity is usually shown in an ERD using the Crow’s Foot notation. True or False?

Back 44

False

Front 45

Any attribute that can have multiple values associated with a single instance of some entity, is in normalisation referred to as a ___ ___ ? (2 words) e.g.

Back 45

Repeating Group

Front 46

The 3 relationship dependencies possible are:1. mandatory2. optional3. contingent4. True or False?

Back 46

True

Front 47

The type of dependency in the relationship shown indicates that this is a Answer relationship.

Back 47

mandatory

Front 48

The type of relationship dependency shown indicates that this is an Answer relationship.

Back 48

optional

Front 49

The type of relationship dependency shown indicates that this is a Answer relationship.

Back 49

contingent