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