Database Design Quiz

What are the building blocks of the E-R model?

• Variables, Functions, Loops, Conditions, Arrays

• Classes, Objects, Inheritance, Polymorphism, Encapsulation

• Tables, Columns, Rows, Keys, Indexes

• Entities, Attributes, Entity Sets, Relationship, Business Rules

What are the building blocks of the E-R model?

• Variables, Functions, Loops, Conditions, Arrays

• Classes, Objects, Inheritance, Polymorphism, Encapsulation

• Tables, Columns, Rows, Keys, Indexes

• Entities, Attributes, Entity Sets, Relationship, Business Rules

What is an Entity Set?

• A collection of entities of the same type

• A single entity in the database

• A relationship between entities

• A business rule constraint

What do Attributes represent in the E-R model?

• Characteristics/properties that identify an entity or relationship

• Constraints on the database schema

• Data types used in the database

• Actions performed on entities

Why do we use E-R models in database design?

• To slow down the database development process

• To complicate the database structure and confuse users

• To simplify the database design process and facilitate communication between users and designers

• To eliminate the need for relational models

What is Cardinality in E-R diagrams?

• Specifies how many instances of an entity relate to one instance of another entity

• Specifies the color of entities in the diagram

• Specifies the shape of entities in the diagram

• Specifies the size of entities in the diagram

What are Business Rules in database design?

• Constraints on an organization's activities that must be implemented in the database

• Guidelines for creating E-R diagrams

• Rules for naming entities and attributes

• Rules for defining relationships between entities

What is the most popular database model?

• Object Oriented Model

• Network Model

• Hierarchic Model

• Relational Model

What is the purpose of an E-R Diagram?

• To design user interfaces for the database

• To generate reports from the database

• To graphically represent entities and their relationships in a database

• To write SQL queries for database operations

What is the key function of an Entity in the E-R model?

• To generate reports from the database

• To define relationships between entities

• To store data about a person, place, thing, or event

• To enforce business rules in the database