- Huiyu Guan
- Wong Huang Liu
- Hyeran Park
Assignment:
- Download and install PostgreSQL on your devices (for Mac users I recommend the app)
- Using Figma/Lucidchart, create an ER Diagram of your database
- Create a brand new database with a specific topic (eg pizza, students, employees, etc.) with
Download and install PostgreSQL on your devices (for Mac users I recommend the app) - Using Figma/Lucidchart, create an ER Diagram of your database
- Create a brand new database with a specific topic (eg pizza, students, employees, etc.) with
At least four different tables.
Each table should have a primary key
Each table should have at least four dummy tuples
Each table should be able to be joined with one other table in the database (this will make sense once you understand schemas) - Write an inner join query that joins two tables, one that joins three tables and one that joins all four tables (you can stack inner joins)
- Finally using Postman*, try to post a brand new line of data and get two different lines of dummy data that you placed inside the database.