174k views
2 votes
Write the field for the table "BOOK" with its field type and also write the primary key for the table.

1 Answer

2 votes

Answer:

Fields are the components that provide structure for a table. Fields in a table store the same category of data in the same data type. For example, if you have a NAME field in a table of customers, the entries for this field are all customer names and are stored as text.

A primary key is a field or set of fields with values that are unique throughout a table. Values of the key can be used to refer to entire records, because each record has a different value for the key. Each table can only have one

primary key.

The primary key of this table is the ISBN, which uniquely identifies a book. The title column relates to the book; this is the title of the book. Each row of this table is about one book.

User Bryan Anderson
by
4.7k points