Case Study And Rest

Question 1

An blank, sometimes called an in-process database, is a database that is packaged with a programming language.

Answer 1

An embedded database

Question 2

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.

Answer 2

Single software process

Question 3

A software process containing an embedded database runs on a single hardware tier but is often part of a blank

Answer 3

complex multi-tier system.

Question 4

Blank is the dominant embedded relational database. It is an open source relational database and supports all major programming languages.

Answer 4

SQLite

Question 5

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.

Answer 5

database architecture

Question 6

A blank is a collection of two or more participating databases underneath a coordinating software layer.

Answer 6

A federated database

Question 7

The participating databases in a federated database are blank and blank

Answer 7

autonomous and heterogeneous:

Question 8

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.

Answer 8

An autonomous database

Question 9

The full relationship name Entity-RelatesTo-Entity is read blank, around the center of the relationship line

Answer 9

Clockwise

Question 10

Blank cardinality is depicted with crow’s foot notation.

Answer 10

Relationship

Question 11

How are zero, one, and many cardinality depicted in relationship lines?

Answer 11

Zero is depicted as a circle.

One is depicted as a vertical bar.

Many is depicted as three short lines.

Question 12

Attributes are presumed blank, blank, and blank

Answer 12

singular, optional, and not unique.

Question 13

When an attribute is plural, required, or unique, one or more letters follow the attribute name. Name them.

Answer 13

P — plural attribute
R — required attribute
U — unique attribute

Question 14

When a composite attribute is unique, the component attributes are blank prior to the U.

Answer 14

Grouped with a bracket

Question 15

Tables are depicted with blank

Answer 15

Square corners

Question 16

Tables are depicted with square corners. Columns and keys appear in what ways?

Answer 16

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.

Question 17

Many-many relationships become new blank

Answer 17

Tables

Question 18

One-one relationships are implemented as a blank in the table with fewer rows.

Answer 18

Foreign key

Question 19

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.

Answer 19

Foreign key

Question 20

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

Answer 20

New weak table

Question 21

A blank is a relationship between two entity types.

Answer 21

Binary relationship

Question 22

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.

Answer 22

one-to-one (1-1) binary relationship

Question 23

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.

Answer 23

Unique identifier

Question 24

Blank associate occurrences of an entity type with other occurrences of the same entity type.

Answer 24

Unary relationships

Question 25

A blank involves three different entity types.

Answer 25

A ternary relationship