100 Matching questions
- Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum )
Based on the code above, list the number, name, credit limit, and balance for all customers with credit limits that exceed their balances.
- List the trip name and state for each trip that occurs during the Summer season. Sort the results by trip name within state.
- Surrogate key
- If B (an attribute) is functionally dependent on A, we can also say that _________.
- When a subquery is used, _________ is(are) evaluated first.
- Normalization is the process of decomposing relations to produce smaller, well- structured relations
- Which might be a subtype under the supertype entity STUDENT?
- A foreign key is a primary key of a relation that also is a primary key in another relation.
- A(n) _____ corresponds to a column in the relation
- What type of relationship exists between this pair of related entities?
BOOK and BOOK COPY (books have copies)
- One-to-many relationship
- Understanding the steps involved in transforming EER diagrams into relations is important because:
- Which of the following are anomalies that can be caused by redundancies in tables?
- An association between entities is known as a ____.
- A primary key whose value is unique across all relations is called a:
- The attribute on the left-hand side of the arrow in a functional dependency is the:
- The attribute on the left-hand side of the arrow in a function dependency is the:
- In an E-R diagram, _________ represent entitites
- To use a wildcard, include the _________ operator in the WHERE clause,
- A functional dependency in which one or more nonkey attributes are functionally dependent on part but not all of the primary key is called a _____ dependency.
- Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server.
- Many-to-many relationship
- A person, place, an object , an event or concept about which the organization wishes to maintain data is called a:
- Storing the same data in more than one place is called ____.
- Second normal form can be defined as a table that is in first normal form and contains no _________.
- The ____ of an entity become the columns in the database table.
- Database design decisions must be made carefully because of impacts on:
- data type for fields that contain letters and other special characters, and for fields that contain numbers that will not be used for arithmetic.
- List the name of each trip that does not start in New Hampshire (NH).
- Essentially, setting the value of a given field to ______________ is similar to not entering a value into it at all.
- The SQL command used to create an index is
- Based on the statement below, which of the following is the primary key?
Part (PartNum, Description, OnHand, Class, Warehouse, Price)
- ________ are established between entities in a well-structured database so that the desired information can be retrieved.
- In _____ normal form, any multivalued attributes have been removed
- data type stores integers, but uses less space than INTEGER.
- Which of the following are properties of relations?
- In an E-R diagram, ________ represent relatinships
- The basic form of an SQL retrieval command is ____.
- When used after the word SELECT, the ____ symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table.
- A nonkey attribute is also called a(n):
- ____ are screen objects used to maintain, view, and print data from a database.
- List the name of each trip that has the type Hiking and that has a distance of greater than six miles.
- A ____ is a column or collection of columns on which all columns in the table are functionally dependent.
- Customers, cars, and parts are examples of:
- A rule that states that each foreign key value must match a primary key value in the other relation is called the:
- Artificial key
- The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table.
- Alternate key
- In SQL, you can use the CHECK clause to enforce _____________________ integrity.
- In a system catalog, the ________ table contains information about the tables known to SQL.
- A candidate key must satisfy all of the following conditions:
- User view:
- Natural key
- Which of the following is a generic entity type that has a relationship with one or more subtypes?
- The fact that column B is functionally dependent on column A can be written as
- Cumulative design
- The SQL statement used to delete an index that is no longer needed is
- The ________ states that no primary key attribute may be null.
- Secondary keys
- The separation of the data description from programs is referred to as
- A relation that contains no multivalued attributes, and has nonkey attributes solely dependent on the primary key, but contains transitive dependencies is in which normal form?
- A relation that contains minimal redundancy and allows easy use is considered to be:
- The entity integrity rule states that:
- A form of database specification that indicates all the parameters for data storage that are then input to a database implementation is:
- Information-level design
- _____ entities are entities that cannot exist except with an identifying relationship with a regular entity type.
- An integrity constraint is a rule that ____.
- A database has ____ if the data in it satisfies all established integrity constraints.
- An column (or columnss) that uniquely identifies each row in a relation is called a:
- In order to make changes to existing data in a table, you would use the ________ command.
- From all of the _______________ keys, one is chosen to be the primary key.
- A(n) _____ is a constraint between two attributes.
- Weak entity
- When a regular entity type contains a multivalued attribute, one must:
- A column in a relation of a database that serves as the primary key of another relation in the same database is called a:
- You use the SQL _______ command to create a table by describing its layout
- Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions that can be used in a query.
- How many trips have a type of Hiking or Biking?
- A table is in first normal form if it does not contain ________.
- ________ is a property that lets you change the structure of the database without requiring you to change the programs that access the database
- One-to-one relationship
- When duplicate column names exist in a database and you need to indicate the column to which you are referring, ____.
- A(n) _____ is an attribute in a relation that serves as a primary key of another relation in the same database.
- Foreign key
- A recursive foreign key is used in a unary relationship.
- By including the word ______ in a query after a computation , you can assign a name to the computed field.
- The entity integrity rule states that
- __________ is the prevention of unauthorized access to the database.
- _________ dependencies are dependencies on only a portion of the primary key.
- In _____ normal form, any transitive dependencies have been removed.
- Physical-level design
- A domain definition consists of the following components EXCEPT:
- A visual way to represent a database is with a ____.
- Composite entity
- Which of the following is NOT a reason to create an instance of a relational schema with sample data?
- A(n) _____ contains minimal data redundancy.
- Existence dependency
- a no primary key attribute can be null.
- b Security
- c Aggregate
- d attributes
- e Relationships
- f relationship
- g the subquery query
- h no primary key attribute can be null
- i primary key
- j Well-Structured
- k data Independence
- l IN_STATE_STUDENT
- m DBMSs (Data Base Management Systems)
- n Third
- o DROP INDEX
- p Attribute
- q False
- r Foreign Key
- s Forms
- t column(s) in one table that is required to match value of the primary key for some row in another table or is required to be null
- u True
- v Partial
- w AS
- x columns of interest strictly for retrieval purposes
- y CREATE TABLE
- z null
- aa information-level design adapted for the specific DBMS that will be used
Must consider characteristics of the particular DBMS
- ab Integrity
- ac Partial functional
- ad rectangles
- ae column(s) that could have been chosen as a primary key but was not
- af Data accessibility
- ag First
- ah SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance;
- ai Entity
- aj Systables
- ak supports all user views encountered during design process
- al SMALLINT
- am SELECT TripName
WHERE Type='Hiking' AND Distance >6;
- an candidate
- ao Physical
- ap simplest implementation is to treat it as a one-to-many relationship
- aq true
- ar Referential integrity contraint
- as Primary
- at Functional Dependency
- au PartNum
- av write both the table name and the column name, separated by a period
- aw data must follow in the database
- ax Create two new relation
- ay Determinant
- az SELECT COUNT (*)
WHERE Type='Hiking' OR Type='Biking'
- ba set of requirements necessary to support operations of a particular database user
- bb *
- bc Enterprise Key
- bd entity integrity rule
- be Second
- bf redundancy
- bg SELECT TripName, State
ORDER BY State, TripName;
- bh A -> B
- bi Descriptor
- bj entities
- bk UPDATE
- bl legal-values
- bm partial dependencies
- bn system-generated; usually hidden from users
Also called a synthetic key
- bo LIKE
- bp foreign key
- bq CHAR
- br Data independence
- bs depends on another entity for its own existence
- bt Insertion
- bu consists of a column that uniquely identifies an entity
-Also called a logical key or an intelligent key
- bv include primary key of the "one" table as a foreign key in the "many" table
- bw You must be able to check the output of a CASE tool
- bx candidate key
- by lines
- bz : column created for an entity to serve solely as the primary key and that is visible to users
- ca one-to-many
- cb Integrity constaints
- cc CREATE INDEX
- cd create a new table whose primary key is the combination of the primary keys of the original tables
- ce Each attribute has a unique name
No two rows in a relation are identical
There are no multivalued attributes in a relation
(All the above)
- cf Well-Structured Relation
- cg drawn as rectangles
- ch existence of one entity depends on the existence of another related entity
- ci exists to implement a many-to-many relationship
- cj are drawn as diamonds with lines connecting the entities involved in relationships
- ck Weak
- cl repeating groups
- cm SELECT-FROM-WHERE
- cn SELECT TripName
WHERE State !='NH';
- co Supertype
- cp a. each nonkey attribute is functionally dependent upon it.
b. the key must be nonredundant.
c. the key must uniquely identify the row.
(All of the above)
- cq completed independently of any particular DBMS
- cr One-To-Many
- cs A functionally determines B
- ct Sample data can reverse database implementation errors
- cu determinant
- cv entry-relationship diagram