100 Matching questions

1. 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.
2. List the trip name and state for each trip that occurs during the Summer season. Sort the results by trip name within state.
3. Surrogate key
4. If B (an attribute) is functionally dependent on A, we can also say that _________.
5. When a subquery is used, _________ is(are) evaluated first.
6. Normalization is the process of decomposing relations to produce smaller, well- structured relations
7. Which might be a subtype under the supertype entity STUDENT?
8. A foreign key is a primary key of a relation that also is a primary key in another relation.
9. A(n) _____ corresponds to a column in the relation
10. What type of relationship exists between this pair of related entities?
    
    BOOK and BOOK COPY (books have copies)
11. One-to-many relationship
12. Understanding the steps involved in transforming EER diagrams into relations is important because:
13. Which of the following are anomalies that can be caused by redundancies in tables?
14. An association between entities is known as a ____.
15. A primary key whose value is unique across all relations is called a:
16. The attribute on the left-hand side of the arrow in a functional dependency is the:
17. The attribute on the left-hand side of the arrow in a function dependency is the:
18. In an E-R diagram, _________ represent entitites
19. To use a wildcard, include the _________ operator in the WHERE clause,
20. 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.
21. Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server.
22. Many-to-many relationship
23. A person, place, an object , an event or concept about which the organization wishes to maintain data is called a:
24. Storing the same data in more than one place is called ____.
25. Second normal form can be defined as a table that is in first normal form and contains no _________.
26. The ____ of an entity become the columns in the database table.
27. Database design decisions must be made carefully because of impacts on:
28. data type for fields that contain letters and other special characters, and for fields that contain numbers that will not be used for arithmetic.
29. List the name of each trip that does not start in New Hampshire (NH).
30. Essentially, setting the value of a given field to ______________ is similar to not entering a value into it at all.
31. The SQL command used to create an index is
32. Based on the statement below, which of the following is the primary key?
    
    Part (PartNum, Description, OnHand, Class, Warehouse, Price)
33. 1:M
34. ________ are established between entities in a well-structured database so that the desired information can be retrieved.
35. In _____ normal form, any multivalued attributes have been removed
36. data type stores integers, but uses less space than INTEGER.
37. Which of the following are properties of relations?
38. In an E-R diagram, ________ represent relatinships
39. The basic form of an SQL retrieval command is ____.
40. 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.
41. A nonkey attribute is also called a(n):
42. ____ are screen objects used to maintain, view, and print data from a database.
43. List the name of each trip that has the type Hiking and that has a distance of greater than six miles.
44. A ____ is a column or collection of columns on which all columns in the table are functionally dependent.
45. Customers, cars, and parts are examples of:
46. A rule that states that each foreign key value must match a primary key value in the other relation is called the:
47. Artificial key
48. The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table.
49. Alternate key
50. In SQL, you can use the CHECK clause to enforce _____________________ integrity.
51. In a system catalog, the ________ table contains information about the tables known to SQL.
52. A candidate key must satisfy all of the following conditions:
53. User view:
54. Natural key
55. Which of the following is a generic entity type that has a relationship with one or more subtypes?
56. The fact that column B is functionally dependent on column A can be written as
57. Cumulative design
58. The SQL statement used to delete an index that is no longer needed is
59. The ________ states that no primary key attribute may be null.
60. Secondary keys
61. The separation of the data description from programs is referred to as
62. 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?
63. A relation that contains minimal redundancy and allows easy use is considered to be:
64. The entity integrity rule states that:
65. A form of database specification that indicates all the parameters for data storage that are then input to a database implementation is:
66. Information-level design
67. _____ entities are entities that cannot exist except with an identifying relationship with a regular entity type.
68. An integrity constraint is a rule that ____.
69. A database has ____ if the data in it satisfies all established integrity constraints.
70. An column (or columnss) that uniquely identifies each row in a relation is called a:
71. In order to make changes to existing data in a table, you would use the ________ command.
72. From all of the _______________ keys, one is chosen to be the primary key.
73. A(n) _____ is a constraint between two attributes.
74. Weak entity
75. When a regular entity type contains a multivalued attribute, one must:
76. A column in a relation of a database that serves as the primary key of another relation in the same database is called a:
77. You use the SQL _______ command to create a table by describing its layout
78. Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions that can be used in a query.
79. Entities
80. How many trips have a type of Hiking or Biking?
81. A table is in first normal form if it does not contain ________.
82. ________ is a property that lets you change the structure of the database without requiring you to change the programs that access the database
83. One-to-one relationship
84. When duplicate column names exist in a database and you need to indicate the column to which you are referring, ____.
85. A(n) _____ is an attribute in a relation that serves as a primary key of another relation in the same database.
86. Foreign key
87. A recursive foreign key is used in a unary relationship.
88. By including the word ______ in a query after a computation , you can assign a name to the computed field.
89. The entity integrity rule states that
90. __________ is the prevention of unauthorized access to the database.
91. _________ dependencies are dependencies on only a portion of the primary key.
92. In _____ normal form, any transitive dependencies have been removed.
93. Physical-level design
94. A domain definition consists of the following components EXCEPT:
95. A visual way to represent a database is with a ____.
96. Relationships
97. Composite entity
98. Which of the following is NOT a reason to create an instance of a relational schema with sample data?
99. A(n) _____ contains minimal data redundancy.
100. Existence dependency

1. a no primary key attribute can be null.
2. b Security
3. c Aggregate
4. d attributes
5. e Relationships
6. f relationship
7. g the subquery query
8. h no primary key attribute can be null
9. i primary key
10. j Well-Structured
11. k data Independence
12. l IN_STATE_STUDENT
13. m DBMSs (Data Base Management Systems)
14. n Third
15. o DROP INDEX
16. p Attribute
17. q False
18. r Foreign Key
19. s Forms
20. 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
21. u True
22. v Partial
23. w AS
24. x columns of interest strictly for retrieval purposes
25. y CREATE TABLE
26. z null
27. aa information-level design adapted for the specific DBMS that will be used
    Must consider characteristics of the particular DBMS
28. ab Integrity
29. ac Partial functional
30. ad rectangles
31. ae column(s) that could have been chosen as a primary key but was not
32. af Data accessibility
    Response times
    Security
33. ag First
34. ah SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance;
35. ai Entity
36. aj Systables
37. ak supports all user views encountered during design process
38. al SMALLINT
39. am SELECT TripName
    FROM Trip
    WHERE Type='Hiking' AND Distance >6;
40. an candidate
41. ao Physical
42. ap simplest implementation is to treat it as a one-to-many relationship
43. aq true
44. ar Referential integrity contraint
45. as Primary
46. at Functional Dependency
47. au PartNum
48. av write both the table name and the column name, separated by a period
49. aw data must follow in the database
50. ax Create two new relation
51. ay Determinant
52. az SELECT COUNT (*)
    FROM Trip
    WHERE Type='Hiking' OR Type='Biking'
53. ba set of requirements necessary to support operations of a particular database user
54. bb *
55. bc Enterprise Key
56. bd entity integrity rule
57. be Second
58. bf redundancy
59. bg SELECT TripName, State
    FROM Trip
    WHERE Season='Summer'
    ORDER BY State, TripName;
60. bh A -> B
61. bi Descriptor
62. bj entities
63. bk UPDATE
64. bl legal-values
65. bm partial dependencies
66. bn system-generated; usually hidden from users
    Also called a synthetic key
67. bo LIKE
68. bp foreign key
69. bq CHAR
70. br Data independence
71. bs depends on another entity for its own existence
72. bt Insertion
    Deletion
    Modification
73. bu consists of a column that uniquely identifies an entity
    -Also called a logical key or an intelligent key
74. bv include primary key of the "one" table as a foreign key in the "many" table
75. bw You must be able to check the output of a CASE tool
76. bx candidate key
77. by lines
78. bz : column created for an entity to serve solely as the primary key and that is visible to users
79. ca one-to-many
80. cb Integrity constaints
81. cc CREATE INDEX
82. cd create a new table whose primary key is the combination of the primary keys of the original tables
83. 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)
84. cf Well-Structured Relation
85. cg drawn as rectangles
86. ch existence of one entity depends on the existence of another related entity
87. ci exists to implement a many-to-many relationship
88. cj are drawn as diamonds with lines connecting the entities involved in relationships
89. ck Weak
90. cl repeating groups
91. cm SELECT-FROM-WHERE
92. cn SELECT TripName
    FROM Trip
    WHERE State !='NH';
93. co Supertype
94. 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)
95. cq completed independently of any particular DBMS
96. cr One-To-Many
97. cs A functionally determines B
98. ct Sample data can reverse database implementation errors
99. cu determinant
100. cv entry-relationship diagram