Database Programming Paradigm

A database program is the heart of a business information system and provides file creation, data entry, update, query and reporting functions

What is Database Programming Paradigm?

Database programs let users create and edit single files interactively at the keyboard. However, as soon as they want data in one file to automatically update another, programming has to be done. That is where the faint of heart take their leave, and the techies take over.

Concepts of functional programming

• Low Repetition and Redundancy
• Easy Maintenance of Large Databases
• Enhanced Security
• Multi-User Environment Support
• Improved file consistency

Advantages

• Reduced data redundancy
• Reduced updating errors and increased consistency
• Greater data integrity and independence from applications programs
• Improved data access to users through use of host and query languages
• Improved data security
• Reduced data entry, storage, and retrieval costs
• Facilitated development of new applications program

Disadvantages

• Database systems are complex, difficult, and time-consuming to design
• Substantial hardware and software start-up costs
• Damage to database affects virtually all applications programs
• Extensive conversion costs in moving form a file-based system to a database system
• Initial training required for all programmers and users