10. Database and file concepts
A section of Information Technology, 9626
Listing 10 of 87 questions
Fernandez, Mariela Sales Using this LOCATE function, write down the formula he would use in cell C3. The formula must be easy to replicate. = You can use the space below for any working you need. He will use a formula in cell E3 to produce Smith. Making use of cell C3, write down the formula, without using the MID function, which must be easy to replicate. There must be no spaces, before, or after the name. = You can use the space below for any working you need. He will use a formula in cell F3 to produce John. Making use of cell C3, write down the formula, without using the MID function, which must be easy to replicate. There must be no spaces before, or after, the name. You can use the space below for any working you need. Describe the steps he would use to format the Weekly pay column so that the only difference that would be made would be to place a $ sign in front of the value. Using only the sort feature on columns I and J, explain how you would be able to get the following values in the given cells. You need to ensure data integrity is maintained. 500 in cell J6 with Secretary in cell I6 and Davies, Iueuan in A12. 500 in J7 with Orders in I8 and Smith, John in A11. 11 Maria, the A level students’ secretary, has been given the task of creating a database. It will store the records of each subject taught and the records of the teachers involved. She has decided to produce a relational database. The Teacher records will have the fields Teacher_ID, Family_name, First_name, Subject_ID and Number_of_classes. The Subject records will have the fields Subject_code, Subject_name, Subject_level and Number_of_lessons. Complete the diagram below to show how the tables will be combined. Using the design of your database from part , describe how you would create it.
9626_s19_qp_11
THEORY
2019
Paper 1, Variant 1
View
Below is an extract from a database of students who have chosen to study Maths at AS Level. The database is in unnormalised (0NF) form. Student number Name Second subject Third subject Eashan Wadhwa Chemistry Physics Karan Bansal Physics Chemistry Manan Malik Chemistry Biology Neel Bhatia Biology Chemistry Ridhima Shekhar History Biology Rohin Pannu Geography History Saransh Anand History Geography Shraddha Aggarwal Biology Chemistry Rekha Pooja Physics Chemistry Sundar Rakshana Physics Chemistry Describe the characteristics of the data above which make it unnormalised and explain how it can be transformed into first normal form (1NF).
9626_m17_qp_12
THEORY
2017
Paper 1, Variant 2
View
Questions Discovered
87