Distinguish between file processing system and DBMS.

Distinguish between file processing system and DBMS.
by

1 Answer

Answer :

Database Management system
File processing system
1. Presence of Self-describing nature of a database system and Metadata.
1. File processing don't contain any self describing feature and neither posses metadata.
2. In database system, the structure of data files is stored in the DBMS catalog separately from the access program. This is called program-data independence
2.In file processing system, if any changes to the structure of a file may require changing all programs that access the file
3. Support of multiple views of the data i.e Each user may see a different view of the database, which describes only the data of interest to that user
3.File processing system don't support multiple views.
4. Sharing of data and multi-user transaction processing i.e allowing a set of concurrent users to retrieve from and to update the database
4.It is not possible to share data and multi user transaction simultaneously among concurrent users in case of file processing system
5. Controlling Redundancy is one of most important feature to use DBMS
5. Controlling Redundancy is one of most important feature to use DBMS
by

Related questions

List DBMS softwares.

Description : List DBMS softwares. 

Last Answer : List of DBMS software are the followings: i. Oracle RDBMS ii. IBM DB2 iii, Microsoft SQL Server iv. MySQL v. MS Access vi. SQLite vii. PostgreSQL viii. MongoDB ix. SQL Developer x. SAP Sybase SE 

Distinguish between network database model and relational database model.

Description : Distinguish between network database model and relational database model. 

Last Answer : Network database model Relational database model Relationship between records is expressed in the form of pointers or links Relationship between records is represented by a relation that contains a key for ... logically in the form of rows and columns. Example:  Example: 

. A _____ DBMS distributesdata processing tasks between the workstation anda network server. A. Network B. Relational C. Client Server D. Hierarchical E. None of the above

Description : . A _____ DBMS distributesdata processing tasks between the workstation anda network server. A. Network B. Relational C. Client Server D. Hierarchical E. None of the above

Last Answer : Client Server

Compare file system and database system.

Description : Compare file system and database system. 

Last Answer : File system Database system  1. File processing don't contain any self describing feature and neither posses metadata.  1. Presence of Self-describing nature of a database system and Metadata. ... own file.  5. Controlling Redundancy is one of most important feature to use DBMS

ome of the utilities of DBMS are ............. i) Loading ii) Backup iii) File organization iv) Process Organization A) i, ii, and iv only B) i, ii and iii only C) ii, iii and iv only D) All i, ii, iii, and iv

Description : ome of the utilities of DBMS are ............. i) Loading ii) Backup iii) File organization iv) Process Organization A) i, ii, and iv only B) i, ii and iii only C) ii, iii and iv only D) All i, ii, iii, and iv

Last Answer : B) i, ii and iii only

Describe centralized database system with example.

Description : Describe centralized database system with example. 

Last Answer : Centralized Database System: 1. A centralized database consists of a single data server into which all data are stored and from which all data are retrieved. All the data reside at a single location and ... is cheaper than other types of databases as it requires less power and maintenance. 

Explain client/server database system.

Description : Explain client/server database system. 

Last Answer : 1. It has two logical parts client and server.  2. Computer networking allows some task to be executed on a server system and some tasks on client system. This leads to development ... as application server to receive and send requests from client machine to database server and vice versa.

Define Database. List advantages of database system.

Description : Define Database. List advantages of database system. 

Last Answer : A database is an organized collection of data so that it can be easily accessed, managed and updated. Advantages of database system are the following:  1. Controlling ... Providing Backup and Recovery facilities is provide by DBMS for recovering from hardware or software failures.

Explain distributed database system with example.

Description : Explain distributed database system with example.

Last Answer : A distributed database is a database that consists of two or more files located in different sites either on the same network or on entirely different networks. Portions of the database ... Ignite, Apache Cassandra, Apache HBase, Couchbase Server, Amazon SimpleDB, Clusterpoint, and FoundationDB

Describe client server system with example.

Description : Describe client server system with example.

Last Answer : Client server system consists of two logical components. One is Client and the other one is Server . Clients are those who send the request to perform a specific task to the server. ... client's CPU and memory. But server runs a database management system which manages the whole database.

What is DBMS or Database Management System ?

Description : What is DBMS or Database Management System ?

Last Answer : DataBase Management System is the full form of DBMS . DBMS is a set of programs required for accessing , storing , controlling and managing interconnected information called database management systems.

There arecertain packages that allow people to define data items, place these items in particular records, combine therecords into designated files and then manipulate and retrieve the storeddata. What arethey called? A. Data storage system B. Database management system (DBMS) C. Batch processingsystem D. Data communication package E. None of the above

Description : There arecertain packages that allow people to define data items, place these items in particular records, combine therecords into designated files and then manipulate and retrieve the storeddata. What arethey ... (DBMS) C. Batch processingsystem D. Data communication package E. None of the above

Last Answer : Database management system (DBMS)

DBMS stands for: a) Data Base Management Software b) Data Base Management System c) Diode Base Management System d) None of These

Description : DBMS stands for: a) Data Base Management Software b) Data Base Management System c) Diode Base Management System d) None of These

Last Answer : b) Data Base Management System

DBMS stands for: a) Dynamic Bureau of Management System b) Document Base Management System c) Data Base Management System d) None of These

Description : DBMS stands for: a) Dynamic Bureau of Management System b) Document Base Management System c) Data Base Management System d) None of These

Last Answer : c) Data Base Management System

In a Database Managemnt System (DBMS), the content and the location of the data is defined by the ____. (1) Multi Dimensional data (2) Sequence data (3) Meta data (4) Sub data

Description : In a Database Managemnt System (DBMS), the content and the location of the data is defined by the ____. (1) Multi Dimensional data (2) Sequence data (3) Meta data (4) Sub data

Last Answer : Meta data

Explain various types of Relational constraints.

Description : Explain various types of Relational constraints.

Last Answer : Relational Constraints Relational constraints are a set of rules. It is used to maintain the quality of information. Integrity constraints ensure that the data insertion, updating, and other ... - It establishes parent child relationship between two tables. For example :Foreign key constraints 

Explain three level architecture of Database

Description : Explain three level architecture of Database

Last Answer : There are following three levels or layers of DBMS architecture: External Level : Describes part of the database that a particular user group is interested in. Conceptual Level: Describes structure of ... is the one that concerns the way the data are physically stored on the hardware.

Explain advantages of centralized and distributed databases.

Description : Explain advantages of centralized and distributed databases.

Last Answer : Advantage of Centralized databases   * Data integrity is maximized -Data integrity is maximized and data redundancy is minimized because data is stored at a single place.  * Easier Database Administration - ... data is distributed, a group of users can easily share and use data of different sites

Describe the three levels of data abstraction with diagram.

Description : Describe the three levels of data abstraction with diagram. 

Last Answer : Three levels of data abstraction are:  Physical level: This is the lowest level of data abstraction. It describes how data is actually stored in database. The complex data structure details ... highest level of data abstraction. This level describes the user interaction with database system.

Describe object-oriented data models.

Description : Describe object-oriented data models.

Last Answer : Object Oriented Model : Object oriented models were introduced to overcome the shortcomings of conventional models like Relational, Hierarchical and network model. An object-oriented database is collection of objects whose ... with other objects. It is also said to be semantic data model.

State characteristics of Database.

Description : State characteristics of Database.

Last Answer : The Characteristics of Database are: 1. Persistent Data 2. Meta Data and Self-describing nature of a DB 3. Insulation between programs and data (Data Independence) 4. Support ... Sharing of data and multiuser transaction processing 6. Access flexibility and Security. 7. Controlled Redundancy

Define the term Foreign Key.

Description : Define the term Foreign Key. 

Last Answer : A FOREIGN KEY is a key used to link two tables together. A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table. It ... between tables because it references the primary key of another table, thereby establishing a link between them.

Define the term Data Model.

Description : Define the term Data Model.

Last Answer : Underlying structure of the database is called as data model. It is a collection of conceptual tools for describing data, data relationships, data semantics and consistency constraints. Data models define how data is connected to each other and how they are processed and stored inside the system.

List types of Database languages.

Description : List types of Database languages.

Last Answer : Four types of database languages are: 1. DDL (Data Definition Language) 2. DML (Data Manipulation Language) 3. DDL (Data Control Language) 4. TCL (Transaction control language)

Define the term Database Schema

Description : Define the term Database Schema

Last Answer : The overall design of the database is called the database schema. A schema diagram displays only names of record types (entities) and names of data items (attributes) and does not show the relationships among the various files. 

Describe enhanced ER model with the help of example.

Description : Describe enhanced ER model with the help of example. 

Last Answer : Enhanced ER is a high-level data model that incorporates the extensions to the original ER model. It is created to design more accurate database schemas. EER reflects data properties and constraints more precisely ... example: Square, Circle, Triangle are the sub class of Shape super class. 

List advantages of Normalization.

Description : List advantages of Normalization. 

Last Answer : List of Advantages of Normalization are the following: 1. More efficient data structure. 2. Avoid redundant fields or columns. 3. More flexible data structure i.e. we should be able to ... 7. Minimizes data duplication. 8. Close modeling of real world entities, processes and their relationships.

Define database model.

Description : Define database model. 

Last Answer : Definition of database model: A database model is a type of data model that determines the logical structure of a database. It also fundamentally determines in which manner data can be stored, organized and manipulated. 

Define Constraint.

Description : Define Constraint. 

Last Answer : Constraints are the rules enforced on the data columns of a table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in ... are applied only to one column, whereas the table level constraints are applied to the whole table. 

Define Domain and Attribute.

Description : Define Domain and Attribute. 

Last Answer : * Domain: All permissible values of attributes are called as a domain. * Attribute: is a property or characteristics of an entity set. 

Explain Codd’s rules.

Description : Explain Codd’s rules.

Last Answer : Codd rules:  Rule 1: The information rule a has to be presented to the user should be in the form of table.  Rule 2: Guaranteed Access Rule Whole data should be available or ... interface cannot be used to subvert the system, for example, bypassing a relational security or integrity constraint

Explain merits and demerits of Object Oriented Database model.

Description : Explain merits and demerits of Object Oriented Database model.

Last Answer : Object oriented models were introduced to overcome the shortcomings of conventional models like Relational, Hierarchical and network model. An object-oriented database is collection of objects whose behavior, state, ... . * There is no view mechanism * There is no adequate security mechanism.

Explain functional dependency with example.

Description : Explain functional dependency with example.

Last Answer : A functional dependency occurs when one attribute in a relation uniquely determines another attribute. OR Consider a relation say R(X,Y), where X and Y are one or more than one attribute, ... sscper. That is, given rollno of a student, the name and sscper can be determined or searched.

Differentiate between Hierarchical Database model and network database model.

Description : Differentiate between Hierarchical Database model and network database model.

Last Answer : Hierarchical Database Model  Network Model Network Model represents tree like structure with one root. Network Model represents tree like structure with many roots. Reflects 1:N ( ... the use of pointers Record relationship implementation is complex due to the use of pointers

Explain different types of attribute with example and their symbols used in ER diagram.

Description : Explain different types of attribute with example and their symbols used in ER diagram.

Last Answer : Different types of attributes are: 1. Simple attribute: A simple attributes are those which cannot be subdivided. Eg:Rollno-  symbol 2. Composite attribute: a composite attribute is ... value can be calculated or determined from another attribute Eg: age from dateofbirth  Symbol

Describe benefits and drawbook of denormalization.

Description : Describe benefits and drawbook of denormalization.

Last Answer : Benefits of denormalization: * Reduce number of relations: It reduce the number of relations because it combines two relations into one new relation. * Reduce number of foreign keys: It reduce number ... : It is always application-specific and needs to be re-evaluated if the application changes. 

Explain Domain constraints with Syntax and example.

Description : Explain Domain constraints with Syntax and example. 

Last Answer : Domain constraints are used to maintain value according to user specification Domain constraints are: 1. Not null-such constraints are applied to an attribute when we have to specify that the ... datatype(size),attr2 datatype(size) constraint nameofconstraint check(attr<value)); or

Explain components of database in detail.

Description : Explain components of database in detail.

Last Answer : A database system involves four major components. 1. Data 2. Hardware 3. Software 4. Users

Explain Generalization with example.

Description : Explain Generalization with example.

Last Answer : Generalization uses bottom-up approach where two or more lower level entities combine together to form a higher level new entity if they have common attributes in common. The new generalized entity can ... Example, STUDENT and FACULTY can be generalized to a higher level entity called PERSON

Explain three tier architecture of database with the help of diagram.

Description : Explain three tier architecture of database with the help of diagram.

Last Answer : Application server or Web server *Adds intermediate layer between client and the database server *Runs application programs and stores business rules Clients contain GUI interfaces and ... GUI format. Thus the user interfaces, application rules and the database acts as three tier. 

Define Normalization, list its types.

Description : Define Normalization, list its types.

Last Answer : Normalization is a systematic approach of decomposing tables to eliminate data redundancy(repetition) and undesirable characteristics like Insertion, Update and Deletion Anomalies. It is a multi-step process that ... data from the relation tables. Types of Normalization are: 1NF,2NF,3NF,4NF,5NF

Write Syntax for create table.

Description : Write Syntax for create table.

Last Answer : Syntax of Create table: CREATE TABLE table_name(  column1 datatype (size),  column2 datatype(size),  column3 datatype(size),  ..... columnNdatatype(size)  );

Define Data and instance.

Description : Define Data and instance.

Last Answer : Data: Data can be defined as facts or information that can be recorded and have an implicit meaning.  Instance: The collection of information stored in the database at a particular moment is called an instance of the database.

Define constraints, list types.

Description : Define constraints, list types.

Last Answer : Constraints are used to limit the type of data that can go into a table. Constraints are used to ensure accuracy and consistency of data in a relational database.  Types of Constraints : ... Constraint 3.UNIQUE Constraint 4.CHECK Constraint 5.Primary Key Constraint 6. Foreign Key Constraint

Define primary key and candidate key.

Description : Define primary key and candidate key.

Last Answer : Primary Key: A primary key is an attribute in Relation that uniquely identifies the rows in relation. A Primary key does not hold NULL values and duplicate values.  OR A key which is selected by the ... , Name) can be a candidate key if and only if Name and Rollno individually are not unique. 

Define the term tuple and domain.

Description : Define the term tuple and domain.

Last Answer : tuple: A row is called a Tuple. domain:A domain is a set of all possible (or permissible) values in an attribute. OR  A Domain is defined as a kind of data represented by an attribute.

Define (i) Data Abstraction, (ii) Data Redundancy.

Description : Define (i) Data Abstraction, (ii) Data Redundancy.

Last Answer : Data abstraction is defined as  *Suppression of details of data organization and storage  *Highlighting of the essential features for an improved understanding of data  *The characteristic that allow ... of data abstraction. This level describes the user interaction with database system. 

Disadvantage in File Processing System?

Description : Disadvantage in File Processing System?

Last Answer : ∙ Data redundancy & inconsistency. ∙ Difficult in accessing data. ∙ Data isolation. ∙ Data integrity. ∙ Concurrent access is not possible. ∙ Security Problems.

Use the new system as the same time as the old system to compare the results. This is known as … A) Procedure Writing B) Simultaneous processing C) Parallel Operation D) File Conversion

Description : Use the new system as the same time as the old system to compare the results. This is known as … A) Procedure Writing B) Simultaneous processing C) Parallel Operation D) File Conversion

Last Answer : C) Parallel Operation