DEFAULT
Definition:
The term Default is used to describe a preset value for some option in a computer program. It is the value used when a setting has not been specified by the user. In computer technology, a default (noun, pronounced dee-FAWLT) is a predesigned value or setting that is used by a computer program when a value or setting is not specified by the program user.
My Own Understanding:
Default is relevant to something that is used when something else is not supplied or specified. To default is to intentionally or accidentally allow the pre-established value or setting for an item to be used by the program. The program is said to default when it uses a default value or setting.
MS RIBBON
Definition:
It is an interface where a set of toolbars are placed on tabs in a tab bar. Recent releases of some Microsoft applications have embraced this form with a modular ribbon as their main interface. The Ribbon GUI provides the user interface of an application with a large toolbar filled with graphical representations of control elements which are grouped by different functionality. The Ribbon can also contain tabs to expose different sets of control elements eliminating the need for a lot of different icon-based tool bars. Some of these tabs are contextual and appear only when a certain type of object is selected, providing specific tools for items such as tables or images.
My Own Understanding:
The Ribbon is the strip of buttons across the top of the main window. Here on the Ribbon you will find access to anything the program has to offer. You no longer have to hunt endlessly through many menus and sub menus to find the command you want. Commands are located in logical places now, unlike in earlier versions of all things Microsoft.
PRIMARY KEY
Definition:
The primary key of a relational table uniquely identifies each record in the table. It can either be a normal attribute that is guaranteed to be unique (such as Social Security Number in a table with no more than one record per person) or it can be generated by the DBMS (such as a globally unique identifier, or GUID, in Microsoft SQL Server). Primary keys may consist of a single attribute or multiple attributes in combination.
My Own Understanding:
A primary key, also called a primary keyword, is a key in a relational database that is unique for each record. It is a unique identifier, such as a driver license number, telephone number, or vehicle identification number. A relational database must always have one and only one primary key. Primary keys typically appear as columns in relational database tables.
FOREIGN KEY
Definition:
Foreign key is a referential constraint between two tables. A foreign key is a field in a relational table that matches a candidate key of another table. The foreign key can be used to cross-reference tables. The foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. A foreign key is a field in a relational table that matches a candidate key of another table. The foreign key can be used to cross-reference tables. The foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table.
My Own Understanding:
A foreign key is a field in a relational table that matches the primary key column of another table. The foreign key can be used to cross-reference tables. A foreign key which is also called a foreign keyword, in a database table is a key from another table that refers to a specific key, usually the primary key , in the table being used.
ONE-TO-MANY RELATIONSHIP
Definition:
One-to-many relationships are the most common type of database relationship. They occur when each record in the first table corresponds to one or more records in the second table but each record in the second table corresponds to only one record in the first table. A one-to-many relationship is created if only one of the related columns is a primary key or has a unique constraint.
My Own Understanding:
In a one-to-many relationship, each row in the related to table can be related to many rows in the relating table. This allows frequently used information to be saved only once in a table and referenced many times in all other tables. In this type of relationship, a row in table A can have many matching rows in table B, but a row in table B can have only one matching row in table A.
