Case Study And Rest Flashcards
An blank, sometimes called an in-process database, is a database that is packaged with a programming language.
An embedded database
An embedded database and application program execute together in a blank. Embedded databases are used in single-user applications that require no database administration, such as applications designed for mobile devices.
Single software process
A software process containing an embedded database runs on a single hardware tier but is often part of a blank
complex multi-tier system.
Blank is the dominant embedded relational database. It is an open source relational database and supports all major programming languages.
SQLite
An embedded database is not the same as embedded SQL. Embedded database is a blank, while embedded SQL, described elsewhere in this material, is a database programming technique.
database architecture
A blank is a collection of two or more participating databases underneath a coordinating software layer.
A federated database
The participating databases in a federated database are blank and blank
autonomous and heterogeneous:
An blank operates independently of other participating databases. It is administered and can be queried as if the database were not part of a federated database.
An autonomous database
The full relationship name Entity-RelatesTo-Entity is read blank, around the center of the relationship line
Clockwise
Blank cardinality is depicted with crow’s foot notation.
Relationship
How are zero, one, and many cardinality depicted in relationship lines?
Zero is depicted as a circle.
One is depicted as a vertical bar.
Many is depicted as three short lines.
Attributes are presumed blank, blank, and blank
singular, optional, and not unique.
When an attribute is plural, required, or unique, one or more letters follow the attribute name. Name them.
P — plural attribute
R — required attribute
U — unique attribute
When a composite attribute is unique, the component attributes are blank prior to the U.
Grouped with a bracket
Tables are depicted with blank
Square corners
Tables are depicted with square corners. Columns and keys appear in what ways?
R and U indicate NOT NULL and UNIQUE columns.
Bullets indicate primary key columns. Multiple bullets in one table indicate a composite primary key. Since primary keys are always NOT NULL and UNIQUE, the bullet replaces the R and U symbols.
Arrows depict foreign keys. The arrow starts at the foreign key column and points to the referenced table.
RESTRICT, CASCADE, or SET NULL appears on the foreign key arrow. The rule applies to both update and delete of the referenced primary key.
Many-many relationships become new blank
Tables
One-one relationships are implemented as a blank in the table with fewer rows.
Foreign key
In a table diagram for a many-one relationship, the blank is placed in the table on the many side of the relationship. The blank name is a short version of the relationship name followed by the referenced primary key.
Foreign key
A plural attribute is usually implemented as a blank with two columns:
A foreign key that references the initial table
A column that implements the plural attribute
New weak table
A blank is a relationship between two entity types.
Binary relationship
A blank means that a single occurrence of one entity type can be associated with a single occurrence of the other entity type and vice versa.
one-to-one (1-1) binary relationship
In its most basic form, the blank of the many-to-many relationship or the associative entity is the combination of the unique identifiers of the two entities in the many-to-many relationship.
Unique identifier
Blank associate occurrences of an entity type with other occurrences of the same entity type.
Unary relationships
