I have these following three tables named
**Student Table**
id name
1 ali
2 ahmed
3 john
4 king
**Course Table**
id name
1 physic
2 maths
3 computer
4 chemistry
**Bridge**
sid cid
1 1
1 2
1 3
1 4
2 1
2 2
3 3
3 4
4 1
4 2
Now to display the student name with the course name which he had studied like,
**Result**
Student Course
ahmed physic
ahmed maths
ahmed computer
ahmed chemistry
ali physic
ali maths
john computer
john chemistry
king physic
king maths
I make the following query
select s.name as Student, c.name as Course from student s, course c join bridge b on c.id = b.cid order by s.name
Though it does not return the expected result...
And what would be for the normalized form, if I need to determine who is the manager over other:
**employee**
id name
1 ali
2 king
3 mak
4 sam
5 jon
**manage**
mid eid
1 2
1 3
3 4
4 5
And I need to get this following result:
**result**
Manager Staff
ali king
ali mak
mak sam
sam jon