FOR FREE YEAR SOLVED

DBMS and Database Definition:

DBMS

Data – Data are facts that can be recorded and carry implicit meaning.

Example – Text, Name, Address, Images, Videos.

Database: 

Database – Database is an integrated collection of related data. A database has the following 

1. Database represents aspects of the real-world.

2. A random assortment of data cannot be an example of a database.

Various kinds of Database exists:

1. Traditional Database (TDB): Where data is stored and accessed in either textual or numeric form. Basically it is used as formal kind use in real life. 

2. Multimedia Database:  Where images, audio clips, and videos are stored.

3. Geographic Information System: Where maps, weather data, satellite images are stored and can be analyzed further.

4. Another we can say it is database is Database Warehouse.

Database Warehouse: Where a huge amount of data is stored and later they are analyzed in order to find out useful business information like store a data of a company of 100 years.

By a software or set of programs we define, create, and manipulate databases. This set of programs called  DBMS.

A Database Management System (DBMS) is a collection of programs that allows users to create and maintain a database basically it is a piece of software designed to store and manage the database.

Various companies provide various DBMS.

Two important things in DBMS: 

# Entities (e.g. student, course)

# Relationship (e.g. Alice is enrolled in 145)

Examples: