Question: 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

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Database Design To store the notes Ill design a simple database schema using SQLite The database will have three tables 1 notes table id integer primary key unique ID for each note title text short te... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!