Tuesday 31 March 2020

View of Database


View of Database

It refers that how the database is actually stored in database, what data and structure of data used by the database for data. Abstraction is one of the main features of database systems. Hiding irrelevant details from the user and providing an abstract view of data to users helps in easy and efficient user-database interaction. In the previous tutorial, we discussed the three-level of DBMS architecture, The top level of that architecture is “view level”. The view level provides the “view of data” to the users and hides the irrelevant details such as data relationship, database schema, constraints, security etc from the user. To describe all this database provides the user with views and these are

Characteristics and Benefits of a Database


Characteristics and Benefits of a Database

1. Sharing of data and multiuser system: Current database systems are designed for multiple users. That is, they allow many users to access the same database at the same time. This access is achieved through features called concurrency control strategies. These strategies ensure that the data accessed are always correct and that data integrity is maintained.

File Oriented Approach and Purpose of Database System


File Oriented Approach

The earliest business computer systems were used to process business records and produce information. They were generally faster and more accurate than equivalent manual systems. These systems stored groups of records in separate files, and so they were called file processing systems. In a typical file processing systems, each department has its own files, designed specifically for those applications. The department itself working with the data processing staff sets policies or standards for the format and maintenance of its files. Programs are dependent on the files and vice-versa; that is, when the physical format of the file is changed, the program has also to be changed. Although the traditional file-oriented approach to information processing is still widely used, it does have some very important disadvantages. 

Introduction to Database

Introduction to Database

A database is a shared collection of related data used to support the activities of a particular organization. A database can be viewed as a repository of data that is defined once and then accessed by various users.

Monday 30 March 2020

Introduction to Window


Practical No.-2
Introduction to Window
1.WINDOWS
An operating system with a graphical user interface (GUI). Graphical User Interface (GUI) is a user interface based on graphics (icons and pictures and menus) instead of text; uses a mouse as well as a keyboard as an input device)

Introduction to DOS : DOS commands are copy con, edit, doskey, type, md, cd, ver, date, time


Practical No.-1
Introduction to DOS : DOS commands are copy con, edit, doskey, type, md, cd, ver, date, time

1.1 Introduction: MS-DOS short for Microsoft Disk Operating System is an operating system for x86-based personal computers. It was the most commonly used member of the DOS family of operating systems, and was the main operating system for IBM PC compatible personal computers during the 1980s to the mid 1990s, until it was gradually superseded by operating systems offering a graphical user interface (GUI), in particular by various generations of the Microsoft Windows operating system.