The concept of Data modelling part 1

What information is typically NOT found in a data dictionary?

• Data type
• Table name
• Database size
• Field constraints

An ERD (Entity-Relationship Diagram) primarily represents:

• Processes within a system
• Relationships between entities
• User workflows
• Performance metrics

What does cardinality represent in an ERD?

• The order of fields in a database
• The number of attributes in a table
• The minimum and maximum relationships between entities
• The total number of entities in a system

Which crow's foot notation symbol is used to represent a one-to-many relationship?

• A single line
• A double line
• A circle and a crow's foot
• A crow's foot at one end

In crow's foot notation, what does a double line signify in terms of cardinality?

• A mandatory relationship
• An optional relationship
• A many-to-many relationship
• A recursive relationship

Which of the following would NOT typically appear in an ERD?

• Entities
• Relationships
• Use cases
• Attributes

What is the main purpose of using crow's foot notation in an ERD?

• To design user interfaces
• To specify complex database functions
• To clearly depict the cardinality between entities
• To map the flow of data across systems

Which of the following is an example of cardinality in a database model?

• 1:1
• 2:1
• 1
• Both A and C

In an ERD using crow's foot notation, how is an optional relationship depicted?

• By a dashed line
• By a single line
• By a circle (o)
• By a diamond symbol

Which of the following is NOT a benefit of using a data dictionary?

• Reducing data redundancy
• Improved data consistency
• Provides data flow diagrams
• Easier database maintenance