Question 3 – Protocols and Web Languages   3.1 Name…

Question 3 – Protocols and Web Languages   3.1 Name a very common protocol used for networks and internet communication. (1) 3.1.1 This protocol is platform independent. What does this mean? (2) 3.1.2 The above protocol is really a suite of protocols. Name any two protocols that are included and describe both of them briefly. (6) 3.2 What is HTML? Expanding the name will not earn any marks. (1)    

A patient was admitted two days ago with pneumonia (bacteria…

A patient was admitted two days ago with pneumonia (bacterial lung infection) and a history of angina (ischemia chest pain). The patient now reports chest pressure with a pulse rate of 108 and now requires oxygen. Which piece of data will the nurse use for “B” when using SBAR?

Outfit Description of Outfit Warm or Cool Weather Acce…

Outfit Description of Outfit Warm or Cool Weather Accessory Accessory Colour Does it go? Minnie Mouse Dress with red spots Warm Minnie Mouse Ears Black Yes Minnie Mouse Dress with red spots Warm Extra big shoes Black Yes Princess Pink Dress Cool Hat with veil Pink No Princess Pink Dress Cool Earrings Gold Yes Princess Pink Dress Cool Crown Silver Yes Harry Potter Harry Potter Gown Warm Wand Black Yes Harry Potter Harry Potter Gown Warm Fake Nose with wart Green No Harry Potter Harry Potter Gown Warm Extra big shoes Black No Harry Potter Harry Potter Gown Warm Glasses Black Yes Witch Black Dress Warm Glasses Black Yes Witch Black Dress Warm Wand Black Yes Witch Black Dress Warm Extra big shoes Black Yes Witch Black Dress Warm Fake Nose with wart Green Yes Witch Black Dress Warm Earrings Black Yes Fairy Pink Tutu Cool Wand Black Yes Fairy Pink Tutu Cool Wings Pink Yes Fairy Pink Tutu Cool Crown Silver No

Based on the table above, answer the following questions…

Based on the table above, answer the following questions 1.1 The table has been flattened i.e. repeating groups have been removed. Which attribute are we talking about? (1) 1.2 What is still needed to bring the table to 1NF? (1) 1.3 Normalise the table to First Normal Form. Display as a relation. (3) 1.4 Explain why Minnie Mouse is regarded as data redundancy and the colour black is regarded as duplicate data. (2) 1.5 Give an example of a deletion anomaly using the table. (2) 1.6 Define Second Normal Form. (2) 1.7 Draw a data dependency table showing all dependencies. (6) 1.8 Define Third Normal Form. (2) 1.9 Explain why your new tables are already in Third Normal Form. (3)