Quizes 1+2

Question 1

In Microsoft Access when defining relationships, do NOT select Enforce Referential Integrity to ensure the data is accurate. True or false?

Answer 1

false

Question 2

The _____ key is an attribute in one table whose values must either match the primary key in another table or be null.

Answer 2

Foreign

Question 3

The ____ key of a table is the column or collection of columns that uniquely identifies a row in the table.

Answer 3

Primary

Question 4

A good data model should have all of the following characteristics EXCEPT:

a) stable and flexible
b) redundant
c) reusable
d) accurate

Answer 4

b) redundant

Question 5

Another word for entity when referring to database design is…?

Answer 5

Table

Question 6

Highest level data model that defines what the system should include?

Answer 6

Conceptual Data Model

Question 7

Data model that includes relationships and entities but is independent of the DBMS.

Answer 7

Logical Data Model

Question 8

Data model that includes the DBMS and storage estimates for all files and data.

Answer 8

Physical Data Model

Question 9

At college, a student takes many courses and courses contain many students. What type of relationship is this?

Answer 9

M:N

Question 10

Use the following datatype in Microsoft Access to store a customer number that has format of three letters, a hyphen and then four
numbers (for example CSN-5730).

Answer 10

Short Text

Question 11

DBMS stands for:

Answer 11

Database Management System

Question 12

Who should be involved in data modelling?

a) owners/ sponsors
b) business analysts and specialists
c) data modeler, process modeller, program designer, physical database designer
d) end users
e) all of the above

Answer 12

e) all of the above

Question 13

In Microsoft Access, you must select save after entering a new record into a table. True or False?

Answer 13

False

Question 14

Microsoft Access determines the relationships between tables automatically. True or False

Answer 14

False

Question 15

Mandatory participation from one entity to another means the minimum cardinality is zero. True or False?

Answer 15

False

Question 16

The cardinality expresses the number of of records in a related table that one record can be associated with. True or False?

Answer 16

True

Question 17

A Chen ERD uses the following shape between entities to describe the relationship:

Answer 17

Diamond

Question 18

Many to many (M:N) relationships cannot be created in a relational DBMS. They must be resolved by

a) enforcing referential integrity
b) setting the participation as optional
c) creating a bridge/ composite entity between the two entities
e) deleting one of the entities from the database

Answer 18

c) creating a bridge/ composite entity between the two entities

Question 19

The maximum cardinality value is not shown in a Crow’s Foot diagram. True or False?

Answer 19

True

Question 20

Question 15
Valid relationship types include: zero to zero (0:0), one to one (1:1), one to many (1:M) and many to many (M:N). True or False?

Answer 20

False

Question 21

Connected entities are called…

Answer 21

participants

Question 22

____ describes relationship classification–1:1, 1:M, M:N

Answer 22

Connectivity

Question 23

What Cardinality expresses?

Answer 23

It expresses the number of entity occurrences(records) associated with one occurrence of related entity

Question 24

In what Relationship Participation an entity occurrence does not require a corresponding occurrence in related entity?

Answer 24

Optional Relationship Participation

Question 25

In what Relationship Participation an Entity occurrence requires corresponding occurrence in related entity

Answer 25

Mandatory Relationship Participation

–If no optionality symbol is shown on ERD, it is mandatory

Question 26

Cardinality is also known as ….

Answer 26

the degree of the association

Question 27

What Types of Relationships is created with a single relationship from one record in a table to a single record in another table ?

Answer 27

1:1

Question 28

What Types of Relationships is created by including the primary key of the “one” table as a foreign key in the “many” table?

Answer 28

(1:M)

Question 29

What Types of Relationships is created with a new table whose primary key is the combination of the primary keys of the original tables or new field created to represent PK?

Answer 29

(M:N)

Question 30

In Chen’s Notation, what does a rectangle represent?

Answer 30

Tables

Question 31

In Chen’s Notation, what does a diamond represent?

Answer 31

Relationships

Question 32

An employee may have many degrees and each degree may have been earned by many employees. Employees are assigned to one project at a time. Each project can have many employees assigned to it.
What are the entities?

Answer 32

EMPLOYEES, DEGREES, PROJ

Question 33

An employee may have many degrees and each degree may have been earned by many employees. Employees are assigned to one project at a time. Each project can have many employees assigned to it.
What are possible attributes within each entity?

Answer 33

EMPLOYEES(EMPID, LAST, FIRST, SALARY, DEPT, STARTDATE, PROJID);
DEGREES(DEGREEID, INSTITUTION, LEVEL, DISCIPLINE, ABBREVIATION);
PROJECTS(PROJID, PROJNAME, STARTDATE)

Question 34

What is Data Modeling?

Answer 34

It is the process of creating a model for the data to be stored in a database. Helps in the visual representation of the data

Question 35

What Data Model is represented by

WHAT the system contains?

Answer 35

Conceptual

Question 36

What Data Model is represented by

HOW to create (independent of DBMS)?

Answer 36

Logical

Question 37

What Data Model is represented by

HOW it is created using DBMS?

Answer 37

Physical

Question 38

What is a Primary Key?

Answer 38

Unique identifier that labels a certain record
OR
Given that data, you can find that row

Question 39

What is a Foreign Key?

Answer 39

A column/ field in a table also found in another table;
Provides the link between the tables;
May seem like duplicate data but is required to establish the relationship

Question 40

PK => FK

Answer 40

1:M

Question 41

PK => PK

Answer 41

1:1