This week i make the database based on the ERD (Entity Relationship Diagram) and Relational Table that my friends already make, i also learn how to get the data after saving it . For the get data part i make another project for my own practice following the save data part from the last weekly report.

Database

fix-erd.png

relational table.png

Based on these ERD and Relational Table, i make the database structure as follow:

1.PNG 2.PNG 3.PNG 4.PNG 5.PNG 6.PNG

Here i define the tables, primary key, foreign key, and attributes. In JSON there is no assignment in every attribute such as primary key or foreign key, so i try to implement it using another way so it looks like primary key and foreign key in the implementation.

Based on the video i watch, i can implement “WHERE” and “JOIN” query in JSON but with different language and different way with SQL language, so in this week i’ll learn it for this project.

 

References:

Firebase Youtube Channel: https://www.youtube.com/user/Firebase/videos

  • Common SQL Queries converted for the Firebase Database – The Firebase Database For SQL Developers #4
  • Joins in the Firebase Database – The Firebase Database For SQL Developers #5

Simplified Coding Youtube Channel: https://www.youtube.com/user/SimplifiedCoding/videos

  • Firebase Realtime Database Tutorial for Android – Saving Data #1
  • Firebase Realtime Database Tutorial for Android – Retrieving Data #2

StackOverflow

 

Advertisements