what purpose do the records hold in database?

Answer 1

In any DBMS, the data which you input will be stored in the form of records(rows). Its easier in this way to track down a particular record that you are looking for in the DBMS with the help of the Index which will be created in the database, 'coz of which time consumption will be less.
Hope this will help you.