Consider supporting us on Patreon. Help us keep revisedeck free.
7.2. Design
A subsection of Information and Communication Technology, 0417, through 7. The systems life cycle
Listing 10 of 28 questions
The owner of a bookshop has a database of all the books she has in stock. As some of the data is being entered into the database it is checked using validation checks. An example of some of the records in the database is shown. Example data Field name Brotherhood of Wisdom Name of book Colin Turner Name of author ISBN 25/02/2021 Date of purchase Number of copies E Type of book The Fourth Man Name of book Aadha Khatri Name of author ISBN 18/03/2019 Date of purchase Number of copies H Type of book Indian Temples Name of Book Vihaan Laghan Name of author ISBN 12/02/2019 Date of purchase Number of copies H Type of book 1 10
0417_m21_qp_12
THEORY
2021
Paper 1, Variant 2
View
The manager of a car garage has asked a systems analyst to create a new database system for the checking of cars making sure they are safe to drive. The checking of cars is known as a service. Each car has a unique licence plate. The cars can either be powered by electric or petrol. Cars are serviced every 10000 km, for example 10000 km, 20000 km. The minimum cost of the service is 1500 rupees and the maximum is 5000 rupees depending on the model of car. Different models of car are serviced. The date of the service is agreed. Complete this table, filling in the field names and the most appropriate data types to create the database using the information given above. For any numeric field, specify the type of number. Data type Field name Vehicle_licence_plate Powered_by Numeric:integer Cost_of_service Text Date_of_service [ 1 13 The systems analyst is planning to create a relational database. Discuss the advantages and disadvantages of creating a relational database rather than a flat file database. 1 13 For each of the fields shown, name and describe one validation check that could be used on the data. Your answers must be different in each case. Vehicle_licence_plate Validation check Description Cost_of_service Validation check Description Date_of_service Validation check Description
0417_m22_qp_12
THEORY
2022
Paper 1, Variant 2
View
For Examiner's Use 13 Davina has asked Boris, a systems analyst, to create a new database system for her zoo. She keeps animals of all types. Here are some of the questions that visitors to the zoo ask: What is the name of the female lion you have? How heavy is Jumbo the elephant? How much does it cost to adopt a tiger? Complete the data dictionary below filling in the field names and most appropriate data type to create a database which would answer these questions. Field name Data type Name Text Species Weight Currency Boris will provide two types of documentation when the system is implemented. Name each type of documentation and for each one give two items which would be included. Name Item 1 Item 2 Name Item 1 Item 2
0417_s13_qp_13
THEORY
2013
Paper 1, Variant 3
View
A headteacher wishes to store details of her students in a computer database. She has been given an example of one student record by the school secretary: Strauss, Johann, SR132516, 83, 01/09/2011 This corresponds to family_name, first_name, Student_Id, Maths_test_score, joined_the_school. The file is currently stored in the form of plain text with each record separated by a line break. Give a file extension which is appropriate for this file. For each field identify the most appropriate data type. The Maths_test_score is used in calculations. Field name Data type family_name fi rst_name Student_Id Maths_test_score joined_the_school Identify the two fields for which a format check would be the most appropriate validation check. In each case describe how the format check would work. The school secretary will use a screen input form to make it easier to enter data on the new system. Design a suitable screen input form to enter the details of one student using the fields given in part but leaving the field contents blank. It should contain appropriate spacing for each field, as well as navigation aids and other appropriate features of a screen input form.
0417_s15_qp_12
THEORY
2015
Paper 1, Variant 2
View
Maria is the principal of the International Municipal school. She has employed Paulo, a systems analyst, to create a new database system to store records of her final year IGCSE students. Examples of the details of the students which will be stored are: Velia Grimaldi, A3058, Female, 161, Leaving Giuseppe Campo, A3072 , Male, 177, Staying on to 6th form Nicola Donati, B3085, Female, 173, Staying on to 6th form Giovanni Agnelli, C3102, Male, 172, Leaving Complete the following table by entering the field names and most appropriate data type for each field. For any numeric field, specify the type of number. Data type Field name Name Boolean Height Paulo wishes to save storage space. He does not change the Name field, but decides that two other fields could have their data shortened. Apart from the Name field, identify the two other fields and describe how the contents will be shortened. Field 1 Shortened form 1 Field 2 Shortened form 2 1 19 There is no key field set. Maria’s secretary typed in the data to the database in this order: Giuseppe Campo, A3072, Male, 177, Staying on to 6th form Giovanni Agnelli, C3102, Male, 172, Leaving Nicola Donati, B3085, Female, 173, Staying on to 6th form Velia Grimaldi, A3058, Female, 161, Leaving Maria can get the database back in to the original order by sorting the data using one field. Write down the name of this field and the order in which it will need to be sorted. Field Order
0417_s16_qp_12
THEORY
2016
Paper 1, Variant 2
View
Dwarf 0.401 N Haumea When Petr was designing his database, he had to set the data types for each field. Complete the design table below by filling in the data types for each named field. Use the most appropriate data type. Each data type must be different. For any numeric field, specify the type of number. Data type Field name Number_of_moons Orbital_period Rings Name_of_planet 1 2 Operators such as AND, OR, NOT, LIKE, >, >=, can be used to search Petr’s planet database. The search criteria for all the gas giant planets with more than 20 moons would look like this: Type_of_planet = ''Gas Giant'' AND Number_of_moons > 20 Write down the search criteria that will produce a list of planets that are not gas giants but have at least one moon and were first observed after 1800. Write down the names of the planets that are not gas giants but have at least one moon and were first observed after 1800. Petr has copied the data from the Orbital_period field into a spreadsheet. The data for the orbital period for Mars, 1.88, is stored in cell A2. In cell B2 he has entered a function of: ROUND(A2,0) Explain in detail the function used in cell B2. [ 1 2
0417_s21_qp_12
THEORY
2021
Paper 1, Variant 2
View
For Examiner's Use 18 Aysha needs to enter customer details into her company’s database. She has asked her friend Ali to design an input screen to enable her to do this. She is not pleased with his attempt. Describe five improvements which could be made to this screen. Name Address Date of birth / / Customer ID Type in male or female Type in next for next record or back for previous record For Examiner's Use The new system will be tested. The month part of the date of birth field must be a whole number between 1 and 12 inclusive. Using this as an example, describe the following three types of test data. Abnormal data Normal data Extreme data
0417_w10_qp_11
THEORY
2010
Paper 1, Variant 1
View
Paul owns a shop. He has employed Jean, a systems analyst, to write software for a new database system to store data about the CDs he sells. Jean wrote down three of the questions that customers might ask which Paul might need to find the answers to quickly: Have you got the CD recorded by the artist ‘Bett Lyryx’ in 2008? How much does the CD called ‘Let It Be’ cost? How many tracks are on the CD? Complete the data dictionary table below giving the field names which would be used in the database and identify the data types needed to answer these questions. Field name Data type Artist_name text text For Examiner's Use No CD lasts for longer than 90 minutes or is shorter than 20 minutes. Paul wants to add a field to the database to include this data. He will use test data on this field. Name three types of test data, giving an example of the data which would be used. Type 1 Example 1 Type 2 Example 2 Type 3 Example 3 When the system is implemented, documentation will be provided. Tick four items that would be included in the technical documentation but not in the user documentation.  purpose of the system limitations of the system program coding system flowcharts hardware and software requirements file structures list of variables frequently asked questions
0417_w13_qp_13
THEORY
2013
Paper 1, Variant 3
View
Questions Discovered
28