About Database Design

[Santosh344]

I am just going to start but I have confusion does back-end developer need to design front-end application

[innoflash]

i don`t know what you been given but if its what we all got i think its supposed to be an API according to the challenge document

[sbansa1]

Hello,

Greetings !

I was looking at the documentation some of the endpoints as per the document seem flawed like Path: /products/inDepartment/{department_id}
we are not provided the data base script with the department_id as the foreign key ? not sure what do I need to do here.

Moreover I am creating all these as individual services or Microservices.Hope that's fine

[innoflash]

Hello,

Greetings !

I was looking at the documentation some of the endpoints as per the document seem flawed like Path: /products/inDepartment/{department_id}
we are not provided the data base script with the department_id as the foreign key ? not sure what do I need to do here.

Moreover I am creating all these as individual services or Microservices.Hope that's fine

That part seems perfect @sbansa1 there seems to be a table linking the products to categories, u can do the math its a relationships type of logic u shld be paying attention to here

[sbansa1]

Thanks I solved it @zandoan

[sbansa1]

Although, I had to replicate some data to make sure I am maintaining the persistence. @zandoan