- Trending Categories
- Data Structure
- Operating System
- C Programming
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
RDMS Terminologies include Database, Table, Columns, etc. Let us see them one by one −
Database is a collection of tables like <Student>, <Professors>, etc.
A table is a collection of rows and columns , for example,
Column is in a table −
Row is also called a tuple in RDBMS.
A relation in a database has rows and columns.
Every table has one Primary key and cannot have null values.
For example, ProjectID is a primary key in Project Table, since it uniquely identifies the project:
|P01||Cluster Grouping System|
|P02||Hospital Management System|
If you want to link two tables, use Foreign Key.
For example, Employee table has DEPT_ID that is a foreign key, which is linked to Department table.
The Department table has primary key DEPT_ID.
Super Key is an attribute (or a set of attributes) that uniquely identify a tuple i.e. an entity in entity set. It is a superset of Candidate Key, since Candidate Keys are selected from super key.
A primary key having two or more attributes is called composite key. It is a combination of two or more columns.
- New and Old Terminologies used in History
- Future of RDBMS
- What are the terminologies of Information Security Models?
- Composite Key in RDBMS
- Secondary Key in RDBMS
- Super Key in RDBMS
- Surrogate Key in RDBMS
- Candidate Key in RDBMS
- Alternate Key in RDBMS
- Foreign Key in RDBMS
- Unique Key in RDBMS
- Referential Integrity Rule in RDBMS
- Entity Integrity Rule in RDBMS
- Difference between RDBMS and OODBMS
- Difference between DBMS and RDBMS