Chapter 17, Problem 9SA

Program Plan Intro

Organization of table in a database:

• The data present in a database is organized into one or more tables.
• Each of table would hold a collection of related data.
• The data present in a table is structured into rows as well as columns.
• A row denotes a complete set of information regarding single item.
• The data stored in row is been divided into columns.
• Each of the columns denotes individual piece of information about item.
• A table has a specified number of columns, but can have any number of rows.
• A data type is been assigned to columns in table.
• The column designated as primary key holds distinctive value for each row.
• A primary key denotes column used for identification of a certain row in a table.
• An error occurs when duplicate data is been stored in primary key column.