The notes are about DBMS ,c# language, Study notes of Applications of Computer Sciences

Download The notes are about DBMS ,c# language and more Study notes Applications of Computer Sciences in PDF only on Docsity!

DEPARTMENT OF COMPUTER SCIENCE, GFGC, MALUR COMPUTER SCIENCE - til (2016) DATABASE MANAGEMENT SYSTEM AND SOFTWARE ENGINEERING. SECTION-A 1. Answer any 10 question. Each question carries 2 marks, 1) What is DBMS? Mention the functions of DBMS. A database management system (DBMS) is software designed to store, define and manage data in a database. A database management system is software package designed to define, manipulate, retrieve and manage data in database. FUNCTIONS OF DBMS *data structure and independence *data security *a locking mechanism for concurrent access *an efficient handler to balance the needs of multiple applications using the same data. 2) Define DML. Mention the different operations of DML. DATA MANIPULATION LANGUAGE(DML) It is used for accessing and manipulating data in a database. it handles user requests. Manipulation of database may include the operations such as: . Retrieval of data . Insertion of data . Deletion of data . Modification of data. 3) +Write a note on DBMS interface. The user-friendly interfaces may include the following: . Menu based interfaces . Graphically interfaces . Forms based interfaces . Natural language interfaces . Interface for parametric users ° Interfaces for the DBA 4) What is normalization? What are the different types of normal forms. Normalization of data can be looked on as a process during which unsatisfactory relation schemas are decomposed by breaking up their attributes into smaller relation schemas that possess desirable properties. TYPES OF NORMALIZATION: ¢ First normal form (1NF) e¢ Second normal form(2NF) e = Third normal form(3NF)