Gestalte GoConqr mit. Was sollen wir als Nächstes hinzufügen?

Mindmap

Databases

bethlewis Englisch

Inhalt der Mindmap

Databases

  1. Databases are used to store information

    • They're a collection of related data.
    • Databases can store vast amounts of data without taking up too much space.
    • Users can search, sort and combine data very quickly.
    • Databases can be used to produce reports.
  2. Database terms

    • Entity- is a name given to anything that data is stored about. All the data held in an entity refers to that entity. e.g. the entity 'customer' will only hold data about customers.
    • Attributes- the attributes describe the property of the entity. e.g. the entity 'customer' may have the attributes name, address, town, phone.
    • Record- a record is a collection of data about a single item e.g. a particular item, supplier, student etc. Each row in a database table is a separate record. Each record in a table must be unique.
    • Fields- fields break the records into separate pieces of data. Each field must have a unique name and contain a single data item. Fields can have different data types and have their own validation.
  3. Keys

    • # Primary key- is a field in a table that allows each record to be uniquely identified. Every value in the primary key field must be different.
    • * Foreign key- used to link tables together to form relationships. A foreign key is a primary key in one table that is linked to a field in another table. The data types of the fields linked must be the same.
  4. Relationships

    • One-to-one- one instance of a entity can be associated with only one instance of a second entity. e.g. one company car for each employee.
    • One-to-many- one instance of an entity can be associated with many instance of another entity. e.g. one library member can take out many books.
    • Many-to-many- many instances of an entity can be associated with many instances of another entity. Most many-to-many relationships get avoided by using a link entity.
      • A link entity breaks a many-to-many relationship into 2 many-to-one relationships.
      • e.g. one customer can buy many products and each product can be brought many customers.
        • By using a link entity it becomes: one customer can place many orders (one-to-many) and one product can appear on many orders (one-to-many).

Informationen

Beschreibung
Mindmap am Databases, erstellt von bethlewis am 04/03/2015.
Erstellt von
bethlewis · Mär 2015
Aktualisiert
19 Feb 2016
Aufrufe
2
Tags
ictas level
Bewertung

Mehr zu Database Keys and Relationships

Feedback

Worum geht es?

Was sollen wir als Nächstes hinzufügen?