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.
Based on these ERD and Relational Table, i make the database structure as follow:
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.
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