Flashcards in Databases Deck (20):
Define the word database
A database is a structured collection of data
What's a database management system?
A database management system is a software system that enables the management of a database. E.g access, SQL, ORACLE
What's a data model
A method of describing the data, it's stucture.
What's an entity
An entity is an object/person/event about which data is recorded
What's a relationship?
A relationship is an association or link between two entities
What are names for a row?
A record or a tuple
What are other names for a column
Field and attribute
What is entity occurrence
The details of one instance of the entity
What's a primary key
An unique attribute which uniquely identify a tuple
Relational database is?
A collection of tables
What's composite key
A combination of attributes that uniquely identify a tuple
What's a foreign key?
An attribute in one table that is a primary key in another table
What is meant by normalised entities
A set of entities that contain no useless/redundant data
A technique used to produce a set of normalised entities
Table have primary key and there's no repeating groups of attributes (atomic values)
Must be 1NF and contain no partial key dependencies - where the values of the attributes are all independent on the primary key
Table is in third normal from if it is in 2NF and where no attributes are predictable because of any other attributes
What does SQL stands for?
Structured query language
Why is 3NF important?
It improves consistency
No unnecessarily repeated data
Eliminate update/insertion/deletion anomalies