Introduction of database approach: -

 Introduction of database approach: -

•           The database concept has evolved since the 1960s.

•           An organized collection of data (information) on people or things organized in table form.

•           Contains objects that are used for storing and managing information.

•           Shared collection of related data.

•           Allow their users to enter, access and analyze their data quickly and easily.

•           Visualize it as a container of information.

•           The data is typically organized to model.

•           Ex. In the stationery shop, keep detailed records of the materials available, store information according to pricing, stock levels for reordering, old stocks, etc. In the computerized system (such as Microsoft Access, Base, and MySQL,).

•           Item:- information store in the database ex. Name, address, etc.

•           Field:-column name or property of the table.

•           Record:- set of information (in fields /row) stored in the database about one of the items.

•           Value:- Actual text or numerical amount or date that store as information into the database.

•           Table:- like a spreadsheet. Store all information as a grid. A unique collection of similar records. (Unique helps to avoid duplication of records caused by user or computer error.)

•           Key field:- a column of the table, which ensures unique value in the database.

•           Database:- collection of one or many tables ex. Address.

Post a Comment