MidTerm1jeopardyV2 Flashcards
The term referring to an item existing in the real world that you want to track in a database is called ________.
Entity
To be in 3rd Normal Form all non-key attributes must depend on
The key, whole key, and nothing but the key (so help me Codd (1970))
The term used to describe the characteristics of interest for an entity _____________.
Attribute
After conceptually designing your database, the information contained in a single entity would be stored in a _________________.
Table
The attribute (or set of attributes) that uniquely identifies each row in a table is called the ___________________.
Primary Key
The ability to modify the data structure and not have to change the programs using that data is called _____________________.
Data independence
Metadata is ________________?
data about the data, often in the data dictionary
The processing that is done by the DBMS is typically referred to as ________________.
back-end processing
db2 400
Specifying a zero (0) for the minimum cardinality on an ER Diagram indicates that the item is
optional
—————-db3 100
Data integrity can be improved by ____________.
incorporating business rules when defining the data
Database system modelers use this type of diagram to graphically represent both the data structure and how the different objects are interrelated.
ERD or class diagram
Business rules are often represented in the database through ________________.
relationships
What is the special association that indicates that one entity can be broken down into multiple special cases?
class/subclass or super-type/sub-type
Assume you are creating a database to handle the data associated with instruction at a university. What is the most appropriate special association to model that a course has an assigned instructor, Teaching Assistants, a classroom, meeting time slot, and class roster?
n-ary association
Referential integrity is _________________?
constraint that forces a FK to always point to a PK, allows no orphan datapoint to a PK, allows no orphan data?
A table that meets the requirements of a relation is said to be in which normal form?
1st Normal Form
————-db4 400
An attribute in one table that is used to create an association with another table by matching the primary key of that table is called a(n)
Foreign key
Which term defines the highest number of permitted records in a related entity?
maximum cardinality
A relationship that indicates that one employee can supervise other employees is called a(n) ______________ relationship.
recursive or reflexive
It is an arbitrary, random key with no business meaning ________________ .
surrogate key
A relationship that associates data from more than two tables is called a(n) _______________ relationship.
n-ary
A library has the following business rule: A person may be a patron and not have any books borrowed and a patron may not have more than five books borrowed at any one time. The cardinality to represent this rule on the patron end would be ______________ and on the books borrowed end would by ______________ .
0:M and 0:5
