Secretly Ict Notes

In: Other Topics

Submitted By Lordgrumble
Words 806
Pages 4
Tables contain data about things eg students,orders,events.
Requirements must be met for the data structure to be called a table
The table must have a unique name, each field/column must have unique name, each record/row must be unique, each data item within a field must contain only a single data item

A record is a single row within a table. It is a collection of data about a single item or single event.
A field is an individual data item within a record. Each field within a record should have unique name

Primary key
A primary key can be of two types which are simple and compound or composite keys
A single primary key is one which is made up of a single field only. A compound primary key is one which combines more than one field to make a unique value.
Secondary key
A secondary key is a field that is identified as being suitable for indexing the data. It is used to sort data in a different order to the primary key
Foreign key
A foreign key is used to link tables together. A foreign key is a field in one table that is linked to a primary key in another table. The data types of the fields that are linked must be the same

Relationships between entities
Entities have been defined as ‘a thing that can be distinctly identified’. The idea of an entity is central to understanding entity relationship models.
There are three types of relationship that can be identified as existing between entities, these are , one to many, one to one, many to many.
One to one is that it is associated with only one instance of entity. One to many is the most common type of relationship between entities a single instance of an entity can be associated with many instances of another entity
Many to many, many instances of an entity can be associated with many instances of an entity

Tables and fields
A database table is made up…...

Similar Documents

Ict Benifits

...Make reasoned recommendation about how particular organisation can take advantage of IT development. As an ICT manager working for full of beans, I have made it clear that the development of ICT is increasing, therefore giving organisations no choice but to adapt to the changes. It’s my duty to explain to the owners and employees of full of beans how the ICT development can have a positive impact on the organisation. For example, fast processing which is essential for banks and vast storage capacity which reduces the amount of paper work. Hardware and software are both being used by organisation to help them accomplish certain tasks e.g. using (MIS) management information system. Hardware and software increased in power, capacity and sophistication, therefore allowing organisation to expand and work more efficiently. I strongly recommend that full of beans make use of this opportunity to adapt to the ICT developments. One great example of a new development full of beans can take advantage of is the recent wireless technology, many organisations responded to this change by adapting to the change. In order for full of beans to take full advantage of the ICT development, obviously the manager first needs a presentation on the capabilities of these development and how it will benefit their organisation. There are many new developments that organisation took advantage of, I will explain some of these development in more detail below. Wireless technology This is a great......

Words: 1111 - Pages: 5

What Is Ict?

...Information and Communication Technologies for Development (ICT4D) refers to the use of Information and Communication Technologies (ICTs) in the fields of socioeconomic development, international development and human rights. The theory behind this is that more and better information and communication furthers the development of a society. Aside from its reliance on technology, ICT4D also requires an understanding of community development, poverty, agriculture, healthcare, and basic education. Richard Heeks suggests that the the I in ICT4D is related with “library and information sciences”, the C is associated with “communication studies", the T is linked with “information systems", and the D for “development studies”.[1] It is aimed at bridging the digital divide and aid economic development by fostering equitable access to modern communications technologies. It is a powerful tool for economic and social development.[2] Other terms can also be used for "ICT4D" or "ICT4Dev" ("ICT for development") like ICTD ("ICT and development", which is used in a broader sense[3]) and development informatics. ICT4D can mean as dealing with disadvantaged populations anywhere in the world, but it is more seen with applications in developing countries. It concerns with directly applying information technology approaches to poverty reduction. ICTs can be applied directly, wherein its use directly benefits the disadvantaged population, or indirectly, wherein it can assist aid organisations or...

Words: 563 - Pages: 3

Ict in Malaysia

...ICT IN MALAYSIA: POLICY, REGULATION & INDUSTRY PROGRESS (1996-2000) AND PROSPECTS (2001-2005) Presented by Gazali Abas at ITU-Waseda University Workshop for Regulators and Policy-Makers “New Trends in ICT” 13th-24th November, 2001 Waseda University Tokyo, JAPAN CONTENTS 1. 2. 3. 4. 5. INTRODUCTION PROGRESS (1996-2000) PROSPECTS (2001-2005) ALLOCATION CONCLUSION 14 Nov.2001.Gazali A. 2 1. INTRODUCTION THE BIG PICTURE - Human Capital 23 m - Vision 2020 - Long-term Outline Perspective Plan - Five-year Development Plan - K-Economy - ICT policy, regulation and industry 14 Nov.2001.Gazali A. 3 2. PROGRESS, 1996-2000 1. 2. 3. 4. 5. 6. 7. 8. Utilization of ICT National IT Agenda Development of the Multimedia Super Corridor MSC Flagship Applications Development of Communications Infrastructure Electronic Commerce Human Resource Development for ICT Funding for ICT Industry 14 Nov.2001.Gazali A. 4 2.1.1 - UTILIZATION OF ICT: ICT Expenditure by Sector, 1995-2000 Total expenditure on ICT increased 9.2% p.a. in 1996-2000. Big spenders on ICT: 1995 2000 AAGR Banking & Finance 27% 15% -4% Manufacturing 13% 16% 19% Distributions 8% 10% 16% Government 10% 8% 7% Home 2% 8% 44% 14 Nov.2001.Gazali A. 5 2.1.2 - SELECTED ICT INDICATORS, 1995-2000 Indicator PC (units installed) PC per 1,000 pop. Tel.lines/1,000 pop. Tel.Subscribers Mobile Phones Internet Subscribers 14 Nov.2001.Gazali A. 1995 610,000 29.5 161.7 3,332,447 700,000 13,064 2000 2,200...

Words: 2334 - Pages: 10

Ict Officer

...Mary Freeman 4542 Short Street Austin, TX 78701 (222)-980-7257 January 18th, 2014 Ms. Winnifred Burkholder Kimball Electronics Group 2453 Ashton Lane Austin, TX 78744 Dear Ms. Burkholder, I am applying for the ICT Technician job position with Kimball Electronics Group and my credentials match the requirements in your posting. I have an Associate Degree in Bachelor of Science and over three years of experience working as an ICT Tech where I gained valuable hands-on experience in this field. My duties included setting up the network and servers for the company and testing the systems to make sure everything was functioning correctly. It also included conducting test, running diagnostics and troubleshooting problems to find solutions. I also have experience reading schematics and blueprints, implementing patches and making repairs when necessary. I am familiar with a variety of operating systems such as Windows XP, Vista, Windows 7 and Windows 8 and I am familiar with Microsoft Office along with a variety of other programs. I am team-orientated, dependable, highly focused and I have strong decision-making skills. I also possess excellent communication skills with the ability to explain technical issues in a clear and concise way. I manage my time wisely, so I have the ability to keep several projects going at once but I always maintain a pleasant, easygoing attitude even......

Words: 305 - Pages: 2

Ict Notes

...see any errors/ Debug Examples: COBOL C++ Pascal * Note: Objects not Procedures Note: Objects not Procedures Object Oriented Programming: -Broken Down Into objects -Developed in response to difficulties using procedural approach. Examples: JAVA * Visual Programming -Event Driven (Mouse Click……) -Designed to work In windows environment -Features of Windows eg. Menus, Dropdown list….. -GUI Examples:, C# Java * Mark Up Language -Do not contain instructions to control the flow of the program. Note: HTML is not a true Language Note: HTML is not a true Language -Contain instructions to control the format and layout. Examples: HTML * Scripting Example: Java Script * Note: Software is needed to control Hardware Note: Software is needed to control Hardware Software * Software is a general term for programs. * Hardware refers to the physical components. * Two Categories Of Software: * Note: System Software must be in place before Application Software can be used Note: System Software must be in place before Application Software can be used System Software controls computer system * Application Software carry......

Words: 1449 - Pages: 6

Ict Note

...4/7/2012 Learning Objectives Chapter FOUR S y s t e m U n i t Reference: Shelly Cashman, Discovering Computers 2011, Living In Digital World, International Thompson Publishing, •Identify and describes components of system unit. •Describes the function of ALU and control unit. •Describes the machine cycle. •Describes types of RAM, Ports, Connectors of computer system. The System Unit The System Unit What is System Unit? Processor chips The hardware unit that houses a computer’s processor, memory chips, ports, and add-in boards Microprocessor- the smallest type of processor, with all of the processing capabilities of the Control Unit and ALU located on a single chip Processor chips Memory chips Ports Add-in boards The System Unit The System Unit Ports Memory chips SIMM (Single in-line memory module) – A multiple-chip memory card inserted as a unit into a Pre-designed slot on a computer’s system board. A connector through which peripheral devices can be plugged into the computer 1 4/7/2012 The System Unit Inside the System Unit Add-in boards A board that can be added to a computer to customize its features and capabilities. The Motherboard Type of Chips Single Edge Contact (SEC) – connects to the motherboard on one of its edges. Dual Inline Package (DIP) – consists of two parallel rows of downward pointing thin metal feet (pins). Type of Chips The Machine Cycle Memory Fetch I-Cycle......

Words: 1980 - Pages: 8

Ict Notes

...Important notes: * ICT helps today's busy families stay connected with each other.  * However, ICT can also keep families apart. Imagine today's family gathered in the kitchen for dinner. Maybe the TV is on, a laptop on the kitchen counter and everyone has their phone with them. Mom and dad are keeping an eye on emails even though the work day is technically over. So this family is physically together, but they are not totally focused on and paying attention to each other. They are at least partially attentive to a ping or a beep indicating that there is a new text message, email or missed call. * So how can we use ICT to our advantage - for increased productivity, reduced stress, and better work+life fit? We'll need our organizations to pitch in by providing guidelines about expectations and strategies for effectively managing our devices. And we will need to confer with our managers and colleagues to figure out how our work groups can use ICT to promote collaboration and working smarter.  *  technology is the best way of learning because it's a convenient way to search a lot of academic information and technology makes me know my goals * A major change has occurred in personal communication and society due to the influence of the information technology. Whereas in the past, information technology was not used every day, but in recent times, it has become the most powerful things to in many people lies. * Technology is so much apart of our lives that...

Words: 1089 - Pages: 5

Ict and Employment

...Connecting to Work: How ICTs Are Expanding Job Opportunities Worldwide September 10, 2013 * * ------------------------------------------------- Top of Form Bottom of Form * * * Information and communication technologies are creating new job opportunities for workers and employers around the world. STORY HIGHLIGHTS * Information and communication technologies (ICTs) are transforming the world of work, creating new job opportunities and making labor markets more innovative, inclusive, and global. * Three trends are driving this shift: greater connectivity, the ability to telecommute and outsource work, and globalization of skills. * A new paper looks at ways policymakers can maximize the positive impact of ICTs on employment. RELATED WORLD BANK * Policy Note: Connecting to Work: How Information and Communication Technologies Could Help Expand Employment Opportunities * Website: World Bank ICT * Website: Jobs Knowledge Platform MULTIMEDIA Video Connecting to Work: ICTs & Jobs When Gopal Maharjan, a young engineering graduate in Nepal, started looking for a job in Kathmandu he did not get a great response. Then he heard about online jobs with CloudFactory, a “microwork” platform. He and some friends formed a group and applied online. They were accepted and given part-time jobs doing work such as digitizing old, hand-written data, tracking supermarket receipts, or even medical transcription. The group meets regularly with CloudFactory......

Words: 974 - Pages: 4

Ict Terms

...* Revision:Complete Revision Guide to CCEA ICT Contents [hide] * 1 Complete ICT Revision Guide (CCEA) * 2 Knowledge of ICT Components * 3 INPUT DEVICES * 4 OUTPUT DEVICES * 5 STORAGE DEVICES * 6 INFORMATION AND DATA * 7 DATA STRUCTURE * 8 DATA CHECKING * 9 DATA PORTABILITY * 10 DATA NETWORKS * 11 INTERNET, INTRANET AND WWW * 12 TRANSMISSION, BACKUP, TELECONFERENCING * 13 APPLICATIONS * 14 SOFTWARE PACKAGES * 15 VIRTUAL REALITY IN TRAINING, ENTERTAINMENT * 16 COMPUTERS IN CONTROL (REAL TIME) * 17 ON-LINE SERVICES * 18 SECURITY AND PRIVACY OF DATA * 19 HEALTH AND SOCIAL ISSUES * 20 EMPLOYMENT * 21 ICT IN MUSIC, LEISURE, ENTERTAINMENT | ------------------------------------------------- Knowledge of ICT Components 1. DIGITAL : • Discrete values or binary digit 2. PROCESSOR: • Control center of the computer 3. RAM:- • Volatile (temporary storage), working storage, holds programmes currently in use, • Used for writing to and reading. • Measured in gigabytes 4. ROM:- • Instructions computer needs to start, • Non-volatile (permanent storage), can’t be changed, only read • Stores the Boot up/Start up program for the PC START UP STEPS:- • Power up • Read ROM chip • Connect all in and output devices • Load DOS from hard drive. • Load windows from hard drive 5. CACHE:- • Temporary storage, • Stores most frequently used instructions, • Is RAM memory that the computer microprocessor can access more quickly. • Volatile (128kb-512kb). 6....

Words: 6710 - Pages: 27

Uses of Ict in Nigeria

...Technology (IT), with the aim of making Nigeria an IT adapted country in Africa and also a leading player in the use of ICT as an implement for sustainable development and global competitiveness. Since then Information and Communication Technology has been on the lips of every academic. The world is about to leave behind anyone that is not ICT compliant. ICT has various forms and roles which it performs in learning, especially in the teaching and learning of language. It is a powerful tool which can take the form of texts, pictures, tables, graphs, emails, fax, chat groups, discussion groups, SMSs, socializing portals, dictionaries, e-encyclopaedia, Power Point presentations, websites and audio-videos, etc. It can play instructional roles which include making learners feel more relaxed to learn various topics and tasks and making them active as learning is technologically based. The problem which we have identified in the use of ICT in tertiary education is lack of infrastructure and trained manpower (personnel) to use the ICT tools in teaching and learning. Most lecturers, technologists and students who are supposed to use the ICT tools are ignorant of what they are and their uses. Previous researches on ICT have focused on the hardware, software, professional development and support services. The purpose of this study is to identify the available ICT infrastructural facilities and to discuss how they can be put to effective use in the teaching and learning of language...

Words: 4988 - Pages: 20


...Communication has been defined as "the transmission of information and meaning from one individual or groupnto another". The definition of Information and Communications Technology(ICTs) is said to be a diverse set of electronic systemsand resources used to communicate, create, disseminate, store and manage the internet. The main purpose of communication technology is to facilitate effective communication between individuals or groups that are physically distant from each other. Specific defined technologies can be broadcasting devices like the radio, the television or the telephone. ICTs are often spoken of in a particular context daily such as ICTs in bussiness/commerce, government,health, logistics, medicine and science. However, ICTs in health will be the main focus in this discussion as I elaborate on the impact of information and communications technology. ICTs plays an important role in our modern day life. There is a growing consensus that the impact of information and communications technologies on health systems could be substantial or even revoluntary through the precise nature of the impact is much more difficult to predict, it seems that the health sector will benefit from advances in mobile telephony and Internet services. Some examples can be that patients and informal providers may routinely seek advice from doctors supporting any subscriber service implemented. Today, there are health information sysems for HIV and......

Words: 559 - Pages: 3

Ict in Health and Social Care

...Good Evening every one, The topic I am about to discuss this evening its regarding to the use of ICT and how impact on Health and Social Care Field. How do we support work in Health and Social Care by accessing and using ICT software package? Information and communications technology (ICT) refers to all the sources that send or receive massages/information such as: -television -cellular phones - computer and network hardware -software - satellite systems and services and applications associated with them, such as videoconferencing and distance learning. ICT’s are often spoke of in a particular context, such as ICTs in -education -health care - or libraries There are a numbers of ICT softwares but only the standards one applies on HSC such as: -Word-Processing -Database -Spread sheets -Information Retrieval (IR) -Internet -Intranet - Email -Image software Standard Office Software Microsoft Office includes: -Microsoft Word : files/reports/documents - Microsoft Excel : Spread sheets /Database – Analyse health and social care data, calculations, create health and social care timetable for scheduling, service users information - OneNote : is a freeware note taking program. It gathers notes (handwritten or typed), drawings, screen clippings and audio commentaries. Notes can be shared with other OneNote users over the Internet or a network. - PowerPoint : create slideshows, composed of text, graphics and other objects, which......

Words: 1029 - Pages: 5

Ict in Education

...APPLICATION OF ICT IN EDUCATION We are living in a constantly evolving digital world. ICT has an impact on nearly every aspect of our lives - from working to socialising, learning to playing. The digital age has transformed the way young people communicate, network, seek help, access information and learn. We must recognise that young people are now an online population and access is through a variety of means such as computers, TV and mobile phones.  The developments in the use of the electronic media have influenced all walks of life. Education is no exception to this. The use of computers and the internet for enhancing the quality of education by making learning more relevant to life has been seen as an ideal by educational institutions. The citizens of tomorrow who are our students now are going to live in the age of the electronic media. How are we preparing them for the same? Are we giving them technology based Education? Are we giving them exposure to the use of computers and the itnernet? Have we integrated the ICT into classroom processes? What are the efforts made by the department in this direction? What does policy say about ICT in Education? There are several such questions which we need to probe into. An understanding of these issues will enable us to use the ICT more meaningfully in Education. Information and Communication Technologies have recently gained groundswell of interest. It is a significant research area for many scholars around the globe...

Words: 5037 - Pages: 21

Role of Ict

...IADIS International Conference on International Higher Education 2010 THE ROLE OF ICT IN TEACHING FOR ENHANCING QUALITY EDUCATION IN HIGHER EDUCATION: A CASE STUDY OF INDIA M.L. Ranga1, Dinesh K. Gupta2 and Roshan Lal3 1 2 Vice Chancellor; Corresponding Author’s; Guru Jambeshwar University of Science & Technology, Hisar-125001, India Associate Professor, Department of Library & Information Science, Kurukshetra University, Kurukshetra-136119, India 3 Professor of Business Management, M.M. University, Mullana (Ambala)-133203, India ABSTRACT The objective of this paper is to examine the role of ICT (Information Communication Technology) in enhancing the quality of teaching at higher education level. Although the concept of higher education has been progressing well in India and ICT is being used in all spheres of education, this article aspires to study the current status of ICT implementation and its role in improving the quality of higher education. KEYWORDS Quality Education, Information Communication Technology, Digital Communication, Higher Education. 1. INTRODUCTION India keenly aspires for international recognition as a “knowledge superpower,” and globe trotting Indian executives and policymakers are always eager to tout the country’s much-vaunted IT companies, and a fastgrowing pharmaceutical industry, not to mention its pools of engineering, legal, and research talent. The scenario considered most promising in the future envisages the country to become......

Words: 2303 - Pages: 10

Ict and Health System

...Acronyms used AIDS Acquired Immune Deficiency Syndrome ART Antiretroviral Therapy ARVs Antiretrovirals BBC British Broadcasting Corporation BCC Behaviour Change Communication CFSC Communication for Social Change CSO Civil Society Organisation DFID Department for International Development FAO UN Food and Agricultural Organisation FBOs Faith Based Organisations FHI Family Health International GFATM Global Fund for AIDS, TB and Malaria HDR Human Development Report HIV Human Immunodeficiency Virus ICTs Information and communication technologies IEC Information, Education and Communication MAP Multi-country AIDS Programme MDGs Millennium Development Goals NGO Non-governmental Organisation PLWHA People living with HIV and AIDS PMTCT Prevention of Mother to Child Transmission STI Sexually Transmitted Infection TAC Treatment Action Campaign UNAIDS Joint UN Programme on HIV and AIDS UNESCO UN Educational Scientific and Cultural Organisation USAID United States Agency for International Development VCT Voluntary Counselling and Testing WHO World Health Organization WTO World Trade Organization INTRODUCTION 1.1 Background In developing countries, preventable diseases and premature deaths still inflict a high toll. Inequity of access to basic health services affects distinct regions, communities, and social groups. Under-financing of the health sector in most countries has led......

Words: 12992 - Pages: 52