31-08-2016, 04:14 PM
1451889005-Mysemin.pptx (Size: 147.46 KB / Downloads: 5)
Relation b/w stored items of information
Collective data sets organized by tables , records , columns
Tables communicate and share information, which facilitates data search ability, organization and reporting.
RDB uses SQL ,standard user application provides easy programing interface for database interaction
The account table below represents a relation in the relational model. The three columns titles are the attributes and their domains.
Each row is called a tuple.
An account is a subset of the set of all possible tuples.
keys
Keys are very important part of Relational database
Used to establish and identify relation between tables.
Set of attributes in a relation that identifies a tuple in relation.
These are defined in a table to access the stored data quickly and smoothly.