DB (112-1 Database)

• This is for the Database lecture in 2023 Fall from NTNU TAHRD.
• Noted by Yun-Huei Pan (May Pan).

Key Takeawys

1. Differences between SQL and noSQL

HW

• HW1: Create your own database: ER Diagram

• HW2: Create your own database: frontend + backend

• HW3: MongoDB

• Final Project video & Final Project in Retool

  • This is the final project of this lecture for the semester. Instead of using node.js and react, we figure out a great tool, which is Retool. It helped us a lot for designin the user interface and the backend since we can build our own database in it, too. Feeling grateful for the help of modern technology xD and we'll go all out to make our project into reality. <3
  • we can update / delete your demo & ideas by using the bar on the right side, which has already be connected to our query

Notes to myself

1. For HW1:

• Just simply biuld tables that you need
• DO NOT forget your root password

2. For HW2:

• Goal: This homework aims to connect the CRUD backend & frontend and also connect with mysql workbench

• Step 1. source code download from here and this is the tutorial. You can also learn CRUD in mandarin Chinese by watching this video, which is recorded by Irene Chang, one of my best classmate ever.

• Step 2. instructions to remember (i) create new folders: client, server (ii) steps as followings:

  • client (react) :

    • 2.1.1 npm create react-app client
    • 2.1.2 change director to your client folder
    • 2.1.3 npm start
    • 2.1.4 from folders we just downloaded : Simple-CRUD-React-Node-MySQL-main.zip\Simple-CRUD-React-Node-MySQL-main\client\src

  • 2.1.5 copy three files: App.css, App.js, and index.js. Then Replace these files into your client>src we've just added by "npm" (If "axios" doesn't exist, "npm install axios")

  • server (node.js): 2.2.1 change directr to your server folder 2.2.2 npm init (Then there should automatically appear a "package.json" file in your server folder) 2.2.3 from folders we've just downloaded: add "index.js" in Simple-CRUD-React-Node-MySQL-main.zip\Simple-CRUD-React-Node-MySQL-main\server to YOUR server folder

  (iii) Change the names of our tables and columns from index. js(in server folder) and App.js(in client folder) respecitvely

  • ask ChatGPT to change the table and column names into what you've done in HW1

3. For HW3:

• Goal: using mongodb to access our data in mysql
• useful resources:
  • backend
  • mongodb tutorials There are two ways to get to our goal (i) Method 1, by installing. Referenced from my intellegent classmate huwalli. Tutorial playlist that I checked : Complete MongoDB Tutorial. For this homework, we need only video 1~4 (merely for learning how to use the tool and install it)
    • notes to myself: neccessary downloading: mongadb community server & mongodb compass (ii) Method 2, by scripts.
    • videos that our professor recommanded us
      • Build app using React JS, Node Express JS and Mongo DB (MERN Stack)
      • Nodejs React with Mongodb (MERN) Crud App(MongoDB, Express, React, Node JS)