ALL CLASS COMPUTER SCIENCE AND DATA PROCESSING NOTES

  INFORMATION PROCESSING AND TRANSMISSION 1

An index is a data structure, a special data structure designed to improve the speed of data retrieval. An index on a file speeds up selections on the search key fields for the index.   CLUSTERED INDEX Clustered index is a type of index which sorts the data rows in the table on their key values. Clustered index exists as sorted row on disk. Clustered index re-orders the table record. Clustered index contains record in the leaf level of the B-tree. NON-CLUSTERED INDEX A Non-clustered index stores the data at one location and indices at another location. The index contains pointers to the location of that data. Non-clustered index is like the index in the back of a chemistry text book. The chemistry text book has some natural order to it: Chapter 1: Matter Chapter 2: Elements Chapter 3: Compounds DENSE INDEX In a dense index, a record is created for every search key valued in the database. This helps you to search faster but needs more space to store index records. In t

UNDERSTANDING CHILD PROTECTION

  1- _________ refers to the rules and regulations governing the conduct of an indivual with others. Profession  Profession Computer behaviour  Computer ethics  Ethics   2- _________ is the standard of conduct as it relates to computers.  Computer ethics  Ethics  Computer users Computer professionals  3- _________ is a place where the teaching and learning of computer studies takes place.   Computer laboratory  Computer shop  Computer factory  Computer house   4- These are some of the components of an ideal computer laboratory except_____________.   White marker board  printers  chairs and computer systems  Washing machines  5- A computer room contains the following except_____________.   Monitor  printer  sewing machine  UPS   ANSWERS 1-D 2-A 3-A 4-D 5-C

  Ethics means that the rules and standards that guide the conduct of an individual with others. As technology and computers are increasingly becoming part of our everyday lives, we must understand how to avoid problems that come with them.    Computer ethics can be defined as the standard, rules and conduct that students must obey in using the computer.    The computer laboratory, also called computer room is a room where the teaching and learning of computer studies takes place. It is a room where the needed equipment for teaching and learning computer studies or doing scientific work on computer applications are kept.    An ideal computer laboratory must have the following features:  it must be a well-illuminated room that can comfortably accommodate twenty-five computers.  it must be furnished with chairs and computer tables.  it must contain complete computers sets(desktops, laptops with keyboards, speakers, microphone, mouse, etc. There must be a central main power supply