Introduction of SQL Server
Data and Database:
Data means information and it is the most important component in any work that is done.
A Database is a collection of data. Some like to think of a database as an organized mechanism that has the compatibility of storing information
Data Management deals with managing large amount of information, which involves both the storage of information and the provision of mechanisms for the manipulation of information.
- File-Base Systems:
Storage of large amounts of data has always been a matter of huge concern. In early days, file-based systems, that is systems in which data was stored is discrete files, were used. In this system, a bunch of files was stored on a computer and could be access by computer operator.
- Database Systems:
Database Systems evolved in the late 1960’s to address common issue in application handling large volumes of data which are also data intensive.
- Database Management System(DBMS):
A Database Management System can be define as a collection of related records and set of programs that access and manipulate these records.
- Flat-File Data Model:
In this model, the database consists of only one table of file. This model is used for simple database.
- Hierarchical Data Model:
In this model different records are inter-related through hierarchical or tree like structures.
- Network Data Model:
This is similar to hierarchical data model. The hierarchical model actually is a subset of the network model. However instead of one parent network model have more than one parent.
- Relational Data Model:
This model represents the database as a collection of relations. In this models terminology, a row is called a tuple, column as attribute and the table is called relation.
Relational Database Management System(RDBMS)
A Relational Database Management System is a database divided into logical units called tables, where tables are related to one another within the database. A relational database allows data to be broken down into logical, smaller and manageable units.
Watch the video to learn more: