Supper Key- s a set of one or more attributes that taken collectively and allow us to identify entities with in entity set.
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
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..................
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?
define secondary key
secondary index is a key which is created other than primary key, to speed up processing.
k onda k onda
web browsers
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
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
tanya dek udek