Unit 1: Database Concepts - RDBMS Tool

The key to organizational success is effective decision making which requires timely, relevant and accurate information. Hence information plays a critical role in today's competitive environment. Database Management Software (DBMS) simplifies the task of managing the data and extracting useful information out of it. In this chapter, we shall learn about the basic concepts of databases and also learn how to use DBMS for some applications. 

Unit 2: Operating Web Based Applications

An application that can be accessed via a web browser, over a network connection is called a web-based application. A web-based application provides the convenience of availability 24x7 across the world. Nowadays, web-based applications are used for reservation of tickets and bookings, e-governance, online shopping with the provision of making payments online using credit/debit cards, and learning using online tutorials, tests etc. They allow access to the facilities via the Internet from the comfort of home, office, car, etc.

The web-based online applications can be broadly categorized into applications that require financial online transactions and applications that provide information and allow interaction via filling forms, posting query, viewing information, sending email or chatting. The online reservation system, online shopping, and bill payments fall in the first category and e-governance and online tutorial and tests fall in the second category. In this chapter, we discuss both kinds of applications.

Unit 3: Fundamentals of Java programming

Introduction to Java, Object Oriented Programming, Java Language Elements, Operators, Control Flow, Array, Class Design, Exception Handling, Assertions, Threads, Wrapper Classes, String Manipulation.

Unit 4: Work Integrated Learning IT - DMA

Previous chapters provided you an insight into how database management concepts are helpful for organizing the data in meaningful ways. They facilitate fast retrieval of information as and when required. You learnt data manipulation language SQL for creating, selecting and modifying the data in database. You also learnt regarding various web applications that use databases for managing the data.

In this chapter, you will learn about various work areas that use database management systems. Also, we shall develop a shopping application using database management systems and java. During the course of discussion, we have raised some questions and encourage you to think about their solution and explore related issues.

Part C: Practical Work

  • Practical Examination
  • Written Test
  • Viva Voce

Part D: Project Work / Field Visit

  • Practical File / Student Portfolio
  • Viva Voce