{"id":1613,"date":"2025-01-29T19:25:13","date_gmt":"2025-01-30T00:25:13","guid":{"rendered":"https:\/\/pressbooks.bccampus.ca\/nelson\/chapter\/abbreviations-2\/"},"modified":"2025-01-29T19:28:36","modified_gmt":"2025-01-30T00:28:36","slug":"abbreviations","status":"publish","type":"chapter","link":"https:\/\/pressbooks.bccampus.ca\/nelson\/chapter\/abbreviations\/","title":{"raw":"Abbreviations","rendered":"Abbreviations"},"content":{"raw":"
\r\n

This is not a complete list of abbreviations in the textbook.<\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

Abbreviations<\/strong><\/p>\r\n<\/td>\r\n

\r\n

Full Expressions<\/strong><\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

1NF<\/p>\r\n<\/td>\r\n

\r\n

First Normal Form<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

2NF<\/p>\r\n<\/td>\r\n

\r\n

Second Normal Form<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

3NF<\/p>\r\n<\/td>\r\n

\r\n

Third Normal Form<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

4NF<\/p>\r\n<\/td>\r\n

\r\n

Fourth normal form<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

5NF<\/p>\r\n<\/td>\r\n

\r\n

Fifth normal form<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

ACID<\/p>\r\n<\/td>\r\n

\r\n

This stands for Atomicity, Consistency, Isolation, and Durability. These behaviors are highly desirable.<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

ANSI<\/p>\r\n<\/td>\r\n

\r\n

American National Standards Institute<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

API<\/p>\r\n<\/td>\r\n

\r\n

Application Programming Interface<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

ABAC<\/p>\r\n<\/td>\r\n

\r\n

Attribute-Based Access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

BCNF<\/p>\r\n<\/td>\r\n

\r\n

Boyce Codd Normal Form<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

BGAC<\/p>\r\n<\/td>\r\n

\r\n

Break-Glass Access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

CTAC<\/p>\r\n<\/td>\r\n

\r\n

Context-Based Access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

CSS<\/p>\r\n<\/td>\r\n

\r\n

Cascading Style Sheets<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

DAC<\/p>\r\n<\/td>\r\n

\r\n

Discretionary Access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

DBMS<\/p>\r\n<\/td>\r\n

\r\n

database management system<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

DCL<\/p>\r\n<\/td>\r\n

\r\n

Data Control Language<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

DDL<\/p>\r\n<\/td>\r\n

\r\n

Data Definition Language<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

DML<\/p>\r\n<\/td>\r\n

\r\n

Data Manipulation Language<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

DQL<\/p>\r\n<\/td>\r\n

\r\n

Data Query Language<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

ERD<\/p>\r\n<\/td>\r\n

\r\n

Entity-Relationship Diagram<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

FD<\/p>\r\n<\/td>\r\n

\r\n

functional dependency<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

FD set<\/p>\r\n<\/td>\r\n

\r\n

functional dependency set<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

GUI<\/p>\r\n<\/td>\r\n

\r\n

graphic user interface<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

HBAC<\/p>\r\n<\/td>\r\n

\r\n

History-Based Access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

HTML<\/p>\r\n<\/td>\r\n

\r\n

Hyper Text Markup Language<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

IBAC<\/p>\r\n<\/td>\r\n

\r\n

Identity-Based Access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

LTP<\/p>\r\n<\/td>\r\n

\r\n

Online Transaction Processing<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

MAC<\/p>\r\n<\/td>\r\n

\r\n

Mandatory Access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

MVC<\/p>\r\n<\/td>\r\n

\r\n

Model-View-Controller framework<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

OrBCA<\/p>\r\n<\/td>\r\n

\r\n

Organization-Based Access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

PBAC<\/p>\r\n<\/td>\r\n

\r\n

Policy-Based access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

PJNF<\/p>\r\n<\/td>\r\n

\r\n

Project-Join Normal Form<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

PLP<\/p>\r\n<\/td>\r\n

\r\n

Principle of Least Privilege<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

RAdAC<\/p>\r\n<\/td>\r\n

\r\n

Risk-Adaptive Access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

RBAC<\/p>\r\n<\/td>\r\n

\r\n

Role-Based Access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

RAC<\/p>\r\n<\/td>\r\n

\r\n

Rule-Based Access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

SQL<\/p>\r\n<\/td>\r\n

\r\n

Structured Query Language<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

SSMS<\/p>\r\n<\/td>\r\n

\r\n

SQL Server Management Studio<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

T-SQL<\/p>\r\n<\/td>\r\n

\r\n

Transact Structured Query Language or Transact-SQL<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

TBAC<\/p>\r\n<\/td>\r\n

\r\n

Time-Based Access Control<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

TCL<\/p>\r\n<\/td>\r\n

\r\n

Transaction Control Language<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

TDS<\/p>\r\n<\/td>\r\n

\r\n

Tabular Data Stream protocol<\/p>\r\n<\/td>\r\n<\/tr>\r\n

<\/td>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

<\/p>\r\n\r\n<\/div>","rendered":"

\n

This is not a complete list of abbreviations in the textbook.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

Abbreviations<\/strong><\/p>\n<\/td>\n

\n

Full Expressions<\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

1NF<\/p>\n<\/td>\n

\n

First Normal Form<\/p>\n<\/td>\n<\/tr>\n

\n

2NF<\/p>\n<\/td>\n

\n

Second Normal Form<\/p>\n<\/td>\n<\/tr>\n

\n

3NF<\/p>\n<\/td>\n

\n

Third Normal Form<\/p>\n<\/td>\n<\/tr>\n

\n

4NF<\/p>\n<\/td>\n

\n

Fourth normal form<\/p>\n<\/td>\n<\/tr>\n

\n

5NF<\/p>\n<\/td>\n

\n

Fifth normal form<\/p>\n<\/td>\n<\/tr>\n

\n

ACID<\/p>\n<\/td>\n

\n

This stands for Atomicity, Consistency, Isolation, and Durability. These behaviors are highly desirable.<\/p>\n<\/td>\n<\/tr>\n

\n

ANSI<\/p>\n<\/td>\n

\n

American National Standards Institute<\/p>\n<\/td>\n<\/tr>\n

\n

API<\/p>\n<\/td>\n

\n

Application Programming Interface<\/p>\n<\/td>\n<\/tr>\n

\n

ABAC<\/p>\n<\/td>\n

\n

Attribute-Based Access Control<\/p>\n<\/td>\n<\/tr>\n

\n

BCNF<\/p>\n<\/td>\n

\n

Boyce Codd Normal Form<\/p>\n<\/td>\n<\/tr>\n

\n

BGAC<\/p>\n<\/td>\n

\n

Break-Glass Access Control<\/p>\n<\/td>\n<\/tr>\n

\n

CTAC<\/p>\n<\/td>\n

\n

Context-Based Access Control<\/p>\n<\/td>\n<\/tr>\n

\n

CSS<\/p>\n<\/td>\n

\n

Cascading Style Sheets<\/p>\n<\/td>\n<\/tr>\n

\n

DAC<\/p>\n<\/td>\n

\n

Discretionary Access Control<\/p>\n<\/td>\n<\/tr>\n

\n

DBMS<\/p>\n<\/td>\n

\n

database management system<\/p>\n<\/td>\n<\/tr>\n

\n

DCL<\/p>\n<\/td>\n

\n

Data Control Language<\/p>\n<\/td>\n<\/tr>\n

\n

DDL<\/p>\n<\/td>\n

\n

Data Definition Language<\/p>\n<\/td>\n<\/tr>\n

\n

DML<\/p>\n<\/td>\n

\n

Data Manipulation Language<\/p>\n<\/td>\n<\/tr>\n

\n

DQL<\/p>\n<\/td>\n

\n

Data Query Language<\/p>\n<\/td>\n<\/tr>\n

\n

ERD<\/p>\n<\/td>\n

\n

Entity-Relationship Diagram<\/p>\n<\/td>\n<\/tr>\n

\n

FD<\/p>\n<\/td>\n

\n

functional dependency<\/p>\n<\/td>\n<\/tr>\n

\n

FD set<\/p>\n<\/td>\n

\n

functional dependency set<\/p>\n<\/td>\n<\/tr>\n

\n

GUI<\/p>\n<\/td>\n

\n

graphic user interface<\/p>\n<\/td>\n<\/tr>\n

\n

HBAC<\/p>\n<\/td>\n

\n

History-Based Access Control<\/p>\n<\/td>\n<\/tr>\n

\n

HTML<\/p>\n<\/td>\n

\n

Hyper Text Markup Language<\/p>\n<\/td>\n<\/tr>\n

\n

IBAC<\/p>\n<\/td>\n

\n

Identity-Based Access Control<\/p>\n<\/td>\n<\/tr>\n

\n

LTP<\/p>\n<\/td>\n

\n

Online Transaction Processing<\/p>\n<\/td>\n<\/tr>\n

\n

MAC<\/p>\n<\/td>\n

\n

Mandatory Access Control<\/p>\n<\/td>\n<\/tr>\n

\n

MVC<\/p>\n<\/td>\n

\n

Model-View-Controller framework<\/p>\n<\/td>\n<\/tr>\n

\n

OrBCA<\/p>\n<\/td>\n

\n

Organization-Based Access Control<\/p>\n<\/td>\n<\/tr>\n

\n

PBAC<\/p>\n<\/td>\n

\n

Policy-Based access Control<\/p>\n<\/td>\n<\/tr>\n

\n

PJNF<\/p>\n<\/td>\n

\n

Project-Join Normal Form<\/p>\n<\/td>\n<\/tr>\n

\n

PLP<\/p>\n<\/td>\n

\n

Principle of Least Privilege<\/p>\n<\/td>\n<\/tr>\n

\n

RAdAC<\/p>\n<\/td>\n

\n

Risk-Adaptive Access Control<\/p>\n<\/td>\n<\/tr>\n

\n

RBAC<\/p>\n<\/td>\n

\n

Role-Based Access Control<\/p>\n<\/td>\n<\/tr>\n

\n

RAC<\/p>\n<\/td>\n

\n

Rule-Based Access Control<\/p>\n<\/td>\n<\/tr>\n

\n

SQL<\/p>\n<\/td>\n

\n

Structured Query Language<\/p>\n<\/td>\n<\/tr>\n

\n

SSMS<\/p>\n<\/td>\n

\n

SQL Server Management Studio<\/p>\n<\/td>\n<\/tr>\n

\n

T-SQL<\/p>\n<\/td>\n

\n

Transact Structured Query Language or Transact-SQL<\/p>\n<\/td>\n<\/tr>\n

\n

TBAC<\/p>\n<\/td>\n

\n

Time-Based Access Control<\/p>\n<\/td>\n<\/tr>\n

\n

TCL<\/p>\n<\/td>\n

\n

Transaction Control Language<\/p>\n<\/td>\n<\/tr>\n

\n

TDS<\/p>\n<\/td>\n

\n

Tabular Data Stream protocol<\/p>\n<\/td>\n<\/tr>\n

<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n<\/div>\n","protected":false},"author":2276,"menu_order":17,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":["fredstrickland"],"pb_section_license":""},"chapter-type":[],"contributor":[66],"license":[],"class_list":["post-1613","chapter","type-chapter","status-publish","hentry","contributor-fredstrickland"],"part":3,"_links":{"self":[{"href":"https:\/\/pressbooks.bccampus.ca\/nelson\/wp-json\/pressbooks\/v2\/chapters\/1613","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressbooks.bccampus.ca\/nelson\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/pressbooks.bccampus.ca\/nelson\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/nelson\/wp-json\/wp\/v2\/users\/2276"}],"version-history":[{"count":2,"href":"https:\/\/pressbooks.bccampus.ca\/nelson\/wp-json\/pressbooks\/v2\/chapters\/1613\/revisions"}],"predecessor-version":[{"id":1615,"href":"https:\/\/pressbooks.bccampus.ca\/nelson\/wp-json\/pressbooks\/v2\/chapters\/1613\/revisions\/1615"}],"part":[{"href":"https:\/\/pressbooks.bccampus.ca\/nelson\/wp-json\/pressbooks\/v2\/parts\/3"}],"metadata":[{"href":"https:\/\/pressbooks.bccampus.ca\/nelson\/wp-json\/pressbooks\/v2\/chapters\/1613\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.bccampus.ca\/nelson\/wp-json\/wp\/v2\/media?parent=1613"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/nelson\/wp-json\/pressbooks\/v2\/chapter-type?post=1613"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/nelson\/wp-json\/wp\/v2\/contributor?post=1613"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/nelson\/wp-json\/wp\/v2\/license?post=1613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}