Adjust week 6 RESTful API project instructions and provide more clarity

[daaimah123]

👉🏾 First time contributing to this repo? START HERE 👈🏾

To be added as a curriculum contributor and be assigned the related issue, please kindly complete our contributor steps in order to have your PR addressing this issue merged.

Page where problem found?

REST API with Node and Express in the Backend and DOM Manipulation in the Frontend

Type of problem

The lesson does not provide a clear view of what to expect at the end of the project, the purpose of each of its tech parts / steps, and the order of steps was also unclear.

Suggested Solution

• condense "general" and "specific" guideline
  • these two sections can create confusion, condense into a separate list of learning objectives and requirements
• clarify learning objective
  • reference and explain purpose of the hardcoded JSON data file,
  • reference and explain purpose of the local database,
  • reference and explain purpose of working with Postman (for both hardcoded and local), and
  • reference and explain purpose of PostgreSQL querying
• clarify that frontend requirement is a bonus
  • remove frontend from the title
  • make clear that the frontend is an optional component of the project for the week
• suggested day to day breakdown
  • Day 1 & 2: create hard coded JSON data and manipulate using CRUD operations
  • Day 3: begin to transfer your hard coded data into a local database table; test data manipulation using Postman (for both hard coded JSON data and local database table)
  • Day 4: transition CRUD operations to query the local database table instead of the hardcoded JSON data
• connection to relevancy/usage or explanation of how pieces fit together before even working on the project
  • explain why querying from hardcode JSON data (remote access)
  • explain why querying from local database table (local access, with the exception of a dump file - share why you would do this, reference dump file resource link)
  • explain why participants will be transitioning their CRUD operations from querying a JSON's hardcoded file to SQL querying a local database table
• set expectation of what each step should look like and what the end of the project should look like
  • explain that they will be working with data in two ways this week
  • explain visual and syntactical differences between hardcoded JSON file query vs SQL query to local database table
  • explain briefly (with reference to the appropriate lesson) what working with Postman will be like
• clear steps (or point to a reference) for how to transition from hardcoded to a database

Resources to reference in update

• HTTP Request Practice
• RESTful API
• PostgreSQL Installation
• Database Table Connection
• Books Array of Objects
• How to Dump and Restore PostgreSQL Database?