Synopsis
SQLite consists of a
software library (Languedoc, 2016), which can be used to implement a
transactional and self-contained SQL database engine which has no
configuration. The source code is required in order to keep it up with the
public domain.
SQLite Prototype (User Bank
Account Database)
I have designed or created a
prototype using the same tool. In the diagram given below, you can see that I
have created different tables, a data dictionary, use reports along with users,
and have filled data fields appropriately.
1.
Arrows have been used to highlight the designing
decisions and to show how certain elements are corrected to each other.
2.
I have added constraint carefully in order to restrict
specific fields, maintain the integrity of data and connecting the database
tables.
3.
I have selected appropriate data types for every single
attribute.
4.
I chose to fill the data input section for all users in
order to retrieve records efficiently.
5.
In the final stage, I connected every item according to
the requirement of the database.
With this type of prototype,
it is easy to create a database in SQLite (Languedoc, 2016), and adding tables,
dictionary, real data and table attributes takes a matter of minutes depending
on how skilled a person is. It is now easy for us to modify (alter, delete or
add) data using queries. This can be modified inside every table, and we can
generate as many reports as are required.
The Creation of Database
using SQLite
In order to create a
database, a person first needs to download SQLite from the official page along
with recompiled files for the system (Taylor, 2019).
1.
I used a MAC system that allowed me to download
sqlite-autoconf-*.tar.gz.
2.
Then I installed all of the required files and added
configuration in order to get ready with SQLite.
3.
When SQLite was ready, I begin creating database
according to my desires or requirements.
References
Languedoc, K. (2016).
Analyzing SQLite Databases. Build IOS Database Apps with Swift and
SQLite, 187-196. doi:10.1007/978-1-4842-2232-4_12
Introducing SQLite.
(n.d.). The Definitive Guide to SQLite, 1-16.
doi:10.1007/978-1-4302-0172-4_1
Taylor, A. (2019). Entering,
Modifying, and Deleting Table Data. Creating a Database with SQLite.
doi:10.1007/978-1-4842-3899-8_3
Languedoc, K. (2016). Working
with Multiple Databases. Build IOS Database Apps with Swift and SQLite, 161-173.
doi:10.1007/978-1-4842-2232-4_10
Languedoc, K. (2016). Build
iOS Database Apps with Swift and SQLite. doi:10.1007/978-1-4842-2232-4
