| Student Table | | |
| Id | Name | Course |
| 1 | Abc | 100 |
| 2 | Xyz | 101 |
| Course table | |
| Id | Name |
| 100 | Computers |
| 101 | Arts |
In the above case the Course table is a lookup table. You look up with the course id and get the course name
No comments:
Post a Comment