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 Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

94 questions

1er. Parcial Software de Base

Quiz

•

University

100 questions

HTML2

Quiz

•

11th Grade - University

99 questions

untitled

Quiz

•

12th Grade - University

101 questions

Semestral de Informática y Redes de Aprendizaje-DIURNO

Quiz

•

University

100 questions

SEO Quiz

Quiz

•

University

100 questions

First Model Test MCQ - HCI

Quiz

•

University

100 questions

A+ CORE 2 FINAL REVIEW QUIZ

Quiz

•

University

100 questions

Python Advanced

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

20 questions

CompTIA Network+ - Ports and Protocols

Quiz

•

University

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

Discover more resources for Computers