Term
|
Definition
1-
each attribute value describes at most one entity instance |
|
|
Term
|
Definition
|
|
Term
|
Definition
-1
each entity instance has at most one attribute value |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
-(0)
an entity instance may have no attribute value |
|
|
Term
|
Definition
Unique, Singular, Required
Not Unique, Singular, Required
Not Unique, Singular, Optional
Not Unique, Singular, Optional |
|
|
Term
|
Definition
| Cardinality of the identifying entity |
|
|
Term
|
Definition
|
|
Term
| Which data type will store 6.250 as a numeric value without loss of information? |
|
Definition
|
|
Term
| Which role is responsible for translating table requirements in a logical database structure? |
|
Definition
|
|
Term
| The Employees table contains repeat entries in the JobTitle column, as many employees share the same job title. Which code snippet ensures that a query will list each job title once, independent of how many times it appears in the JobTitle column? |
|
Definition
SELECT DISTINCT JobTitle
FROM Employees;
This code uses the DISTINCT keyword, which ensures that each job title is listed only once in the query results. |
|
|
Term
| Which SQL command will delete all rows from the Movie table? |
|
Definition
|
|
Term
Which constraint must a primary key adhere to?
a) The data must refer to values in another table.
b) The data type must be numeric.
c) The key must consist of only one column.
d) The data values must be unique. |
|
Definition
|
|
Term
|
Definition
| tables, columns, and keys. |
|
|
Term
| Physical design affects query performance but never affects |
|
Definition
|
|
Term
| Select all records where the City column has the value "Berlin". |
|
Definition
| SELECT * FROM Customers WHERE City = 'Berlin'; |
|
|
Term
| Select all records from the Customers table, sort the result alphabetically by the column City. |
|
Definition
| SELECT * FROM Customers ORDER BY City; |
|
|
Term
| Select all records from the Customers table, sort the result reversed alphabetically by the column City. |
|
Definition
SELECT *
FROM Customers
ORDER BY City DESC; |
|
|
Term
| reversed alphabetically keyword |
|
Definition
|
|
Term
|
Definition
| a collection of facts, figures, and statistics |
|
|
Term
|
Definition
| a unit of data that represents a single category of information |
|
|
Term
|
Definition
| a collection of related data fields that represent a single entity within a data structure |
|
|
Term
|
Definition
| a collection of related records that are stored together on a computer or other digital storage device |
|
|
Term
|
Definition
| logical constructs composed of rows (tuples) and columns (attributes) |
|
|
Term
|
Definition
| depicts cardinality as a circle (zero), a short line (one), or three short lines (many) |
|
|
Term
| The _______ is always next to the entity. The _______ is always further from the entity. |
|
Definition
|
|
Term
| The _______ ___ must be unique and non-NULL, and should be stable, simple, and meaningless. |
|
Definition
|
|
Term
|
Definition
| a single-column primary key created by the database designer when no suitable single-column or composite primary key exists. |
|
|
Term
|
Definition
| integers, generated automatically by the database as new rows are inserted to the table |
|
|
Term
| When a primary key employs more than one column, it is also called a |
|
Definition
|
|
Term
What relationship does this represent:
A single order can include more than one product. On the other hand, a single product can appear on many orders. |
|
Definition
|
|
Term
| Does an INNER JOIN include NULL? |
|
Definition
|
|
Term
From the following rules:
A person's name does not include any information.
The name of a person may be changed through a legal procedure.
Every person has a name.
Many people can have the same name.
A name may be long and hard to type.
Which properties does the Name attribute have?
unique/not unique
stable/not stable
simple/not simple
meaningless
required |
|
Definition
required - Every person must have a name.
meaningless - A person's name does not include descriptive information. |
|
|
Term
|
Definition
| A structured list of data of a specific type. |
|
|
