Supper Key- s a set of one or more attributes that taken collectively and allow us to identify entities with in entity set.
In DBMS a table contains one or more columns there columns are the attribute in DBMS FOR EXAMPLE---say you have a table named "employee information"which have the following columns ID,NAME,ADDRESS THEN id ,name address are the attributes of employee..................
It is the DBMS that ensures the value of the foreign key matches another table's primary key when referential integrity constraints are enabled within the DBMS
collection of interrelated data & set of program & access those programITS GOALprimary goal of dbms is store & retrieve the database information in convenient & efficient way
Define the two principle integrity rules for the relational modelDisscuss why it is desirable to enforce these rules also explain how DBMS enforces these integrity rules?
web browsers
secondary index is a key which is created other than primary key, to speed up processing.
k onda k onda
define secondary key
tanya dek udek
Types of Attributes in Dbms areKey or non key attributesRequired or optional AttributesSimple or composite AttributesSingle-valued and multi-valued AttributesStored, Coded or derived Attributes
It is a pool of data through which data are enter into into the table for data management.
A software system that facilitates the creation and maintenance and use of an electronic database