Relational Databases

Description

A Mind Map containing a compacted verion of everything you need to know for relationa database.
BadSideSecret
Mind Map by BadSideSecret, updated more than 1 year ago
BadSideSecret
Created by BadSideSecret over 10 years ago
203
10

Resource summary

Relational Databases
  1. File
    1. Table
      1. Record
        1. All data about one person or thing.
          1. Quite a few fields can be used to make a record e.g. name, address,age,date of birth.
        2. Field
          1. Primary Key
            1. A field in a table which is unique and this helps to identify records or people
              1. Referential integrity
                1. Every foreign key value has a matching value in the appropriate primary key field.
              2. A piece of data related to a person or thing
                1. Foreign keys
                  1. A primary key in one table inserted as a normal field in another table
                  2. Attributes- Name,Age,Address
                  3. Records are stored in here.
                    1. Made of quite a few pieces of information, e.g. First Name, Address, Age
                      1. Entities- objects,people,things
                        1. RelationShips:
                          1. One to Many
                            1. Where one entity can have many relations- such as 1 doctor has many patient or 1 student has many exams
                            2. Many to many
                              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
                              2. One to One
                                1. When one entity can only be related to one entite e.g. 1 man has 1 wife.
                            3. Many tables are stored in a file, this is the database.
                            4. Vast amounts of info can be stored!
                              1. Queries can be run to search for specific records.
                                1. Searching is what a query does.
                                  1. Parameters are just search criteria
                                    1. 4 Types
                                      1. Static-the parameters stay the same for ever.
                                        1. Dynamic- you can change the search result sto what you need
                                          1. Simple- only 1 parameter is used at a time
                                            1. Complex-more than one parameter is used
                                        2. Reports can be created from data stored or queries run
                                          1. presents data taken from a query or from tables in a preformatted attractive manner
                                          2. Validation can be used to reduce errors.
                                            1. Validation!
                                              1. Makes sure that the data is: accurate sensible,within acceptable boundaries.
                                                1. Range Check- makes sure that the value entered is between 2 preset boundaries
                                                  1. Lookup Check-Allows only a limited amount of item to be selected
                                                    1. Length Check- checks that the data entered is a certain length.
                                                      1. Presence check- makes sure something is enteredin the field
                                                      2. NEVER MAKES SURE THAT THE DATA IS CORRECT!!!
                                                      3. Verification
                                                        1. Making sure that the data on the source document is the same as the object doucument.
                                                          1. Proof Reading- double checking your work basically.
                                                            1. Double entry- where two people input the same document and these are then compared any differences are then noted and rectified.
                                                        2. Forms Used to enter data.
                                                          1. A window/Screen with multiple spaces to enter data.
                                                          Show full summary Hide full summary

                                                          Similar

                                                          FLAT FILE VS RELATIONAL DATABASE
                                                          rosiejones
                                                          A Level: English language and literature technique = Dramatic terms
                                                          Jessica 'JessieB
                                                          English Speech Analysis Terminology
                                                          Fionnghuala Malone
                                                          English Grammatical Terminology
                                                          Fionnghuala Malone
                                                          Biology AS Level Vocab- OCR- Chapters 1 and 2
                                                          Laura Perry
                                                          Geography Coasts Questions
                                                          becky_e
                                                          BIOLOGY HL DEFINITIONS IB
                                                          Luisa Mandacaru
                                                          Psychology flashcards memory
                                                          eharveyhudl
                                                          Religious Studies- Matters of life and death
                                                          Emma Samieh-Tucker
                                                          Religious Studies- Marriage and the family
                                                          Emma Samieh-Tucker
                                                          AS English language terminology revision
                                                          Caitlin Hadfield