How to fetch details if we want to know details like how many students are taking a particular course ? I don’t see any relation established between them the two table are standing apart
To ans your question that is 'how to fetch the details?' Let's say u have 2 tables STUDENTS(stu_id, stu_name) and CLASSES(class_id, class_name). First we need to create a new table which combines the data from the 2 tables. Then we use SQL JOIN to fetch the details that you are asking for. Hope this clarifies your doubt.
How to fetch details if we want to know details like how many students are taking a particular course ? I don’t see any relation established between them the two table are standing apart
How to fetch the details goes into querying part. We are not writing queries here, just understanding the relationships.
To ans your question that is 'how to fetch the details?'
Let's say u have 2 tables STUDENTS(stu_id, stu_name) and CLASSES(class_id, class_name).
First we need to create a new table which combines the data from the 2 tables. Then we use SQL JOIN to fetch the details that you are asking for.
Hope this clarifies your doubt.
@@ConstantLearners_AI_ML_CS yes thank you
Keep answering the questions,it would be great help
I'll try my best :)