DATABASE BASIC

Master database basics! Learn data types, keys, validation, and more.

Are they data or information? Tick the relevant box in the table. Data 25 December 109784562 Information There are three deliveries that I need to make today 31 days Data Type Choose a suitable data type for each data example given first name text passed exam? boolean exam cost currency score integer Information data that has meaning, not just a number or a letter. Data Values, typically letters or numbers. Flat-file database A database consisting of only one table often stored as a CSV file. Identify the most appropriate field to be the primary key in the table tbl_customer. Justify your choice. Name four validation techniques. Length check - only allows a specific number of characters to be entered.Range check– number entered must be within a certain range, eg between 1-100.Present check – the field cannot be left empty. Type check- Checks the data is in the right format Matching table a set of fields and records Records contain a collection of data for each entity, usually recorded as a row in the table. Fields The column headings and contains a different attribute Primary key contains a unique identifier for each record Data type the data types are used in each field Field size the maximum or minimum size of entry Validation the rules for accepting data Private Postal People (P-Cubed)Private Postal People (P-Cubed) is a national delivery service specialising in small letters, large letters, small packages, and medium packages. The company has regional depots across the country. The company runs a fleet of delivery vans. It uses technology to help run the business. It does not deliver internationally.P-Cubed has 2000 employees, some based in the head office, some working in the regional sorting offices and some driving the delivery vans.P-Cubed uses automatic sorting machines.P-Cubed stores data about the sorting machines in tables.The primary key field for each table is shown in bold. State the purpose of a primary key in a database table. State the foreign key in tbl_Production. There is a one-to-many relationship between these tables. Complete the diagram to show this relationship. Upload your diagram here! What is an automatic computer check to make sure data entered is sensible and reasonable known as? Validation Double entry Verification Which of the following statements is false? Validation can check that the data is correct Validation can check that the data falls between certain allowable boundaries Which of the following statements is false? Which of the following is NOT a method of verification? Printing out what you have typed in and comparing it against the source data Double entry - typing the data in twice and getting the computer to check the second version against the first Using presence, range and length checks to make sure that no mistakes happen Which of the following is a definition of a relational database .... a database with one table only a database that is linked to anotherfile a database containing severaltables, linked using primary andforeign keys The “text” field type can be used to store which of the following .... only numbers such as 1, 2, 3, 4, 5 any combination of charactersincluding punctuation marks, letters,symbols and numbers only letters such as a, b, c, a, b, c What is the link between tables in a relational database called .... a relationship a foreign key a hyperlink The Sports Club has had an Open Day and has gained a new member. How will they add their details to the database .... add a new field add a new database add a new record