Quizes 1+2 Flashcards

1
Q

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

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

Foreign

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Primary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

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

A

b) redundant

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

Conceptual Data Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Logical Data Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

Physical Data Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

M:N

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

Short Text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

DBMS stands for:

A

Database Management System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

e) all of the above

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

18
Q

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

A

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

19
Q

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

20
Q

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?

21
Q

Connected entities are called…

A

participants

22
Q

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

A

Connectivity

23
Q

What Cardinality expresses?

A

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

24
Q

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

A

Optional Relationship Participation

25
In what Relationship Participation an Entity occurrence requires corresponding occurrence in related entity
Mandatory Relationship Participation | –If no optionality symbol is shown on ERD, it is mandatory
26
Cardinality is also known as ....
the degree of the association
27
What Types of Relationships is created with a single relationship from one record in a table to a single record in another table ?
1:1
28
What Types of Relationships is created by including the primary key of the “one” table as a foreign key in the “many” table?
(1:M)
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?
(M:N)
30
In Chen's Notation, what does a rectangle represent?
Tables
31
In Chen's Notation, what does a diamond represent?
Relationships
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?
EMPLOYEES, DEGREES, PROJ
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?
EMPLOYEES(EMPID, LAST, FIRST, SALARY, DEPT, STARTDATE, PROJID); DEGREES(DEGREEID, INSTITUTION, LEVEL, DISCIPLINE, ABBREVIATION); PROJECTS(PROJID, PROJNAME, STARTDATE)
34
What is Data Modeling?
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
35
What Data Model is represented by | WHAT the system contains?
Conceptual
36
What Data Model is represented by | HOW to create (independent of DBMS)?
Logical
37
What Data Model is represented by | HOW it is created using DBMS?
Physical
38
What is a Primary Key?
Unique identifier that labels a certain record OR Given that data, you can find that row
39
What is a Foreign Key?
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
40
PK => FK
1:M
41
PK => PK
1:1