Q.1 Solution: SQLite is file based and embeddable relational database management system. As it is lite and due to its support to relational database management system it is best to use in mobile applications. So, SQLite is very appropriate to construct an embedded database system. It is light database, and it is direct file system engine that uses SQL syntax, also doesn’t require a special database server or anything.
Similarly, SQLite can easily adjust with the requirements of embedded system as it has small core, open source and database is a file which is very easy to apprehend the copy, move and cross platform sharing of database files. Now a days, SQLite use is increasing in embedded systems due to its advantages. SQLite will be more widely used in the embedded field, such as the remote control, intelligent mobile terminal, information appliances control, home medical equipment, mobile devices etc. In a multiplatform architecture SQLite having wide scope.
Q. 2 Solution:
Embedded devices or applications
Replacement for ad hoc disk files
Stand-in for an enterprise database during testing or demos
Multi-user applications
Data analysis
Application file format
Server-side database
Data transfer format
Cache for enterprise data
Internal or temporary database
Websites
File archive/ data container
Education and Training
Experimental SQL language extensions