Databases

Sep Latifi
Mind Map by Sep Latifi, updated more than 1 year ago
Sep Latifi
Created by Sep Latifi almost 5 years ago
5
0

Description

you cant copy this I don't five you permission

Resource summary

Databases

Annotations:

  • database
1 What is a database?
1.1 A collection of data or information held together in an organised or logical way.
2 DBMS
2.1 Database management system
2.1.1 Control all aspects of the database
2.1.1.1
2.2 Separates applications from the data. When people use the applications they call on the data they need to work on. They do not need to use all the data every time they use the database.
2.2.1 Good as not all the data for everyone would be needed for the specific application
3 Flatfile Database
3.1 Relational Database
3.1.1 Holds its data over a number of tables. Records within the tables are linked (related) to records held in other tables.
3.1.2 A primary key provides a way to uniquely identify every record in a table.
3.1.2.1
3.1.3 A foreign key is used to link tables together and create a relationship. It is a field in one table that is linked to the primary key in another table.
3.1.3.1
3.2 Advantages
3.2.1
3.3 Disadvantages
3.3.1
3.4 Definition
3.4.1 The flat file database consists of columns to describe the fields and rows to hold each record
4 GET LOST ROB
Show full summary Hide full summary

Similar

FLAT FILE VS RELATIONAL DATABASE
rosiejones
Relational Databases
BadSideSecret
Databases
Luke Hashem
Computer Science
Bayram Annanurov
Computing Topic 5 Databases
Will Darby
Databases
loz .
ICT revision
Jamie W
Relational Database Concepts
Emma Dolby
Patient Record System- UOP-DBM/381-WEEK5
j03garcia
Databases!
Emily Lewis
Relational Databases
Anisha Rai