Exam 1

A database team plans the creation of a new database. During which phase does the team capture data requirements?

Analysis

When using a SQL statement to create a table, which data type is used to store a fractional value?

DECIMAL

Which goes in the table on the "many" side of a one-many relationship?

Foreign key

Which data type should a database use to store negative numbers?

INT

Which operation will allow you to extract data from more than one table?​

Join

In the SQL query below, the Teacher table is the _____. SELECT LastName, FirstName, CourseTitle FROM Teacher INNER JOIN Class ON Teacher.TeacherID = Class.TeacherID;

Left table

What is the greatest number of instances of one entity that can relate to a single instance of another entity?

Maximum

What is the result of a relational operation?

Table

A user creates a table by using a SQL statement. The data type VARCHAR(11) is part of the statement. What does the value of (11) represent?

The number of characters allowed for the data type.

Which two rules apply to primary keys?

Values must be unique and may not be NULL

How are attributes documented in an entity-relationship diagram?

Within an entity rectangle.

The database designer creates a(n) _______ when no suitable single-column or composite primary key exists.

artificial key

A _____ is a collection of values that are of the same type.

column

In a one-one relationship, the _____ key is often placed in the table with fewer rows. This minimizes the number of _____ values.

foreign, NULL

All _____ columns depend on the _____ for a table to be in first normal form.

non-key, primary key

When only one value exists in each cell, a table is known to be _____.

normalized

A column, or group of columns, that serves as the unique identifier in a relational database table is called a/an _____.

primary key

When a user interacts with a database, they can use a _____ to modify data with commands.

query language

A database _____ is the implementation of database requirements in SQL with CREATE TABLE statements.

schema

When an entity-relationship model is implemented in SQL, an entity typically becomes a _____.

table

A relational database uses _____ to structure all data.

tables

When an entity-relationship model diagram is implemented within SQL, entities typically become _____, and relationships typically become _____.

tables, foreign keys