DBMS FINAL MC
Home > Flashcards > Print Preview
The flashcards below were created by user
on FreezingBlue Flashcards
. What would you like to do?
Data are organized in the form of tables, with rows & columns
Powerful operations (using SQL) are used to manipulate data stored in relations.
Mechanisms to specify business rules that maintain the integrity of the data when they are manipulated.
Named, two-dimensional table of data.
Named column of a relation
Row of relation that contains data values for a single entity.
Primary Key (identifier)
Attribute or combination of attributes that uniquely identifies each row in a relation.
Primary key that consists of more than one attribute
Attribute (possibly composite) in a relation that serves as the primary key of another relation.
Integrity Constraint - Domain Constraint
All values in a column must be from the same domain.
Set of values that may be assigned to an attribute (name, meaning, data type, size/length, range of allowable values).
Integrity Constraint - Entity Integrity
Every relation has a primary key and the data values for the primary key are all valid. Every primary key attribute is non-null.
Value that may be assigned to an attribute when no other value applies or when the applicable value is unknown. ABSENCE OF A VALUE. NOT THE SAME AS 0 or STRING OF BLANKS.
Integrity Constraint - Referential Integrity
Either each foreign key value must match a primary key value in another table relation or the foreign key value must be null.
Contains minimal redundancy and allows users to insert, modify, delete rows without errors or inconsistencies.
Error that may result when a user attempts to update a table that contains redundant data.
Entities that have independent existence and generally represent real world objects (persons, places, things).
Entities that cannot exist except with an identifying relationship as the owner (regular) entity type.
Associate Entities (Gerunds)
Formed from many to many relationships between entities
Must be broken up when creating relation (i.e. Address --> city, state, zip, etc.)
Natural Primary Key
key used in the organization and identified in conceptual data modeling as the identifier.
KEY FORMED OF ATTRIBUTES THAT EXIST IN THE REAL WORLD (SSN #).
Recursive Foreign Key
Foreign key in a relation that references the primary key values of the same relation. Must have same domain as primary key (employee & supervisor unary).
Process of successively reducing relations with anomalies to produce smaller, well-structured relations.
Defines rules of business, not data use.
State of a relation that requires that certain rules regarding relationships between attributes (functional dependencies) are satisfied
Constraint between two attributes in which the value of one attribute is determined by the value of another attribute
A --> B
If you know the value of A, there can only be ONE value for B.
Act as constraints (i.e. if one then the other has to be)
When you can always tell the one and only one value of another column given a single value.
SSN, VIN, ISBN are determinants.
A is determinant
Left side of the arrow (A --> B)
A candidate key is always a determinant, where as a determinant may or may not be a candidate key.
CK can be determinant (not in violation)
Attribute or composite that uniquely identifies a row in a relation. Multipass in example below.
DU_NO (PK) LNAME MULTIPASS D1234 Malone Malonej
Merging - Synonym
Two attributes that have different names but the same meaning (StudentID, CollegeID)
Merging - Homonyms
An attribute that may have more than one meaning.
Account - may refer to a checking account, savings account, etc.
Primary key unique across the whole database, not just the table to which it applies.
Business Key / Natural Key
CUSTOMERID, EMPLOYEEID. Primary key that has business meaning.
Can be Surrogate or Composite
Organized collection of logically related data
Facts such as customer name, address. Numeric, character, dates. Stored in tabular form.
Unstructured / Multimedia data
Data such as documents, e-mails, maps, images, sound/video
Data that has been processed in a way that increases knowledge.
- Data in context (i.e. in a report)
- Summarized data
data names, definitions, length, allowable values.
Source of the data, where it is stored, stewards, usage.
File descriptions are stored within each database program that accesses a given file.
Any change to a file structure requires changes to the file descriptions for all programs that access the file.
Graphical systems used to capture the nature and relationships among data.
A person, a place, an object, an event, or a concept in the user environment about which the organization wishes to maintain data.
A database that represents data as a collection of tables in which all data relationships are represented by common values in related tables.
Software that enables the use of a database approach. Provide a systematic method of creating, updating, storing, and retrieving the data stored in a database.
A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components.
Software tools that provide automated support for some portion of the systems development process.
Two-Tier Client/Server DB
Each member of the workgroup has a computer, and the computers are linked by means of network. In most cases, each computer has a copy of a specialized application (client) which provides the user interface. The database itself and the DBMS are stored on a central device Workgroup database called the “database server,” which is also connected to the network.
Multitier Client/Server Databases
User interface is accessible via Web browser using programming languages such as Visual Basic.NET.
The application layer/Web server layer contains the business logic and talks to the database server.
An integrated decision support database whose content is derived from the various operational databases.
Detailed, logical representation of the data for an organization or for a business area.
entity type on which the weak entity type depends
The relationship between a weak entity type and its owner.
A property or characteristic of an entity or relationship type that is of interest to the organization.
Attribute, such as Address, that has meaningful component parts, which are more detailed attributes
Simple (Atomic) attribute
Attribute that cannot be broken down into smaller components that are meaningful for the organization.
attribute whose values can be calculated from related attribute values
entity instance of the supertype is allowed not to belong to any subtype.
Car and Truck are showing, not motorcycle (1 line)
A rule that specifies that each entity instance of a supertype must be a member of some subtype in the relationship.
Patient has to be either an outpatient or resident (2 lines)
Patient cannot be both an outpatient or resident (one or the other, not both)
Part can be both manufactured and purchased
An attribute of a supertype whose values determine the target subtype or subtypes.
i.e. vehicle type (CAR vs. TRUCK)
What would you like to do?
Home > Flashcards > Print Preview