Quizes 1+2 Flashcards
In Microsoft Access when defining relationships, do NOT select Enforce Referential Integrity to ensure the data is accurate. True or false?
false
The _____ key is an attribute in one table whose values must either match the primary key in another table or be null.
Foreign
The ____ key of a table is the column or collection of columns that uniquely identifies a row in the table.
Primary
A good data model should have all of the following characteristics EXCEPT:
a) stable and flexible
b) redundant
c) reusable
d) accurate
b) redundant
Another word for entity when referring to database design is…?
Table
Highest level data model that defines what the system should include?
Conceptual Data Model
Data model that includes relationships and entities but is independent of the DBMS.
Logical Data Model
Data model that includes the DBMS and storage estimates for all files and data.
Physical Data Model
At college, a student takes many courses and courses contain many students. What type of relationship is this?
M:N
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).
Short Text
DBMS stands for:
Database Management System
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
e) all of the above
In Microsoft Access, you must select save after entering a new record into a table. True or False?
False
Microsoft Access determines the relationships between tables automatically. True or False
False
Mandatory participation from one entity to another means the minimum cardinality is zero. True or False?
False
The cardinality expresses the number of of records in a related table that one record can be associated with. True or False?
True
A Chen ERD uses the following shape between entities to describe the relationship:
Diamond
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
c) creating a bridge/ composite entity between the two entities
The maximum cardinality value is not shown in a Crow’s Foot diagram. True or False?
True
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?
False
Connected entities are called…
participants
____ describes relationship classification–1:1, 1:M, M:N
Connectivity
What Cardinality expresses?
It expresses the number of entity occurrences(records) associated with one occurrence of related entity
In what Relationship Participation an entity occurrence does not require a corresponding occurrence in related entity?
Optional Relationship Participation