In this lab you will develop a Product Review Application.
-
Make domain models for
Category
withid
andname
.- A
Category
can have manyProducts
.
- A
Product
withid, name, price
andrating
.- A
Product
can belong to only oneCategory
.
- A
User
withid, email, password, firstName, lastname
.User
can create manyReviews
.User
can have only oneAddress
.
Address
withid, street, zip
andcity
.- An
Address
can belong to only oneUser
.
- An
Review
withid, comment
.- A
Review
can only belong to oneUser
.
- A
-
Create entity relationship mappings as follows: (Creating a package for each requirement is advised.)
- Create them using
uni-directional
. - Create them using
bi-directional
. - Create
User
andReview
mapping withJoin Table
. - Create
User
andReview
mapping withJoin Column
. - Create
User
andAddress
mapping withJoin Table
. - Create
User
andAddress
mapping withJoin Column
.
- Create them using
-
Implement CRUD operations and build REST API for all domain models.
-
Implement the following queries by using
Naming Convention
. Create REST endpoints for them.- Find all products that cost more than
minPrice
. - Find all products in
cat
category and cost less thanmaxPrice
. - Find all products that contain
keyword
in the name. - Find all products created by the user with id =
id
. - Find reviews of the product whose id is
id
.
- Find all products that cost more than
- Use n-tier software architecture model.
- Use DTOs.
- PostgreSQL is recommended as a Relational Database system.
- Populate your database with dummy data using
data.sql
.
- Create a postman collection that includes sample requests for all of your endpoints.
- Fork the the repository and push your changes.
- Once you finished your project, send a Pull Request. (Send only one Pull Request once you finish the assignment.)
- You are not allowed to share codes with your classmates. If detected, you will get NC.
- For pairs:
- Individual's work will be checked from the commits.
- Share tasks evenly and fairly.
- To have a clearer understanding of pair programming:
-
Pair programming is an agile software development technique in which two programmers work together at one workstation. One, the driver, writes code while the other, the observer or navigator reviews each line of code as it is typed in. The two programmers switch roles frequently.
- Wikipedia
-
-
Remember to respect the code honor submission policy. All written code must be original. Presenting something as one’s own work when it came from another source is plagiarism and is forbidden.
-
Plagiarism is a very serious thing in all American academic institutions and is guarded against vigilantly by every professor.