DBMS -KYES

-

Key has important role in relational database: It is used for identifying unique rows from table.It  establishes relationship among tables.

Types of keys :Composite keys ,Super keys , candidate keys, primary key, secondary keys ,

Composite Key : A key that consists of more than one attribute to uniquely identify rows (also known as records & tuples) in a table is called composite key.

Super Key : A super key is a set of one of more attributes to uniquely identify rows in a table.

Candidate Key : A minimal  super key with no redundant attributes .

Primary key: A Primary key is selected from a set of candidate keys. This is done by database admin or database designer. 

Foreign Key : Foreign keys are the attributes of a table that points to the primary key of another table.They act as a cross-reference between tables.


Comments

Post a Comment

Popular posts from this blog

COMPUTER ORGANISATION & ARCHITECTURE TUTORIAL 1

-
Image
We can start learning basics of Computer Organisation & Architecture  .  Understand the difference between computer architecture & organisation first . BASIC OPERATIONAL CONCEPTS  We can discuss about various operations used for transferring and manipulating data BUS STRUCTURE We can consider definition of BUS also about way of transferring data through Bus . MEMORY LOCATIONS & ADDRESSING Understand the basics of System Memory ,way of storing data in memory.  W can discuss here about memory addresses and about Byte addressable memory .At the end we will get the idea about memory size specification and how to calculate the address of memory bytes . INSTRUCTION EXECUTION &STRAIGHT LINE SEQUENCING Understand what an instruction is ,then learn about how to complete the execution of a program which is present in main memory of the system by executing set of instructions one after another . Here consider , two situations of instruction execution ,sequential execution and 
Read more