Question Discussion & Solution

MCQ

Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

Attributes of common

Tuple of common

Tuple of distinct

Attributes of distinct

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Similar Questions

MCQ

Which of the following can be addressed by enforcing a referential integrity constraint?

All phone numbers must include the area code

Certain fields are required (such as the email address, or phone number) before the record is accepted

Information on the customer must be known before anything can be sold to that customer

Then entering an order quantity, the user must input a number and not some text (i.e., 12 rather than

Discussion

MCQ

______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

Entity Integrity Constraints

Referential Integrity Constraints

Domain Integrity Constraints

Domain Constraints

Discussion

MCQ

Let us consider phone_number ,which can take single or several values . Treating phone_numberas an _________ permits instructors to have several phone numbers (including zero) associated with them.

Entity

Attribute

Relation

Value

Discussion

MCQ

Drop Table cannot be used to drop a table referenced by a _________ constraint.

Local Key

Primary Key

Composite Key

Foreign Key

Discussion

MCQ

An entity set that does not have sufficient attributes to form a primary key is termed a __________

Strong entity set

Variant set

Weak entity set

Variable set

Discussion

Banking

Engineering

General

Medical

Question Discussion & Solution

Report Error

Community Discussion

Similar Questions

Report Error

Report Error

Report Error

Report Error

Report Error

More Database Management System Topics

Miscellaneous or General

Relational Algebra

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER) Modeling

Advanced Data Modeling

Normalization

Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction and Concurrency

Data Warehouses

Database Administration

Mixed

Banking

Engineering

General

Medical

Question Discussion & Solution

report Report Error

forum Community Discussion

auto_awesome Similar Questions

report Report Error

report Report Error

report Report Error

report Report Error

report Report Error

category More Database Management System Topics

Miscellaneous or General

Relational Algebra

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER) Modeling

Advanced Data Modeling

Normalization

Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction and Concurrency

Data Warehouses

Database Administration

Mixed

Report Error

Community Discussion

Similar Questions

Report Error

Report Error

Report Error

Report Error

Report Error

More Database Management System Topics