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 relate to 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 what 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 true or false?

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

what is 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__(5 word)

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 Answer entity which is called what__(11 word).

Back 31

Associative 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.

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

False 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.

Front 35

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

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?a. ownsb. sellsc. has

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. what are the two rules?

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. contingentTrue 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

Front 50

For a data structure to be in First Normal Form it must have no (2 words)

Back 50

Repeating groups

Front 51

What attribute/s would make the best candidate/s for a Primary Key when combined with student_id

Back 51

paper_code Yes, you can see that a combination of values from student_id and paper_code, will enable you to locate and update any single course or grade on that row. Or if you know the paper_code you know the course.

Front 52

Given the following dataset, which of the following attribute/s has a partial dependency on the Primary Key?

Back 52

None of them

Front 53

Which attribute has a transitive dependency in this dataset?

Back 53

manager

Front 54

What Normal Form is this table in?

Back 54

0 Normal Form (0NF) Correct - No primary key and it has repeating groups (RegNo, Make, MilesDriven). Or one driver makes many trips

Front 55

Given the fields and only the values present, which one of the following is the "minimum" suitable choice for a Primary Key?

Back 55

driver_id + hire_date

Front 56

Given the Driver table below. What field has a partial dependency on the primary key?

Back 56

driver Correct as driver is functionally dependent on driver_id not hire_date . i.e if I know the driver_id I will know his name. I don't need both the driver_id and hire_date to get to this value

Front 57

Given the table below, what field is fully dependent on the primary key for this table?

Back 57

miles_driven

Front 58

Every non-key field must depend on the entire primary key, not part of a primary key made with more than one column, refers to which of the following normal forms?

Back 58

2NF

Front 59

A table is said to be in third normal form if it meets the following criteria. Which one of the following applies?

Back 59

Its already meets 2NF and has no transitive dependencies

Front 60

A DELETE anomaly is:

Back 60

Where you cannot remove part of a record from a table without also having to the whole record.

Front 61

An INSERT anomaly is:

Back 61

Where you cannot add a record to a table because an attribute value is dependent on the existence of a value in a related table.

Front 62

An UPDATE anomaly is:

Back 62

When one or more instances of duplicated data are changed, but not all.

Front 63

In Normalisation, which Normal Form requires the removal of repeating groups

Back 63

1st Normal Form (1NF)

Front 64

Which option ensures that are no orphan records in the database:

Back 64

Referential integrity