Relational Databases

BadSideSecret
Mind Map by , created over 5 years ago

A Mind Map containing a compacted verion of everything you need to know for relationa database.

133
10
1
BadSideSecret
Created by BadSideSecret over 5 years ago
OCR AS CHEMISTRY A DEFINITIONS
awesome.lois
Biology AS Level Vocab- OCR- Chapters 1 and 2
Laura Perry
Geography Coasts Questions
becky_e
German Irregular Verbs
Shane Buckley
Testing for ions
Joshua Rees
AS English language terminology revision
Caitlin Hadfield
A Level: English language and literature technique = Dramatic terms
Jessica 'JessieB
English Speech Analysis Terminology
Fionnghuala Malone
Psychology flashcards memory
eharveyhudl
English Grammatical Terminology
Fionnghuala Malone
Relational Databases
1 File
1.1 Table
1.1.1 Record
1.1.1.1 All data about one person or thing.
1.1.1.1.1 Quite a few fields can be used to make a record e.g. name, address,age,date of birth.
1.1.2 Field
1.1.2.1 Primary Key
1.1.2.1.1 A field in a table which is unique and this helps to identify records or people
1.1.2.1.2 Referential integrity
1.1.2.1.2.1 Every foreign key value has a matching value in the appropriate primary key field.
1.1.2.2 A piece of data related to a person or thing
1.1.2.3 Foreign keys
1.1.2.3.1 A primary key in one table inserted as a normal field in another table
1.1.2.4 Attributes- Name,Age,Address
1.1.3 Records are stored in here.
1.1.4 Made of quite a few pieces of information, e.g. First Name, Address, Age
1.1.5 Entities- objects,people,things
1.1.6 RelationShips:
1.1.6.1 One to Many
1.1.6.1.1 Where one entity can have many relations- such as 1 doctor has many patient or 1 student has many exams
1.1.6.2 Many to many
1.1.6.2.1 where many entities can have many relationships e.g. 1 video can be hired by several customer BUT those customers can hire several videos
1.1.6.3 One to One
1.1.6.3.1 When one entity can only be related to one entite e.g. 1 man has 1 wife.
1.2 Many tables are stored in a file, this is the database.
2 Vast amounts of info can be stored!
3 Queries can be run to search for specific records.
3.1 Searching is what a query does.
3.1.1 Parameters are just search criteria
3.1.2 4 Types
3.1.2.1 Static-the parameters stay the same for ever.
3.1.2.2 Dynamic- you can change the search result sto what you need
3.1.2.3 Simple- only 1 parameter is used at a time
3.1.2.4 Complex-more than one parameter is used
4 Reports can be created from data stored or queries run
4.1 presents data taken from a query or from tables in a preformatted attractive manner
5 Validation can be used to reduce errors.
5.1 Validation!
5.1.1 Makes sure that the data is: accurate sensible,within acceptable boundaries.
5.1.1.1 Range Check- makes sure that the value entered is between 2 preset boundaries
5.1.1.2 Lookup Check-Allows only a limited amount of item to be selected
5.1.1.3 Length Check- checks that the data entered is a certain length.
5.1.1.4 Presence check- makes sure something is enteredin the field
5.1.2 NEVER MAKES SURE THAT THE DATA IS CORRECT!!!
5.2 Verification
5.2.1 Making sure that the data on the source document is the same as the object doucument.
5.2.1.1 Proof Reading- double checking your work basically.
5.2.1.2 Double entry- where two people input the same document and these are then compared any differences are then noted and rectified.
6 Forms Used to enter data.
6.1 A window/Screen with multiple spaces to enter data.

Media attachments