filmov
tv
Components of RDBMS|RDBMS.

Показать описание
Components of RDBMS
Components of RDBMS
Basically there are 4 components of RDBMS,namely
1,Table,2,Rows,3,Columns,4,Keys
Table
•1 table or 1 Relation represents 1 Entity
•Table stored records of RDBMS in columns and rows
Rows
•Rows are also called as records
•Combination of column values in a table is called as a row
•Rows store record and is represented by a primary key
Columns
•Attribute of objects are represented by a column
•Combination of records of same data types is called as column
Keys
•Keys are frield which represents a record
•Key are subset of a column with following properties
1,Key should have unique value,2,No data redundancy should be present
Components of RDBMS
Basically there are 4 components of RDBMS,namely
1,Table,2,Rows,3,Columns,4,Keys
Table
•1 table or 1 Relation represents 1 Entity
•Table stored records of RDBMS in columns and rows
Rows
•Rows are also called as records
•Combination of column values in a table is called as a row
•Rows store record and is represented by a primary key
Columns
•Attribute of objects are represented by a column
•Combination of records of same data types is called as column
Keys
•Keys are frield which represents a record
•Key are subset of a column with following properties
1,Key should have unique value,2,No data redundancy should be present