What are my rights?
Personal information must be fairly and lawfully processed.
Personal information must be processed for limited purposes.
Personal information must be adequate, relevant and not excessive.
Personal information must be accurate and up to date.
Personal information must not be kept for longer than is necessary.
Personal information must be processed in line withe data subjects' right.
Personal information must be secure.
Personal information must not be transferred to other countries without adequate protection.
It does not effect: National security, crime, taxation, heath, education and social work, or school and examinations.
Friday, 29 April 2016
Thursday, 28 April 2016
Database Query Questions
The airline has a database of customer names and addresses.
(e) The database makes use of simple and complex queries.
(i)What is the difference between a simple and complex queries.
A simple query uses only one parameter or criteria with two fields of data. A complex query has more than one parameter or two or more criteria. This can be split into an AND query which search both parameters, or an OR query which searches one or the other but not both.
(ii)Give an example of a simple query and a complex query that could be used to search the customer database.
Simple: Departure of the flight as it only uses one parameter and doesn't need another to be a precise search.
Complex: Destination and date of the flight would allow for a more concise search as it would allow you to pinpoint when and where the flight is with the use of both parameters.
Give an example of a complex query that could be used to search the customer table (of a school).
For a school, a complex query that uses the parameters of surname and year group, which would allow a more concise search as there would probably be more than one person with a certain surname in a whole school. Using a year group would narrow this down to one or maybe two results, depending on the size of the school and the commonness of the name.
(e) The database makes use of simple and complex queries.
(i)What is the difference between a simple and complex queries.
A simple query uses only one parameter or criteria with two fields of data. A complex query has more than one parameter or two or more criteria. This can be split into an AND query which search both parameters, or an OR query which searches one or the other but not both.
(ii)Give an example of a simple query and a complex query that could be used to search the customer database.
Simple: Departure of the flight as it only uses one parameter and doesn't need another to be a precise search.
Complex: Destination and date of the flight would allow for a more concise search as it would allow you to pinpoint when and where the flight is with the use of both parameters.
Give an example of a complex query that could be used to search the customer table (of a school).
For a school, a complex query that uses the parameters of surname and year group, which would allow a more concise search as there would probably be more than one person with a certain surname in a whole school. Using a year group would narrow this down to one or maybe two results, depending on the size of the school and the commonness of the name.
Tuesday, 26 April 2016
26/04/16 Data Dictionary questions
Describe three components of a data dictionary.
1) One component of a data directory is the topology of the database, which describes what each field and table in the database will do. It also includes a short description of each field or table.
2) Another component of a data dictionary is the data type of each field. This makes it easier to create the database because then only the correct data type can be input into the fields, for example, setting a name to text, else somebody could put numbers into it.
Bold=over lined
EMPLOYEE(EmployeeID, Surname, Forename, DateOfBirth, AddressLine1, AddressLine2, Town, Postcode, ContactNumber, DepartmentID, QualificationID, DateHired)
DEPARTMENT TABLE(DepartmentID, DepartmentDescription)
QUALIFICATIONS TABLE(QualificationID, QualificationDescription)
Field name Data type
Oder completed? Text
Total cost of order Currency (real number)
1) One component of a data directory is the topology of the database, which describes what each field and table in the database will do. It also includes a short description of each field or table.
2) Another component of a data dictionary is the data type of each field. This makes it easier to create the database because then only the correct data type can be input into the fields, for example, setting a name to text, else somebody could put numbers into it.
Bold=over lined
EMPLOYEE(EmployeeID, Surname, Forename, DateOfBirth, AddressLine1, AddressLine2, Town, Postcode, ContactNumber, DepartmentID, QualificationID, DateHired)
DEPARTMENT TABLE(DepartmentID, DepartmentDescription)
QUALIFICATIONS TABLE(QualificationID, QualificationDescription)
Field name Data type
Oder completed? Text
Total cost of order Currency (real number)
Thursday, 21 April 2016
3.1.5 Databse Questions
2) The airline has a database of customer names and addresses.
a) identify the most appropriate data type for the following fields:
House number: String
Price of tickets: Currency
Telephone number: String
b) Data entered into the database needs to be verified.
I)What is the purpose of verification?
Verification aims to make sense of data and must be complete and within acceptable boundaries.
Ii)Describe how proof reading works as a method of verification.
It makes sure that it is complete and makes sense, but it can also allow human error as if the same thing is overlooked on the second reading proof reading wouldn't be
a) identify the most appropriate data type for the following fields:
House number: String
Price of tickets: Currency
Telephone number: String
b) Data entered into the database needs to be verified.
I)What is the purpose of verification?
Verification aims to make sense of data and must be complete and within acceptable boundaries.
Ii)Describe how proof reading works as a method of verification.
It makes sure that it is complete and makes sense, but it can also allow human error as if the same thing is overlooked on the second reading proof reading wouldn't be
Thursday, 14 April 2016
14/4/16 validation question
An online bank needs to think of improving their security system, what verification methods might they employ to develop a simple to use system?
A method that the bank could use to improve their security is using a required data type for each field, for example only being able to input text into the name field. This would validate the data as it couldn't have any other characters like numbers or punctuation in the field, which would eliminate most human error.
Another method they could use is to have required fields that the user has to fill in before they can submit the form, like contact details. This would allow the company to contact them if some of the information is wrong, whereas if they couldn't they would be legally obliged to delete the incorrect data under the Data Protection Act (1998). This would allow the company to verify the data with the person who submitted the data in the first place.
A method that the bank could use to improve their security is using a required data type for each field, for example only being able to input text into the name field. This would validate the data as it couldn't have any other characters like numbers or punctuation in the field, which would eliminate most human error.
Another method they could use is to have required fields that the user has to fill in before they can submit the form, like contact details. This would allow the company to contact them if some of the information is wrong, whereas if they couldn't they would be legally obliged to delete the incorrect data under the Data Protection Act (1998). This would allow the company to verify the data with the person who submitted the data in the first place.
Why to keep data relevant and up to date + evaluate question.
Why to keep data up to date and relevant.
Practical reasons: It's easier to do anything with data that is relevant, as it will all be correct and you'll never have to chase information to see if it's accurate.
Legal reasons: Under the Data Protection Act (1998) it is a legal requirement to keep all data up to date that is relevant, like address, phone number etc.
Usefulness reasons: If it's not up to date then the data won't be useful for anything.
Evaluate the importance of quality of data when developing a database.
Quality of data is important when developing a database because if the data isn't up to date then the functions of the database would be useless.If the quality isn't good, the the results won't be any good, making the whole system redundant. It would also be illegal if the data wasn't up to date under the Data Protection Act (1998), making the whole database illegal and not usable.
Practical reasons: It's easier to do anything with data that is relevant, as it will all be correct and you'll never have to chase information to see if it's accurate.
Legal reasons: Under the Data Protection Act (1998) it is a legal requirement to keep all data up to date that is relevant, like address, phone number etc.
Usefulness reasons: If it's not up to date then the data won't be useful for anything.
Evaluate the importance of quality of data when developing a database.
Quality of data is important when developing a database because if the data isn't up to date then the functions of the database would be useless.If the quality isn't good, the the results won't be any good, making the whole system redundant. It would also be illegal if the data wasn't up to date under the Data Protection Act (1998), making the whole database illegal and not usable.
Subscribe to:
Posts (Atom)