Most of the applications that we use in our day-to-day life have to deal with some type of stored data that can be used as and when required. Databases enable us to store this data in a structured manner and also provide us with some guidelines on how this data is to be presented to the end users. In short, databases are an organized body of related information that is usually intro records with a common denominator. The software that controls the access to the databases and enables you to create, edit, and maintain them is known as Database Management Systems (DBMS). There are numerous DBMS systems that are available in the market and each of them is used to suit some specific needs.

The DBMS that we use in this chapter to provide examples is SQLite. As the name specifies, SQLite is a light-weight, public-domain, in-process database system that is used for local storage in many application software applications. This chapter assumes that the users are familiar...