Database
is a collection of one or more tables. Each table is identified by a
name. Table contains records.
Student table
| Id | FirstName | LastName | City |
| 1 | Murali | Krishna | Canada |
| 2 | Joel | Chelli | Guntur |
| 3 | Naveed | Anjum | Vijayawada |
| 4 | Jaideep | Geera | Guntur |
| 5 | Arjun | Krishna | Punur |
In
the above case, Student is the table name, it contains five
records(row represent a record). Each record has four fields (Id,
FirstName, LastName, City) associated with it. In the above table,
Id is the primary key, means it is used to uniquely identify a row in
the table.
No comments:
Post a Comment