Created by: paul01234
Number of Blossarys: 51
A superkey which has a set of attributes whose values ensure the unique identification of the rows in a table. It is the principal means of identifying tuples in a relation. Its value is never, or at ...
The process of generating a set of relation schemas that allows the storage of information without unnecessary redundancy while still allowing the easy retrieval of information.
It is an attribute used to sort and identify data in the database. Types of database keys are primary keys, candidate keys, and foreign keys.
This refers to the collection of information stored in the database at a specific time or moment. A new instance is created when information is inserted, deleted, or updated in the database.
A set of attributes in a referencing relation. The value of the foreign key attributes are sure to occur as the primary key value of a row or tuple in the referenced relation or table.
This term refers to any distinctly identifiable item in a database. This may refer to people, locations, or goods, to name a few.
An organized collection of data which contains information relevant to an enterprise. A database is typically in a digital form.