2824333
Descripción
| Pregunta | Respuesta |
| What is a Database? | A persistent organised store of data on a computer |
| What is redundancy? | ‘Something’ or data that is unnecessary! |
| What is a entity? | An entity is a real-world object |
| What is a relational database? | A relational database has more than one table and the tables are linked using key fields. |
| What is a flat-file database? | Database contains a single table |
| Advantages of a relational database? (0/6) | Avoids data duplication Avoids inconsistent records Easier to change data Easier to change data format Data can be added and removed easily Easier to maintain security |
| Advantages of using an electronic database? (0/8) | Databases can store very large numbers of records efficiently (they take up little space). It is very quick and easy to find information. It is easy to add new data and to edit or delete old data. Data can be searched easily, eg 'find all Ford cars'. (Queries) Data can be sorted easily, for example into 'date first registered' order. Data can be imported into other applications, for example a mail-merge letter to a customer saying that an MOT test is due. More than one person can access the same database at the same time - multi-access. Security may be better than in paper files. |
| What is a primary key? | A primary key is a field in a table which is unique and enables you to identify every record in that table |
| What is a foreign key? | A foreign key is used to link tables together and create a relationship. It is a field in one table that is linked the the primary key in another table. |
| Define Record | A record is all of the data or information about one person or one thing. |
| Define a Field | A field is one piece of data or information about a person or thing. |
0 comentarios
¿Quieres crear tus propias Fichas gratiscon GoConqr? Más información.