INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

We all live in an age where the world is full of data and information. You must have heard of internet, which has become a huge source of information and also growing everyday. The amount of data is actually very large to access and maintain. For example, if we go to the bank to deposit or withdraw funds, if we make booking in a hotel or railways reservation, even purchasing items from a supermarket or Mall all these activities involves an automatic update of the database which keeps the inventory of the store room or showroom items.

In the traditional database applications, where most of the information was stored and accessed in either textual or numeric form. But nowadays, video clips, pictures files, weather data, satellite images and sound image files are stored in separate and specialized databases such as multimedia databases.

If your school Principal just wants to know the marks of a student named Kalpana in your class. There could be more than one Kalpana in the class, but if the data is organized in a proper manner, the information can be provided in few seconds to the Principal. To get the right data and information you must have some database accessing tools with you, so that information can be accessed and managed in a timely and effectively manner. Data must therefore be collected in an organized form so that you can get the data in very less time.

Also, in daily routine activities we come across a large number of organizations such as, University System, Airlines, Banks, Manufacturing Company etc. The functions performed by these organizations vary from one another. Accordingly data is needed to store, manage and accessed.

Here we had the overview of Database Management System (DBMS), file system and its advantages including its types. We know about the pictorial representation of data in the form of Entity Relationship (ER) Diagram. 

A Database management system (DBMS) can be seen as a software package which allows users to design, create, access and maintain and view data. In databases, you can store and maintain data property. You can present the database design pictorially in the form of ERDiagram,

The database system supports multiple views of the same data. For example, a clerk may only be able to see his details, whereas the manager can view the details of all the clerks working under him. In this unit we have discussed the types of databases, like relational, network and Hierarchical databases.

We have discussed about the relation between the attribute values, entity types etc. We have discussed the two approaches for storming data in computers i.e file system approach and database approach. There are some limitations of File System Approach which includes data redundancy, data independence and difficult to get quick answers to simple queries. So, database approach is brought into practice for handling data properly and efficiency.

Comments

Post a Comment

Popular posts from this blog

COMPUTER VISION

 Computer Vision is the branch of Computer Science whose goal is to model the real world or to recognize objects from digital images. These images can be acquired using video or infrared cameras, radars or specialized sensors such as those used by doctors, scientist, geologist etc. Vision is a most powerful interfacing device for computers. They have the potential to sense body movements and their position, head orientation, direction of the body, and gestures. When the vision based interaction is established with the machine, they could make  the interaction between both of us enjoyable or safer. The algorithms for the computer vision should be reliable, work for different people, and work in odd conditions. The responding time of these algorithms should be very fast. The user should sense delay between when he moves or make gesture and when computer responds. The student will understand the basic techniques of the field of Computer Vision. We will also discuss what are the t...
Read more

FUNDAMENTALS OF EMBEDDED SYSTEMS

Embedded systems are basic electronic devices used to control, monitor or assist the operation of equipment, machinery or a plant. The choice of word “embedded” reflects the fact that these are integral part of the system. Uses of embedded system in our real life are increasing day by day. Children need such systems to play video games and to operate chocolate vending machine, Housewives need embedded systems for microwave, TV, music system, and other system appliances. Here we will discuss about basics of embedded system: its uses, its components, its basic requirements in terms of Hardware and Software and support of Programming Languages. We will also highlight some application of embedded system in our real life scenario at the end of this unit. Embedded system is a kind of computer system or computing device that performs a dedicated function and/or is intended for use with a specific embedded software application. It has been found that such systems are not usable as a commercial...
Read more

ADVANCED METHODS OF COMMUNICATION WITH A COMPUTER

Human computer interaction is a discipline concerned with the design, evaluation and implementation of interactive computing systems for human use. If the interface is well designed, it will allow the systems functionality to support the user’s task. This unit tracks the development path of human computer interaction from the command line mode to hyperlinks, hypermedia, voice user interface etc. Here we have discussed about different perspectives of communication with computer. Humans communicate with computers in many ways, and the interface between humans and the computers they use is crucial to facilitating this interaction. Different perspectives of human computer interface are human perspective, computer’s persona, user interface and interactions etc. To communicate with computers, we require different kind of input and output devices are available. Controls are the software elements, usually shown on a display, which you use to set preferences and make choices. Some familiar cont...
Read more