NIROSHA MATHARAARACHCHI ,B.Sc , PGDE.(Advanced Level ICT Teacher in a Leading National School) Consider the table Student. StudentName MajorName CreditHours ParentID City CityCode Kirsten Accounting 152 P101 Colombo CMB Eve IS 138 P102 Kandy KDY Zoe IS 138 P102 Kandy KDY Ben Accounting 152 P101 Colombo CMB 1.What is this table in not normal form? (1) The table contains multivalued fields. (2) The city and city code are repeated, violating the principles of data independence. (3) The same parent ID is assigned to multiple students, which creates duplication and partial dependency. (4) The same credit hours appear for different students, making the table inconsistent. (5) The table lacks a clearly defined primary key, and non-key attributes depend on partial or transitive relationships. 2. Think a StudentID id added as SID to the table.What is the correct relational schema for the table (1)Student(SID, StudentName, MajorName, CreditHours, ParentID, City, CityCode) (2)Student(SID, StudentName) , Major(MajorName, CreditHours) , Parent(ParentID, City, CityCode) (3)Student(SID, StudentName, MajorName, CreditHours), Parent(ParentID, CityCode) (4)Student(SID, StudentName, MajorName, CreditHours) ,City(City, CityCode), Parent(ParentID, City) (5) Student(SID, StudentName, ParentID), Major(MajorName, CreditHours) ,City(CityCode, CityName) 3.What is to be done to bring the table to 2NF? (1) Remove ParentID and keep only City and CityCode in the table to simplify structure. (2) Remove all repeating values and merge City and CityCode into a single column. (3) Add composite primary key using MajorName and ParentID to maintain dependencies. (4) Keep all columns together since 1NF already ensures no redundancy. (5) Remove partial dependencies and create separate tables for student and parent. 4. What is to be done to bring the table to 3NF? (1) Remove transitive dependencies by creating a separate table for Parent, Student and City. (2) Remove transitive dependency by merging MajorName and CreditHours into one column. Paper I 33
NIROSHA MATHARAARACHCHI ,B.Sc , PGDE.(Advanced Level ICT Teacher in a Leading National School) (3) Remove transitive dependency by keeping City and CityCode together in the student table. (4) Remove transitive dependency by separating StudentName and ParentID into a new table. (5) Remove transitive dependency by placing CreditHours back in the student table to reduce joins. 5. What will be the output? 6. What will be the output? 7. What will be the output? 8. What will be the output? 9. f (x, y) = (x. y)’ (x’ + Y ) (y’+ y) The simple from of the above boolean algbra. (1) X (2) Y (3) 1 (4) x (5) 0 10. How it is called, to stop one process running in the OS to start another process (1) Demand paging (2) Context switching (3) Swapping (4) Interrupting (5) Long term scheduling (1) 123 (2) 1 2 3 (3) 1 2 3 4 (4) 0 1 2 3 4 (5) 0 1 2 (1) 5 10 6 12 7 14 (2) 3 6 (3) 5 (4) 5 10 (5) 56 (1) 10 10 (2) 5 5 (3) 5 10 (4) 10 5 (5) 15 (1) 1234 (2) 1 2 3 4 (3) ERROR (4) 5 (5) No output
NIROSHA MATHARAARACHCHI ,B.Sc , PGDE.(Advanced Level ICT Teacher in a Leading National School) 11. What is the output? x = 4 y = 2 result = x << y * 2 >> 1 print(result) ** use the followinh html/css code.

Cat

Dog

Rat

15. Which is the correct answer for bitwise 1516 AND 7310? (1) 1110 (2) 1916 (3) 000100101 (4) 118 (5) 5516 16. X – 678 Y – 1011112 Z – 3D16 Descending order of the above numbers xyz? (1) X,Y,Z (2)Y,X,Z (3) Z,X,Y (4) Z,Y,X (5) Y,Z,X 17. Which of the following statements/is/are true about communication. A. In Full – duplex data communication always transmission takes place to both direction. B. A student responds to teacher after question is asked by the teacher in a class. This is an example of half duplex communication. C. Television broadcasting is an example of half duplex communication. (1) (A) only (2) (B) only (3) (C) only (4) (A) and (B) only (5) (B) and (C) only 18. Which of the following is a possible IP address in a network with IP address 172.16.10.5 and subnet mask 255.255.248.0 (1) 172.16.10.10 (2) 172.16.10.5 (3) 172.16.8.0 (4) 172.16.10.0 (5) 172.16.10.16 19. Which of the following devices sends data packets only to receiving devices? (1) Hub (2) Switch (3) Bridge (4) Repeater (5) Modem 20. Which one is correct? (1) IPV4 address contains 128 bits (2) Default subnet mask of C class is 255.0.0.0 (3) Mac address contains 32 bits (4) 255.255.0.0 is a B class IP address (5) 256 IP address in 192.200.159.0/24 (1) 64 (2) 6 (3) 32 (45 (5) 15 12.What color will the text "Cat" ? (1) Blue (2) Red (3) Black (4) Green (5) black bold 13. What color will the text "Dog" ? (1) Blue (2) Red (3) Black (4) Green (5) Blue bold 14. What color will the text "Dog" ? (1) Blue (2) Red (3) Black (4) Green (5) Blue bold
NIROSHA MATHARAARACHCHI ,B.Sc , PGDE.(Advanced Level ICT Teacher in a Leading National School) Paper II Part A 1.a) Two departments in a hospital,Pharmacy and Radiology,have separate computer networks. When the command ipconfig is run on the department computers, the following IP configurations are obtained: Pharmacy Department Computer (P): IPv4 Address ..........................: 10.10.1.5 Subnet Mask ..........................: 255.255.255.0 Default Gateway ......................: 10.10.1.1 Draw a network diagram to show how these two departmental networks can be connected to allow communication between the Pharmacy and Radiology departments. Clearly label the IP addresses of all devices, including any router or switch required to enable communication between the two subnets. b) Assume P is sending a message to R ,Explain how the IP and MAC addresses are used and how they change (or remain the same) during the communication. 2. The text file temperature.txt contains the names of patients and their body temperature readings recorded at three different times during the day. Each line in the file is structured like this: PatientName Temp1 Temp2 Temp3 Amal 98.6 99.1 98.9 Kamal 100.2 100.5 100.0  Namal 97.9 98.1 98.0 temperature.txt report.txt Write a Python program Read data from temperature.txt,Process the data to calculate the average temperature for each patient, and Write the output to report.txt in the above format. Part B 1.a) Two separate sensors two lacations in a factory gives (high(1) or low(0)) output for high and low temperatures. status Heat level Buzzer tone LED 00 Low heat 1000 blue 01 or 10 Medium heat 2000 yellow 11 High heat 3000 red An alarm (buzzer) and an LED light are activated in three different ways according to the above conditions i)Complete truth table for two sensor inputs and buzzer tone and LED outputs. Sensor A Sensor B Tone 1000 Hz Tone 2000 Hz Tone 3000 Hz LED Blue LED Yellow LED Red ii)Draw the schematic diagram for the circuit. iii)Write the C code for the system iv)Show the circuit behavior using a flow chart. Radiology Department Computer (R): IPv4 Address .........................: 10.10.2.8 Subnet Mask .........................: 255.255.255.0 Default Gateway .....................: 10.10.2.1 Amal: Total = 296.6, Average = 98.87 Kamal: Total = 300.7, Average = 100.23 Namal: Total = 294.0, Average = 98.00