9608_s16_qp_13
A paper of Computer Science, 9608
Questions:
7
Year:
2016
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
3
A company needs new software to manage its accounts. It is evaluating two different options. One option is open source software and the other is commercial software. Explain what is meant by open source software. Explain what is meant by commercial software. The company has decided to purchase commercial software. Identify four benefits to the company in choosing the commercial software option.
1. Theory Fundamentals  →  1.7. Ethics and ownership
1. Theory Fundamentals  →  1.5. System software
3. Advanced Theory  →  3.4. System software
Open
4
The table shows assembly language instructions for a processor which has one general purpose register, the Accumulator (ACC) and an index register (. Instruction Explanation Op code Operand LDD Direct addressing. Load the contents of the given address to ACC. LDX Indexed addressing. Form the address from + the contents of the index register. Copy the contents of this calculated address to ACC. STO Store contents of ACC at the given address. ADD Add the contents of the given address to ACC. INC Add 1 to the contents of the register (ACC or . DEC Subtract 1 from the contents of the register (ACC or . CMP Compare contents of ACC with contents of . JPE Following a compare instruction, jump to if the compare was True. JPN Following a compare instruction, jump to if the compare was False. JMP Jump to the given address. OUT Output to screen the character whose ASCII value is stored in ACC. END Return control to the operating system. The diagram shows the contents of the index register: Index register: Show the contents of the index register after the execution of the instruction: INC IX Index register: Complete the trace table on the opposite page for the following assembly language program. LDX 90 DEC ACC STO 90 INC IX LDX 90 DEC ACC CMP 90 JPE 29 JPN 31 ADD 90 OUT ADD 93 STO 93 OUT END : : IX Selected values from the ASCII character set: ASCII Code Character A B C D E F G H
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
5
A Database Management System (DBMS) provides the following features. Draw a line to match each feature with its description. Feature Description Data dictionary Data security Data integrity A file or table containing all the details of the database design Data design features to ensure the validity of data in the database A model of what the database will look like, although it may not be stored in this way Methods of protecting the data including the uses of passwords and different access rights for different users of the database A school stores a large amount of data that includes student attendance, qualification and contact details. The school is setting up a relational database to store these data. The school needs to safeguard against any data loss. Describe three factors to consider when planning a backup procedure for the data. Justify your decisions. The database design has three tables to store the qualifications and grades each student has attained. The following is a sample of the data from each table. STUDENT StudentID FirstName LastName Tutor 001AT Ahmad Tan 11A 003JL Jane Li 11B 011HJ Heather Jones 10A QUALIFICATION QualCode Level Subject CS1 IGCSE Computer Science MT9 IGCSE Maths SC12 IGCSE Science STUDENT-QUALIFICATION QualCode StudentID Grade DateOfAward SC12 011HJ A 31/8/2014 SC12 003JL C 31/8/2014 CS1 003JL B 31/8/2014 Draw an Entity-Relationship (E-R) diagram to show the relationships between these three tables. State the type of relationship that exists between STUDENT and STUDENT-QUALIFICATION. Describe how the relationship between QUALIFICATION and STUDENT-QUALIFICATION is implemented. The database will store each student’s date of birth. Write an SQL script to add a date of birth attribute to the appropriate table. Write an SQL script to display the StudentID, Grade and DateOfAward for the QualCode value of SC12. Write an SQL script to display the FirstName and LastName and QualCode for all STUDENT-QUALIFICATIONs for which the Grade value is A.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open
6
Explain the difference between the World Wide Web (WWW) and the Internet. Three methods of connecting devices include fibre-optic cables, copper cables and radio waves. The table below gives descriptions relating to these connection methods. Tick (✓) one box on each row to show the method that best fits each description. Description Fibre-optic cable Copper cable Radio waves Wireless medium Twisted-pair is an example Uses light waves WiFi Fastest transmission medium Bit streaming is used for both real-time and on-demand services. Describe one difference between real-time and on-demand bit streaming. A device needs an IP address to connect to the Internet. IPv4 is the more common type of IP address. Describe, using an example, the format of an IPv4 address. A computer user keys in the Uniform Resource Locator (URL) of a web page into a web browser. Describe how the browser uses the Domain Name Service (DNS) to display the web page.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
Open