Database Design Refreshment

What does CDM stand for in database design?

• Concept Design Model

• Conceptual Data Model

• Central Data Model

• Core Design Method

Which of the following is NOT part of a physical data model (PDM)?

• Table names

• Field data types

• Primary keys

• Use case diagrams

An attribute in an entity can best be described as:

• A unique identifier

• A relationship between entities

• A characteristic or property of an entity

• A constraint rule

In ERD, a one-to-many relationship is usually represented as:

• 1:N

• N:1

• M:M

• 1:1

Which of the following SQL statements is used to create a table?

• SELECT

• INSERT

• CREATE

• UPDATE

Which keyword is used in SQL to enforce uniqueness in a column?

• FOREIGN

• UNIQUE

• DEFAULT

• CHECK

Which of the following is used to represent a weak entity in an ER diagram?

• Rectangle

• Double rectangle

• Oval

• Double oval

What is the purpose of a primary key in a table?

• To allow null values

• To create foreign key

• To ensure row uniqueness

• To sort records

What is cardinality in ER modeling?

• The name of a relationship

• The number of attributes in an entity

• The number of entities involved in a relationship

• The number of rows in a table

Which of the following DML commands is used to modify existing records?

• SELECT

• MODIFY

• UPDATE

• INSERT