Tutorials » SqlServer tutorials »

Database, tables, records and fields


This chapter explains what is database, tables, records and fields.


What is a Database ?


A database is a collection of all data required for an application. Each database application will have only one database.

What is a Table ?


- Tables are part of database.
- A database is composed of several tables.
- You need to create separate tables to store different type of data. For examples, if you have a School Management Software, you may need to create the following tables:
  • Students - to store list of all students
  • Teachers - to store list of all students
  • Attendance - to track the attendance of all students
  • MarkList - to store the mark list of all students

What is a Record?


A record represents one entry in a Table. A table can have any number of records.

If you have a "Students" table to store the student information, a record in the table represent a student. To add a student, you will add a record to the "Students" table. To delete a student from the software, you will delete a record from this table.

What is a Field ?


A field is a column in the table. A record is a collection of fields. All records in the same table will have the same set of fields.

If you have the "Students" table, you may have the following fields:

  • Name - to store the name of the student
  • Address - to store the address
  • DateofBirth - to store the date of birth of the student
  • RegistrationDate - to store the date on which the student registered.
    etc.

    If you add a field to the Table, it is applicable to all records in the same table. In the above example, all records in the "Students" table will have the same 4 fields.

    Summary


    A database a collection of Tables
    A Table is a collection of Records.
    All records in the same table will have the same fields.
    In most cases, an application will have one database which has several tables.



  • Next Chapter: Compare SQL Server and MS Access
    Previous Chapter: What is a database?
    More Chapters: Sql Server Tutorials
    More Tutorials: Tutorial Index



    Top Contributors
    TodayLast 7 Daysmore...

    Awards & Gifts
     
    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India