stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Database Design Flashcards | StudBud
Explore
/
Database Design
Database Design
40 terms
·
StudBud Administration
·
367 plays
#database ERD Notation Relationship Variations Diagram Rules
Flashcards
40 cards
F
Practice quiz
P
Host live
L
Questions
40
Answers
1
Which of the following describes Ternary Relationship?
Exists when two entities are associated in a relationship.
Both participants are from different entities.
Implies an association among three different entities.
Both participants in the relationship are the same entity.
2
What is the relationship between RECORDING to TRACK?
Many to One
One to One
Many to Many
One to Many
3
What is the relationship between FOOTBALL PLAYER to FOOTBALL TEAM?
Many to Many
One to Many
Many to One
One to One
4
Fistname
SINGLE-VALUED ATTRIBUTES
SIMPLE ATTRIBUTES
COMPOSITE ATTRIBUTES
MULTIVALUED ATTRIBUTES
5
Which of the following is NOT a derived attribute?
Date of Birt
Years of Service
GPA
AGE
6
Which of the following describes an Regular Entities?
Independent existence
Cannot exist except identifying relationships with an owner
Formed from many-to-many relationships between entity types.
Formed from one-to-many relationships between entity types.
7
Which of the following is TRUE about instance diagrams:
Shows 1-M self referencing
It is used to depict self-referencing relationships
Shows M-N self referencing
All options
8
Which of the following is NOT a composite attribute?
Name
Employee
Address
Birthday
9
What is the relationship between EMPLOYEE and JOB HISTORY?
One to One
One to Many
Many to One
Many to Many
10
Which of the following is NOT an example of Identification dependency?
Employees - Dependents
Subject - Professor
Loan - Payment
Room - Building
11
Which of the following has One-to-One relationship?
D
B
C
A
12
One of the differences between ERD and Relational DB diagram is:
Relational diagrams do not use names for relationships
ERDs use foreign keys but relational diagrams don't
Both ERD and Relational diagrams use names for relationships
ERD uses arrows as a cardinality symbol near entities
13
Which of the following describes Binary Relationship?
Both participants are from different entities.
Exists when two entities are associated in a relationship.
Both participants in the relationship are the same entity.
Implies an association among three different entities.
14
What is the relationship between STUDENT to SEAT?
Many to Many
One to One
Many to One
One to Many
15
Which of the following completeness rules is not mandatory:
Naming Rule
Entity Participation Rule
Cardinality Rule
Primary Key Rule
16
Which of the following DO NOT belong to the set of COMPLETENESS RULES?
Entity Participation Rule
Entity Name Rule
Naming Rule
Primary Key Rule
17
Which of the following is an ADVANTAGE for unstored DERIVED ATTRIBUTE?
Increases data access time
Uses CPU processing cycles
Computation always yields current value
Adds coding complexity to queries
18
Which of the following has MANY TO MANY relationship?
C
B
D
A
19
Relationship in ERD can NOT connect an entity to itself
TRUE
FALSE
20
Collections of physical things such as books, people, and places, as well as events.
Attributes
Entity Types
Diagram
Relationship
21
Which of the following is NOT a connection consistency rule:
Relationship/relationship rule
Primary key rule
Relationship/Entity rule
Redundant Foreign Key rule
22
Which of the following states: All entity types participate in at least one relationship.
Naming Rule
Primary Key Rule
Entity Participation Rule
Cardinality Rule
23
What is the relationship between ALBUM to TRACK?
One to One
Many to One
One to Many
Many to Many
24
Which of the following is NOT a required attribute for personal account ?
Email
Name
Favorite Color
Password
25
Which of the following describes an Weak Entities?
Cannot exist except identifying relationships with an owner
Formed from one-to-many relationships between entity types.
Formed from many-to-many relationships between entity types.
Independent existence
26
E-mail Address
SIMPLE ATTRIBUTES
SINGLE-VALUED ATTRIBUTES
COMPOSITE ATTRIBUTES
MULTIVALUED ATTRIBUTES
27
Which of the following is an identification dependency symbol?
PK and FK
Solid line:relationship & diagonal lines:corners of entities
M-N classification
Dotted lines in relationship
28
Identification Dependency Rules involve the following EXCEPT:
Cardinality Rule
Identifying Relationship Rule
Identification Dependency Cardinality Rule
Weak Entity Type Rule
29
Which of the following describes Unary Relationship?
Exists when two entities are associated in a relationship.
Both participants in the relationship are the same entity.
Implies an association among three different entities.
Both participants are from different entities.
30
Which of the following rules states: Foreign keys are not used.
Relationship/Relationship Connection Rule
Attribute Name Rule
Relationship/Entity Connection Rule
Redundant Foreign Key Rule
31
Which of the following specifies: Relationships are not connected to other relationships.
Redundant Foreign Key Rule
Relationship/Entity Connection Rule
Cardinality Rule
Relationship/Relationship Connection Rule
32
Relationship can have attributes in ERD
FALSE
TRUE
33
Which of the following are named associations among entity types.
Relationship
Diagram
Entity Types
Attributes
34
What is the meaning of the abbreviation UML ?
United Modeling List
United Modeling Language
Unified Model List
Unified Modeling Language
35
What is the relationship between PROFESSOR to SECTION?
One to Many
Many to One
Many to Many
One to One
36
The followings are Cardinality symbols EXCEPT:
Oval shape
$ Sign
Perpendicular line
Crow's foot
37
What is the relationship between SONG to RECORDING?
Many to One
One to One
One to Many
Many to Many
38
Which of the following is NOT an example of a multi-valued attribute for a person?
Parts
Cellphone Number
Address
Hobbies
39
What is the relationship between HUSBAND to WIFE?
Many to One
One to Many
One to One
Many to Many
40
Which of the following describes an Associate Entities?
Formed from one-to-many relationships between entity types.
Formed from many-to-many relationships between entity types.
Independent existence
Cannot exist except identifying relationships with an owner
