viewquestions/12422/ Define the database and briefly explain the implicit properties of the database Database Management Systems 10CS54 VTU notes 4 Marks JuneJuly 2015

The Eduladder is a community of students, teachers, and programmers just interested to make you pass any exams. So we solve previous year question papers for you.
See Our team
Wondering how we keep quality?
Got unsolved questions?

Ask Questions
Database-Management-Systems---10CS54-VTU-notes-->View question


) Define the following terms with an example for each? : Database Management Systems - 10CS54 VTU notes 8 Marks (Jun / July2014)

Explain in brief?

By:anonymousguy7799

Taged users:


Likes:
Be first to like this question

Dislikes:
Be first to dislike this question

Talk about thisDelete|Like|Dislike|


Answers

Super key: A set of attributes SK of R such that no two tuples in any valid relation instance r(R) will have the same value for SK. That is, for any distinct tuples t1 and t2 in r(R), for any two distinct tuples t1 and t2 in a relation state r of R we have (the subset of attributes SK is called a superkey of the relation schema R).

 Domain: A set/universe of atomic values, where by “atomic” we mean simply that from the point of view of the database each value in the domain is indivisible.
 Tuple: A tuple is a mapping from attributes to values drawn from the respective domains of those attributes. A tuple is intended to describe some entity in the miniworld. 
Nulls: The null value is don’t know, not applicable Relational database schema: It is a set of schemas for its relations together with a set of integrity constraints.
Entity integrity constraint: The entity integrity constraint states that no primary key value can be null. This is because the primary key value is used to identify individual tuples in a relation: having null values for the primary keys implies that we cannot identify some tuples. Key constraints and entity constraints are specified on individual relations. 

Nikhil-bharadwaj

Likes:
Be first to like this answer

Dislikes:
Be first to dislike this answer
Talk about this|Once you have earned teacher badge you can edit this questionDelete|Like|Dislike|
------------------------------------

Can you help us to add better answer here? Please see this



Not the answer you're looking for? Browse other questions from this Question paper or ask your own question.

Join eduladder!