INFORMATION
TECHNOLOGY - 802
CLASS – XII
SESSION – 2020-21
(DRAFT STUDY MATERIAL)
Preface
In an increasingly globalized world and the changing
paradigm of urbanized living the demand for Information Technology (IT) has
been increased manifold throughout the world. In this ever expanding sector, it has become essential to
provide competency based Vocational Education. It is in this context that CBSE
has launched a course in Information Technology under NSQF from level 1 to 4.
The Student Handbook on "Database Management
Applications" is a part of qualification package developed for the
implementation of National Skill Qualification Framework (NSQF), an initiative
of Government of India to set common principles and guidelines for a nationally
recognized qualification system covering the schools, vocational education and training
institutions, technical education institutions, college and universities. It is
envisaged that the NSQF will promote transparency of qualifications,
cross-sectoral learning, student qualifications, thus encouraging life-long
learning.
It has been a deliberate effort to keep the language
used in this Student Handbook as simple as possible for the benefit of the
students. Necessary pictorial illustrations and tables have been included to
help the students to understand the concepts without any difficulty.
Practicing professionals from the field of Information
Technology (IT) comprised the team of authors for this book. I hope this book will help the
students to serve as useful resource in this subject. This Student Handbook
attempts to bring about necessary flexibility in offering of courses, necessary
for breaking the sharp boundaries between different subject areas. The Handbook
attempt to enhance these endeavor by giving higher priority and space to
opportunities for contemplation and wondering, discussion in small groups and
activities requiring hands-on experience.
The Board is grateful to the members of the Committee of
Course for their advice, guidance and total commitment towards development of
this course. We are indeed indebted to these academic advisors who have lent us
the benefit of their rich and insightful experience. I would like to appreciate
Vocational Education Cell, CBSE for coordinating and successfully completing
the work.
Any suggestions, feedback from the readers for
improvement in the future editions of the volume
shall be heartily welcomed.
Information Technology(802) Book Click Here
Employability Skills Book Click Here
Employability Skills Study Material Click Here
Content
Unit - 1: Database Concepts 1-47
Unit
- 1: Database Concepts 1-47
1.1 Introduction 1
1.2 Basic Concepts and Definitions 1
1.3 Need for a Database 2
1.4 Database Management System (DBMS) 2
1.4.1 Characteristics of Database Management Systems 3
1.4.2 Types of users of DBMS
41.4.3 Advantages of using DBMS Approach 4
1.4.4 Limitations of using DBMS Approach 4
1.5 Relational Database 5
1.5.1 Relational Model Constraints 7
1.6 Structured Query Language (SQL) 9
Unit
- 2: Operating Web 48-80
2.1 Operating Web-based Applications 48
2.2 Online Reservation Systems 48
2.2.1 Advantages of Online Reservation System 48
2.2.2 Precautions while Performing Online Transactions 50
2.2.3 Using Online Reservation Systems
512.2.4 Case Study: Book Rail Ticket 51
2.3 E-Governance 56
2.3.1 Initiative 56
2.3.2 E-Governance Sites 56
2.4 Online Shopping and Bill Payments 59
2.4.1 Benefits of Online Shopping 59
2.4.2 How it works 60
2.4.3 Bill Payments 61
2.4.4 Case Study: Online Shopping using Online Shopping Website 61
2.5 Online Courses, Tutorials and Tests 65
2.5.1 Online Educational Sites 65
2.6 Project Management - Web Based Application Development 69
2.6.1 Project Essentials and Tips 69
2.6.2 Case Study - Online Game 71
2.6.3 Case Study - Online Quiz 73
2.6.4 Case Study - Online Bill Calculator 76
Unit
- 3: Fundamentals of Java Programming 81-143
3.1 Introduction to Java 81
3.2 Data Types and Variables 89
3.2.1 Variables 89
3.2.2 Primitive Data Types 93
3.2.3 String Variables 94
3.3 Operators 94
3.4 Control Flow 96
3.4.1 Selection Structures
97
3.4.2 The if Else Statement 97
3.4.3 The Switch Statement 100
3.4.4 Repetition Structures 101
3.4.5 The While Statement 102
3.4.6 The Do While Statement 103
3.4.7 The for Statement 106
3.5 Arrays 108
3.6 User Defined Methods 111
3.7 Object Oriented Programming 113
3.8 Class Design 114
3.8.1 Constructors 115
3.8.2 Access Modifiers 118
3.8.3 Getter and Setter Methods 119
3.9 Java Libraries 120
3.9.1 Data Input 121
3.9.2 Array Manipulation 122
3.9.3 String Manipulation 124
3.10 Exception Handling 127
3.11 Database Connectivity 129
3.11.1 Connecting to the MySQL Server in NetBeans 129
3.11.2 Adding the MySQL Connector JAR to the NetBeans Libraries 133
3.11.3 Database Connection from Java 134
3.12 Assertions, Threads, and Wrapper Classes 136
3.12.1 Assertions 136
3.12.2 Threads 138
3.12.3 Wrapper Classes 141
Unit
- 4: Work Integrated Learning IT - DMA 144-157
4.1 Introduction 144
4.2 Identification of Potential Work Areas 144
4.3 A Shopping Website - A Case Study 146
4.3.1 Entities Involved 147
4.3.2 Functionality 150
Appendix
- A 158-164
Installing and Staring NetBeans IDE 158
0 Comments
Post a Comment