•
The database will be Microsoft SQL Server (MS SQL), MySQL or PostgreSQL.
Communication between client and server is done via HTTP requests/responses using JSON data
format.
Zoom
Part 1: Data analysis and design (5 points)
1. LIST the main entities and their key attributes based on the problem description. (1 point)
2. DRAW the conceptual ERD for the system. (1 point)
3. DRAW the logical ERD (with primary/foreign keys and basic data types) using (1.5 points)
4. LIST the main states of the Order entity during the order process and DRAW the state diagram for
Dish. (1.5 points)
Part 2: REST API function design (3 points)
1. DESCRIBE the classes/tables used on the client side, server side (Controller, Service, Repository),
and database for the "place order" function. (1 points)
2. DRAW a sequence diagram for the "place order" function between client and server (REST API)
including authentication and authorization. (2 points)
Part 3: Design pattern identification and analysis (2 points) -
Given the following pseudocode:
interface Dish (
String getDescription();
double getCost ();
+ 100%
Close
