Mapa mental
Databases
Conteúdo do mapa
Databases
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.
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.
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.
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).
Informações
- Descrição
- Mapa Mental sobre Databases, criado por bethlewis em 04-03-2015.
- Criado por
- bethlewis · mar 2015
- Atualizado
- 19 fev 2016
- Visualizações
- 2
- Tags
- Avaliação
Mais sobre Database Keys and Relationships