It is only limited to smaller DBMS systems.Įxpensive. DBMS supports a multi-user environment that allows users to access and manipulate data in parallel.ĭesign to fulfill the need of small and large businesses.It follows the ACID concept ( Atomicity, Consistency, Isolation, and Durability).Database Management Software allows entities and relations among them to form tables.Sharing of data and multiuser transaction processing.Insulation between programs and data abstraction.Self-describing nature of a database system.Provides security and removes redundancy.Here are the characteristics and properties of a Database Management System: Basically, your Database will have 5 tables with a foreign key defined amongst the various tables.We can also use a coding scheme to represent the values of a data item.

We need to specify the structure of the records of each file by defining the different types of data elements to be stored in each record.The TUTOR file contains information about each professor.The GRADE file stores the grades which students receive in the various sections.The SECTION stores information about sections in a particular course.The COURSE file stores contain data on each course.The STUDENT file stores the data of each student.This database is maintaining information concerning students, courses, and grades in a university environment. Let us see a simple example of a university database.

Libreoffice access database