Databases

Databases

1. Key term

   • Table
     • A database term. A table contains a set of records. Tables can be permanent or they can be created by a query for temporary use. You set up relationships between tables in order to create a relational database.
   • Primary Key
     • A Key Field or Primary Key is a field within a database which enables every record to be uniquely identified. For example, at school you probably have a student or office number. This uniquely identifies you from every other student in the school. If you have a bank or savings account, you will have a bank account number which is unique and different from every other bank account number. This ensures that your money won't get muddled up with anyone elses and that you can easily keep track of deposits and withdrawals of cash.
   • Field
     • A field is a single piece of data about one person or one thing. Many fields make up a record. A field is usually a single column within a multi-column table.
   • Record
     • A database term. A record is all of the data about one person or one thing. A record is made up of one or more 'fields'. For example a name and address database could have one record such as this: "Joe Blogs", "34 Wyvern Road" , "Manchester", "UK", "MN253PE" This is a complete record, with each field separated by a comma.

2. Example

   • Yell
   • Faceboot
     • Google
   • Argos

3. Data types+

   • Text
     • This is a term used to describe the words and characters on a page. The page can be paper or it can be electronic such as this web page you are reading. The way text looks depends on the 'font' used to create it. For example _sans: This is font without any sharp bits on the ends of letters times roman: This has pointy bits on the ends of the letters courier: This is courier font
   • Dates/Time
   • Enter text here