Book Loan Records

what will we do

We will create a book lending system so that we can know what books are borrowed and who borrowed them and prevent books from getting lost.

travel map

1. Create ERD and determine type from each data

2. Practice and create the system

3. Insert data to each table

4. See results

Let’s Go!!!!

1. Create ERD

   

   PK = Primary Key

   FK = Foreign Key

2. Open your terminal and login to postgresql

3. Cek your table

   

4. If you have a book table, you can delete it first.

   

5. Create All tables

   

   

   

6. Insert data to table

   

   

7. Show result

   

My Error and typos

i forget the quotation marks

END !!!

See you next time 😵‍💫🥱🤗😁👋.