Chapter 9, Problem 10CRP

Program Plan Intro

Relational Database:

• A database Management System is a software application for managing the database in a well-organized form.
• It provides a systematic way to create, retrieve and update the database.
• In DBMS, the schema explains the logical structure of the data base system.
• It provides the capability to the user to self-analyze the database and perform the necessary operations.
• A relational database comprises of rectangular tables known as relations.
• Every row in relation is known as tuple.
• Each column in table is termed as field or attribute.
• It describes the characteristics of entity represented by corresponding tuple.

Relational database design process:

• It is designed to meet requirements of particular application.
• There are no two databases that are alike.
• The design choice is based on user preference.
• The steps used in this process includes:
  • Step 1 – Define the database purpose
  • Step 2 – Gather data and organize in table
  • Step 3 – Refine and normalize design, it includes adding columns, creating new relation and splitting large relation into smaller relations.