You will draft a client-server system for writing/storing notes. Each note has an ID (integer), a title (short text), and a body (long text). A client can has three kinds of requests to the server: upload a note, download a note (given its ID), and search for a note (given a keyword). In case of search, the server will return a list of IDs and titles of notes whose titles contain the keyword.

1. Design the database to store the notes
2. Design the UI of the client
3. Write code to implement the system. You should use design patterns as in the Store Management System: 3-layer; Model-View-Controller; Singleton, Adapter...

Submission:

You should submit the SQLite database file along with code of your system.

Answer rating: 100% (QA)

Database Design For storing notes a simple SQLite database can be used SQLite is a selfcontained serverless zeroconfiguration transactional SQL databa... View the full answer