Data Management tools TYK questions

Chapter 3: Data management tools (TYK Questions)

1. Online data can be used to sign up customers to their website, to include customers in a mailing list & send them catalogues, and to create online surveys to see what the customers want.

2. Online forms do not need to be physically checked over by the company, and do not have to be read and re-inputed into the database.

3. Cookies gather the users email address and web viewing preferences.

4. Policies are used to ensure that the content is disclosed only within certain people and that how that website uses the data that is collected from the individual.

5. Policies protect the users of the website by defining how their information that is gathered with be used and how this information will be disclosed to others, if it is to do so.

6. A flat file database stores information in tables consisting in rows and columns, where a relational database is multiple tables all sharing information between one another in a single database.

7. Forms organise all the data that is recorded into the correct are of the file and database. Each form must comply with the 3 rules for RDBMS, checking that all the data matches its correct place in the table.

8. Queries can filter out a number of records by meeting a criteria, whether it be name, number, a piece of text or an expression.

9. A primary key is important in relational databases because it uniquely identifies each record in a database table.

10. A primary key uniquely identifies each record in a database table.

11. Fixed decimal places – ie. Dollars & cents, date – 23/3/11 or 3/23/11, true or false. Each of these can be used in a data entry table.

12. Each field is specified to only hold a certain number of characters, or a certain character style whether it be numeric or alphabetical