Explain the meaning of the following terms as used in MS Access: i. Referential Integrity ii. Cascade delete
i. Referential Integrity- Referential integrity is a relational database concept, which states that table relationships must always be consistent. In other words, any foreign key field must agree with the primary key that is referenced by the foreign key. ii. Cascade delete- If the table where you are deleting records has a relationship with another table and the Cascade Delete Related Records option for that relationship is set, records in the second table will also be deleted.
a) Why is “HTML” said not to be a true programming language? (1 mark) b) A student was to create a webpage containing a photograph of his friend (whose file name was: picha.jpg). He intended to link the webpage to a website whose address is www://jokers.com when the image is clicked. The text “Image to be uploaded” was to be displayed as alternative to the image, in case the image would not be displayed. The background of the web page was to be red in color. The image was to be aligned to the center. Write the HTML code that would implement the above on a webpage. (5 marks)
a) “HTML” is said not to be a true programming language because it does not have syntax and structures like other programming languages; it only consist of tag and attributes- which only format how content should be displayed on web page; interactivity on a web page has to be done by scripting technologies. // 1 Mrk b) <BODY Bgcolor=”red” > // 1 Mrk <A Href=” www://jokers.com”> <IMG Src= “picha.jpg” Alt= “Image to be uploaded” Align= “Centre”> </A> // Award @ aspect 1 Mrk= 4 Mrks
Write down the output of each of the following sections of code: int a=15, b=2;c; c=a%b; c+=2; printf(“%d”, c);
The output is 3 Explanation: 1. int a=15, b=2;c; // Three variables a,b and c are declared to hold an integer each. variable a is initialized with the value 15 while variable b is initialized with the value 2 2. c=a%b; // The operator % means remainder after division( modulo division) hence a%b implies 15%2------> 1. Therefore by this statement, the variable c is assigned the value 1 3. c+=2; // += is an assignment operator used for assigning a value to a variable. The statement: c+=2 , implies that the new value of c is incremented by 2, hence c=3 4. printf(“%d”, c); // This is an output statement that displays the value of c on the screen. %d is a format specifier for an integer