Relational Database Various types of databases were developed. One of them was relational database which was developed by E.F Codd at IBM in 1970. It is a collection of data items organized as a collection of relations where each relation corresponds to a table of values. A table consists of rows and columns. Each row in the table corresponds to a unique instance of data and each column is used...
Continue reading »
December 11, 2015 evirtualguru_ajaygourOnline Computer EducationNo Comment
Advantages of using DBMS approach The need of DBMS itself explains the advantages of using a DBMS. Following are the advantages of using a DBMS: 1. Reduction of redundancies – Data in a DBMS is more concise because of the central repository of data. All the data that is accessed is stored at one place. There is no repetition of the same data. This also reduces the cost of storing...
Continue reading »
December 11, 2015 evirtualguru_ajaygourOnline Computer EducationNo Comment
Characteristics of Database Management Systems The main characteristics of a DBMS are as follows: 1. Self-describing nature of a database system – DBMS contains not only the database but also the description of the data that it stores. This description of data is called as meta-data. Meta-data is stored in a database catalogue or data dictionary. It contains the structure of the data and also the constraints that are imposed...
Continue reading »
December 11, 2015 evirtualguru_ajaygourOnline Computer EducationNo Comment
Database Management System (DBMS) A database management system is a collection of programs that enables users to create, maintain and use a database.It can be viewed as a repository of data that is defined once and then accessed by different users as per their requirements. In the Database approach,there is a single repository of data which is accessed by all the application programs as shown in the example below: The...
Continue reading »
December 11, 2015 evirtualguru_ajaygourOnline Computer EducationNo Comment
Need for a Database In Traditional file processing, data is stored in the form of files. A number of application programs are written by programmer’s to insert, delete, modifyand retrieve data from these files. New application programs will be added to the system as the need arises. For example, consider the Sales and Payroll departments of a company. One user will maintain information about all the salespersons in the Sales...
Continue reading »
December 11, 2015 evirtualguru_ajaygourOnline Computer EducationNo Comment
Introduction Data is a collection of raw facts which have not been processed to reveal its meaning. For example, test marks of every student in a school. Information is produced by processing data as shown in Figure1. For example, given the data of the test marks of all the students in a class, the average marks of all the students and the maximum and minimum marks in the class can...
Continue reading »
December 11, 2015 evirtualguru_ajaygourOnline Computer EducationNo Comment
Society for Promotion of Information Technology, Chandigarh (Under the aegies of Department of IT, Chandigarh Administration) PEC Campus, Sector-12, Chandigarh 160 012 Telefax: 0172-2744235, 2745502, Email: info@spicindia.com, www.spicindia.com Hardware-cum-Network Administrator Recruitment in Society for promotion of IT in Chandigarh(SPIC) Chandigarh Post : Hardware-cum-Network Administrator Department : SPIC – CHB Number of Post : 1 Salary : 30000 Start Date : 2015-12-11 Closing Date : 2015-12-22 Skill : Installation, Handling...
Continue reading »
December 11, 2015 Poonam taprialCareer GuruNo Comment
Society for Promotion of Information Technology, Chandigarh (Under the aegies of Department of IT, Chandigarh Administration) PEC Campus, Sector-12, Chandigarh 160 012 Telefax: 0172-2744235, 2745502, Email: info@spicindia.com, www.spicindia.com Database Administrator Recruitment in Society for promotion of IT in Chandigarh(SPIC) Chandigarh Post: Database Administrator Department : SPIC Number of Post : 1 Salary : 30000 Start Date : 2015-12-05 Closing Date : 2015-12-14 Skill : B.Sc. (Computer Science)/BCA, B.Tech, OEM certification Essential...
Continue reading »
December 8, 2015 Poonam taprialCareer GuruNo Comment
