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.
- Design the database to store the notes
- Design the UI of the client
- 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
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
Get step-by-step solutions from verified subject matter experts
