DBMS WK 10 to 13

A data modeling technique used in software engineering to produce a conceptual data model of an information system.

• Normalization

• Transactional Management

• Entity Relationship Diagram

• Serializability

It is a logical unit of processing in a DBMS which entails one or more database access operation. A transaction is a program unit whose execution may or may not change the contents of a database.

• Normalization

• Transactional Management

• Entity Relationship Diagram

• Serializability

It is the process of searching for a concurrent schedule whose output is equal to a serial schedule where transactions are executed one after the other.

• Normalization

• Transactional Management

• Entity Relationship Diagram

• Serializability

Suppose you want to add new information in any relation but cannot enter that data because of some constraints. This is known as .

• Normal Anomaly

• Deletion Anomaly

• Insertion anomaly

• Updation Anomaly

Each attribute name must be unique.

Each attribute value must be single.

Each row must be unique.

There is no repeating groups.

• Boyce Codd Normal Form (BCNF) – 3.5NF

• Third Normal Form (3NF)

• Second Normal Form

  (2NF)

• First Normalization
  (1NF)

A table is already in 1NF.

All non-key attributes are fully dependent on the primary key.

All partial dependencies are removed to place in another table.

• Boyce Codd Normal Form (BCNF) – 3.5NF

• Third Normal Form (3NF)

• Second Normal Form

  (2NF)

• Forth Normal Form (4NF)

Occurs when you try to update any existing information in any relation and this causes inconsistency of data.

• Normal Anomaly

• Deletion Anomaly

• Insertion anomaly

• Updation Anomaly

Occurs when you try to delete any existing information from any relation and this causes deletion of any other undesirable information.

• Normal Anomaly

• Deletion Anomaly

• Insertion anomaly

• Updation Anomaly

Refer to the undesirable results because of modification of data.

• Normalization

• Anomalies

• Normal Form

• Serializability

A process by which we can decompose or divide any relation into more than one relation to remove anomalies in relational database.

• Normalization

• Transactional Management

• Entity Relationship Diagram

• Serializability