Which of the following is NOT a component of the relational model?

A logical data structure represented by relations

A set of integrity rules to enforce consistency

A set of operations that defines how data is manipulated

What does a table (relation) represent in the relational model?

A two-dimensional structure composed of rows and columns

A mathematical function used in databases

A storage system for unstructured data

Which of the following is true about values in a column?

They must conform to the same data format

They can have different data formats in the same column

A column can have multiple attribute names

What is the attribute domain?

The specific range of values a column can hold

The relationship between tables

The total number of attributes in a database

Which of the following is most important in a DBMS?

The order of the rows and columns

An attribute or group of attributes that determines the values of other attributes

A single attribute that has no relation to other attributes

A column that stores numeric values only

Which of the following is an example of a key?

An invoice number that identifies all invoice attributes

What is determination?

The state in which knowing the value of an attribute makes it possible to determine the value of another

The ability to sort values in a table

A method used to calculate numerical data

A process of encrypting database records

Functional dependence means:

The value of one or more attributes determines the value of one or more other attributes

The relationship between different databases

The use of multiple data types in one column

What is an example of functional dependence involving a determinant that comprises multiple attributes?

STU_NUM → (STU_LNAME, STU_FNAME, STU_MI, STU_SECT)

What is a composite key?

A key composed of more than one attribute

A key composed of only one attribute

A key that contains only numbers

A key used to store unique values

An attribute or combination of attributes that uniquely identifies any row in the table

A single attribute that identifies any row in a table

A key used strictly for data retrieval purposes

What is a Candidate Key?

A superkey without any unnecessary attributes

A key that always contains null values

A key composed of multiple foreign keys

What is a Primary Key?

A candidate key selected to uniquely identify all other attribute values in any given row

A key that can contain null values

A key that may or may not be unique

What is a Foreign Key?

An attribute or combination of attributes in one table whose values must either match the primary key in another table or be null

A key used strictly for retrieval

A key with multiple null values

What is a Secondary Key?

A key used strictly for data retrieval purposes

A key always found in the primary table

What is Entity Integrity?

A condition where each row has a unique identity

A condition where rows contain duplicate keys

A condition where primary keys can be null

A condition where rows are unrelated

What is the requirement for Entity Integrity?

All primary key entries are unique, and no part of a primary key may be null

All primary keys must match a foreign key

A primary key may contain null values

A primary key must always be a foreign key

What is the purpose of Entity Integrity?

Ensuring that primary key values are unique and foreign key values properly reference primary key values

Making sure primary keys match the foreign key

Making sure that foreign keys do not reference anything

Allowing duplicate keys in the table

What is an example of Entity Integrity?

No invoice can have a duplicate number, nor can it be null

Some invoices can have the same number

Foreign keys always contain values

What is Referential Integrity?

A condition in which every reference to an entity instance by another entity instance is valid

A rule allowing primary keys to be null

A condition where foreign keys always contain values

A requirement that primary keys always reference another table

What is the requirement for Referential Integrity?

A foreign key may have either a null entry or an entry that matches the primary key value in a related table

A foreign key must always have a value

A foreign key must be the same as a primary key

Foreign keys can reference non-existing values

What happens if a foreign key has a value?

It must reference an existing primary key value

It must not reference any primary key

It can reference any value, even if it doesn’t exist

What does Referential Integrity enforcement prevent?

Deleting a row in one table whose primary key has mandatory matching foreign key values in another table

Adding a new row without a foreign key

Changing the foreign key values randomly

Deleting rows freely without restriction

What is an example of Referential Integrity?

A customer might not yet have an assigned sales representative (number), but it will be impossible to have an invalid sales representative (number)

A customer can have an invalid sales representative

A customer can have multiple sales representatives assigned to one primary key

A sales representative does not need to exist in the database

What is Relational Algebra?

A set of mathematical principles for manipulating relational table contents

A method to physically store data

A type of machine learning algorithm

Information Management Midterms

Authored by Zandar Kuwabara

Computers

University

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

97 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the relational model based on?

Graph theory and boolean logic

Predicate logic and set theory

Probability and statistics

Algebra and geometry

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Who introduced the relational model in 1970?

Edgar Dijkstra

E. F. Codd

Alan Turing

Charles Babbage

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does predicate logic provide?

A framework to verify assertions as true or false

A way to organize data into tables

A method for programming databases

A tool to convert data into different formats

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of predicate logic?

A table consisting of rows and columns

A student with a student ID of 324452 is named Mark Reyes

The sum of two sets is always greater than their intersection

A domain defines the type of values a column can hold

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does set theory deal with?

The study of database queries

The arrangement of tuples in a table

Sets or groups of things used for data manipulation

The format of attributes in a column

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of set theory in the relational model?

A relation consists of multiple tuples

Set A contains 15, 23, and 52, while Set B contains 41, 52, 70, and 12. It can be concluded that A and B share a common value, 52.

A tuple represents an entity in a database

The sum of all tuples in a column must be equal

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How many components does the relational model have?

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

100 questions

Software Development Quiz

Quiz

•

University

101 questions

Tin học đại cương

Quiz

•

University

100 questions

PT WEB 201-300

Quiz

•

University

100 questions

EXAMEN SEMANA 3 GRUPO 1

Quiz

•

University

99 questions

BooleanAlgebraBasics

Quiz

•

University

98 questions

22CA2015 - Mobile Hacking - Surprise Quiz II

Quiz

•

University

100 questions

Quiz Pra-UTS Manajement Jaringan

Quiz

•

University

101 questions

Computer Security and Ethics Quiz

Quiz

•

University

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade

Information Management Midterms

What is the relational model based on?

Who introduced the relational model in 1970?

What does predicate logic provide?

Which of the following is an example of predicate logic?

What does set theory deal with?

Which of the following is an example of set theory in the relational model?

How many components does the relational model have?

Which of the following is NOT a component of the relational model?

What does a table (relation) represent in the relational model?

What does each row (tuple) represent in a table?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground