null
US
Entrar
Registre-se gratuitamente
Registre-se
Detectamos que o JavaScript não está habilitado no teu navegador. Habilite o Javascript para o funcionamento correto do nosso site. Por favor, leia os
Termos e Condições
para mais informações.
Próximo
Copiar e Editar
Você deve estar logado para concluir esta ação!
Inscreva-se gratuitamente
1832365
GCSE Computer Science: Database
Descrição
Mapa Mental sobre GCSE Computer Science: Database, criado por MegzRevision em 04-01-2015.
Mapa Mental por
MegzRevision
, atualizado more than 1 year ago
Mais
Menos
Criado por
MegzRevision
mais de 9 anos atrás
38
2
0
Resumo de Recurso
GCSE Computer Science: Database
Entity
An entity is a person or physical thing about which data is held in a database
Field
An individual box in the data table
Table = The whole thing
Record
An entire row of data
Database management system / DBMS
Allows you to create a table
Componants
Tables
Forms
Queries
Reports
Modules
Program within an application that performs a specific task which cannot be done by simply making a query or report
Datatypes
Text
Integers
Numbers with a decimal
Dates
Currency
Yes/No fields
Primary Key
One field is designated as the p.k
Each record must have a different value in the p.k
Uniquely identifies the record
Validating Fields
Minimise errors when data is entered into the database
Specifying a rule that the data must obey
Range check
Type check
e.g. number
Presence check
Data entered in the field
Format check
List check
Must be item on predefined list
Data Redundancy
Holding more data than necessary
Takes time and space
Can result in inconsistent data
Each entity has an attribute
Attribute = Field in the table which describes the entity
One-to-one
e.g. husband/wife
One-to-many
e.g. mother/children
Many-to-many
e.g. pupils/subjects
Separation of Data
Data held about various entities are held separatly from the applications that use it.
e.g. many departments in a school can look at or use the data
Reduces data redundancy
Data is consistent
Saves storage
Database
Persistent, organised store of data
Persistent = Data stored on a non-volatile storage device
Organised = Structured into tables
Allows separation of data between applications and the database
Allows multiple applications to use a single database
Can allow many users to simultaneously access the data and it's applications
Provides security in terms of access rights
Can provide automatic backups
Reports
Useful feature of a DBMS
Reports are produed based on queries
When a user asks for a report based on a query, the query will automatically be run first using the latest data, so the report is up-to-date
Quer criar seus próprios
Mapas Mentais
gratuitos
com a GoConqr?
Saiba mais
.
Semelhante
Mapa conceitual - Parnasianismo no Brasil
Letícia Freato
Terminologia Cirúrgica
lion.elsuffi
Flashcards- Europa: Países e Capitais
Felipe Perreira
Uso do HÍFEN
Viviana Veloso
Edital da ReceitaFederal Auditor Fiscal
Alessandra S.
ORTOGRAFIA - emprego das letras
GoConqr suporte .
História da Arte - Barroco
Bruno Torrezan
AFO 3
Graciela Dias
Sala de Aula Invertida
GoConqr suporte .
FCE Phrasal Verbs True or False Quiz
titaleoni
EA-HSG-2010
carloshenriquetorrez .
Explore a Biblioteca