InformationManagementMidterms

Every relation has some conditions that must hold for it to be a valid relation

• Relational Constraint

• Domain Constraints

• Referential Integrity Constraints

• Entity Integrity Constraints

Constant specified between two relations or tables and used to maintain the consistency among the tuples in two relations?

• Relational Constraints

• Domain Constraints

• Referential Integrity Constraints

• Entity Integrity Constraints

Candidate key is chosen from?

• Super Key

• Surrogate Key

• Primary Key

• Composite Key

The mapping of a relationship depends on?

• No. of Regular Entities

• No. of Attributes

• No. of Records

• Types of Relationship

The SELECT operation in SQL is a:

• Data Query Language

• Data Manipulation Language

• Data Definition Language

• Data Control Language

Consisting of more than one value for a given entity

• Composite Attribute

• Derived Attribute

• Multivalued Attribute

• Key Attribute

Attribute which uniquely identifies each entity in the entity set?

• Composite Attribute

• Derived Attribute

• Multivalued Attribute

• Kay Attribute

Commands manage access permissions, ensuring data security by controlling who can perform certain actions on the database.

• Data Query Language

• Data Manipulation Language

• Data Definition Language

• Data Control Language

Which deals with database schemas of how the data should reside in the database

• Data Query Language

• Duta Manipulation Language

• Data Definition Language

• Data Control Language

Character values are and date values are

• Format-sensitive case-sensitive

• Case-sensitive format-sensitive

• Format-insensitive, case-insensitive

• Case-insensitive format-sensitive