Question

Design a table for the Library database of your school. Analyse the data required to be stored in this table and accordingly create fields and records in it. Select a suitable field as the primary key of the table and give the reason for selecting it. The table should contain a minimum of 5 relevant fields and 10 records in it.​

Answer 1

Answer:

answer in below

Explanation:

A simple database, such as a contact list, might use only a single table. Many databases, however, use several tables. When you create a new database, you create a new file on your computer that acts as a container for all of the objects in your database, including your tables.

You can create a table by creating a new database, by inserting a table into an existing database, or by importing or linking to a table from another data source — such as a Microsoft Excel workbook, a Microsoft Word document, a text file, or another database. When you create a new, blank database, a new, empty table is automatically inserted for you. You can then enter data in the table to start defining your fields.