DATA MODELLING EXAMINATION QUESTIONS AND
CORRECT ANSWER WITH EXPLANATION GRADED A+
STUDY GUIDE SOUTHERN NEW HAMPSHIRE UNIVERSITY
1. Data modeling is:
A. Creating a structured representation of data
B. Deleting databases
C. Encrypting files
D. Building hardware
Answer: A
Rationale: Data modeling organizes how data is structured and related.
2. The main purpose of data modeling is to:
A. Organize and define data structures
B. Increase storage size
C. Improve internet speed
D. Delete records
Answer: A
Rationale: It ensures data is structured for use.
3. A data model represents:
A. How data is stored and related
B. Computer hardware
C. Network cables
D. Programming languages
Answer: A
Rationale: It shows structure and relationships.
4. Entity in data modeling means:
,A. A real-world object or concept
B. A database error
C. A file type
D. A network device
Answer: A
Rationale: Entities represent things like students or products.
5. Attribute refers to:
A. Property of an entity
B. Database server
C. Hardware component
D. Network protocol
Answer: A
Rationale: Attributes describe entities.
6. A relationship in data modeling is:
A. Association between entities
B. Hardware connection
C. Software installation
D. File compression
Answer: A
Rationale: Shows how entities are connected.
7. Primary key is:
A. Unique identifier of a record
B. Duplicate value
C. Random field
D. Encryption key
Answer: A
Rationale: Uniquely identifies records.
8. Foreign key is:
, A. A field linking two tables
B. A hardware device
C. A random value
D. A file format
Answer: A
Rationale: Creates relationships between tables.
9. ERD stands for:
A. Entity Relationship Diagram
B. Electronic Record Data
C. External Routing Device
D. Entity Record Design
Answer: A
Rationale: Visual representation of data models.
10. Cardinality refers to:
A. Number of relationships between entities
B. File size
C. Encryption level
D. CPU speed
Answer: A
Rationale: Defines relationship quantity.
11. One-to-one relationship means:
A. One entity linked to one entity
B. One to many
C. Many to many
D. No relationship
Answer: A
Rationale: Single pairing relationship.
12. One-to-many relationship means:
CORRECT ANSWER WITH EXPLANATION GRADED A+
STUDY GUIDE SOUTHERN NEW HAMPSHIRE UNIVERSITY
1. Data modeling is:
A. Creating a structured representation of data
B. Deleting databases
C. Encrypting files
D. Building hardware
Answer: A
Rationale: Data modeling organizes how data is structured and related.
2. The main purpose of data modeling is to:
A. Organize and define data structures
B. Increase storage size
C. Improve internet speed
D. Delete records
Answer: A
Rationale: It ensures data is structured for use.
3. A data model represents:
A. How data is stored and related
B. Computer hardware
C. Network cables
D. Programming languages
Answer: A
Rationale: It shows structure and relationships.
4. Entity in data modeling means:
,A. A real-world object or concept
B. A database error
C. A file type
D. A network device
Answer: A
Rationale: Entities represent things like students or products.
5. Attribute refers to:
A. Property of an entity
B. Database server
C. Hardware component
D. Network protocol
Answer: A
Rationale: Attributes describe entities.
6. A relationship in data modeling is:
A. Association between entities
B. Hardware connection
C. Software installation
D. File compression
Answer: A
Rationale: Shows how entities are connected.
7. Primary key is:
A. Unique identifier of a record
B. Duplicate value
C. Random field
D. Encryption key
Answer: A
Rationale: Uniquely identifies records.
8. Foreign key is:
, A. A field linking two tables
B. A hardware device
C. A random value
D. A file format
Answer: A
Rationale: Creates relationships between tables.
9. ERD stands for:
A. Entity Relationship Diagram
B. Electronic Record Data
C. External Routing Device
D. Entity Record Design
Answer: A
Rationale: Visual representation of data models.
10. Cardinality refers to:
A. Number of relationships between entities
B. File size
C. Encryption level
D. CPU speed
Answer: A
Rationale: Defines relationship quantity.
11. One-to-one relationship means:
A. One entity linked to one entity
B. One to many
C. Many to many
D. No relationship
Answer: A
Rationale: Single pairing relationship.
12. One-to-many relationship means:
