What is Key in the Database

Key (Data Base Key)

1) Keys are used to establish and identify relationship between tables in database.

2) They also ensure that each record within a table can be uniquely identified by

combination of one or more fields within a table.

3) There are various keys which plays an important role in designing the database.

Primary Key:

1) The attribute values which are unique within the relation that can be used to

identify the entity/tuples of that table/relation, is called primary key.

2) For example: (1) attribute “Student_Id”, can be used as primary key, since every

student has unique “Student_Id” in a Student database. (2) attribute “Account_No’,

can be used as primary key, since every Customer has unique “Account_No” in a

Bank database.

Super Key or Combination Key:

I) Super Key is defined as a set of attributes, taken collectively, within a table

uniquely identifies each record within a table.

2) Such keys are also known as combination key.

combination Key

Candidate Key:

1) Candidate keys are defined as a set of fields from which primary key can be

selected.

2) It is an attribute or set of attributes that can act as a primary key for a table to

uniquely identify each record in that table.

Secondary or Alternate Key:

1) The candidate key which are not selected for primary key is known as secondary

key or alternate key.

2) In the above table. Either Student_id or Roil_No is primary key and other will be

alternate key.

Non-key Attribute (Non-prime attribute):

1) All attributes other than candidate key attributes are called Non-key attribute.

2) The Non-key attribute is also known as non-prime attributes.

3) In the above table “Name”, “Address” and “course” are non-Key attributes.

Foreign Key:

1) Foreign key is generally a primary key from one table that appears as a field in

another table, where the first table has relationship with second.

2) Non-key of one table, which is a primary key of another table, is called Foreign key

3) Consider a table “Course” that has “course_Id” as primary key and consider another

table “student” that has “course_id” as one of its attribute, then “course_Id” would

be the “foreign Key” in “student” table.

What is Entity in Database

What is Relational Database Model

Relational Database Model: 1) The relational database model is developed by “ Edgar F. Codd ” at IBM in 1970. 2) The relational Database Model used the basic concept of a relation or table. 3) A table is a collection of records and each record in a table Contains the same fields. 4) Every row or entity (called Tuple) must have a unique identification or key based on the data. What is Data Base Model 5) The different tables may have the common column name (Attribute), but a single table must not Contain multiple columns (Attributes) with the same name. 6) The relationship between the two tables is implemented using a common and unique attribute in the tables. 7) Columns are attributes that belong to the entity modeled by the table. 8) order of rows (tuples/entity) and columns (attributes) is not important. 9) But every Tuple must be unique. It means that for every record or Tuple in a table there is something that uniquely identified ¡t from any ot...

A Scientist Proved Paradox-Free Time Travel Is Possible.

A Scientist Proved Paradox-Free Time Travel Is Possible A new study claims to resolve a long-standing time travel paradox, suggesting that time travel is both deterministic and locally free. The research, based on observations of a time- traveling qubit, concludes that the present remains unchanged by interference from the past. However, that doesn't mean stepping on butterflies is entirely risk-free. In a peer-reviewed paper published in Classical and Quantum Gravity, scientist Germain Tobar and his co-author Fabio Costa (both affiliated with the University of Queensland at the time) propose a mathematical proof demonstrating the physical feasibility of a specific type of time travel. Their study, titled "Reversible Dynamics with Closed Time-Like Curves and Freedom of Choice," finds a mathematical middle ground that resolves a key logical paradox in certain time travel models. The Mathematics of Time Loops The underlying math is intricate, but the core idea is straightfo...

What is Normalization in the database

What is Normalization in the database Normalization : 1). Normalization is the process of organizing the tables to minimize data redundancy 2)Redundancy is storing the same data item in more than one place. Database normalization is a design technique) by which an existing database is modified to minimize redundancy and dependency of data. 4) Edgar F. Codd introduced the concept of normalization in 1970.Objectives of normalization: Edgar F. Codd stated the objectives of normalization are as follows. To free the collection of relations from undesirable insertion, update and deletion dependencies. 2) To reduce the need for restructuring the collection of relations as new types of data are introduced, and thus increase the life span of application programs. To make the relations model more informative to users. 4 To make the collection of relations neutral to the query statistics. is normalization? Explain 1 NF with suitable example _____ ...

VRG Trick

Search This Blog