Scribd
Upload
60 views4 pages

Synopsis

This document discusses creating a database using SQLite. It first describes SQLite as a software library that implements a self-contained, zero-configuration SQL database engine. It then shows a prototype of a user bank account database created with two tables, two user reports, and sample data. Finally, it explains how to set up SQLite and create a database on a Mac system by downloading files, installing, and configuring SQLite before being able to create databases.

Uploaded by

joe wycliffe
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
60 views4 pages

Synopsis

This document discusses creating a database using SQLite. It first describes SQLite as a software library that implements a self-contained, zero-configuration SQL database engine. It then shows a prototype of a user bank account database created with two tables, two user reports, and sample data. Finally, it explains how to set up SQLite and create a database on a Mac system by downloading files, installing, and configuring SQLite before being able to create databases.

Uploaded by

joe wycliffe
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Synopsis

Assignment Grading

Course: Name

Synopsis

Yours Name

Professor’s Name [optional]

University

1
Synopsis

Synopsis

SQLite consist of a software library that assist to implement self-contained, zero

configuration, transactional SQL database engine. Its source code requires to keep with

public domain. 

SQLite Prototype (User Bank Account Database): 

I have created prototype for the same using an online tool. In the below prototype diagram, I

have created two tables, two user reports, data dictionary, two users, and added data fields

accordingly.

 Arrow used for design decisions and show how these elements are interconnected to

each other and arrows also decide the dependency of each table and record.

 Added constraint to restrict the specified fields so that maintain the data integrity and

connect the database tables.

 Chosen appropriate datatypes for each attribute.

 Fill the input data for users retrieve records

 Finally, connected each item as per their requirements in database.

Through this prototype, we can create database in SQLite database for the same where

one can add tables, data dictionary, and table attributes as well real data. Now, using

queries we can modify (add, alter, or delete) data inside the database tables and

can generate reports as per our requirements.   

2
Synopsis

Database Creation using SQLite

For creating database, we can go to SQLite download page and download recompiled files

for the system.

 I did use MAC system and it allow me to download sqlite-autoconf-*.tar.gz

 Installed all the files and added configuration to get ready with SQLite 

 Once, SQLite get ready then its ready to create database.

3
Synopsis

References

Allen, Grant; Owens, Mike (November, 2010). The Definitive Guide to SQLite (2nd ed.

ISBN 1-4302-3225-0.

Prototype Design. Retrieved from- https://creately.com/app/

You might also like