Nt1330 Unit 1 Study Guide

Powerful Essays
Q1. Differences between a file-processing system and a Database management system.

1) A Database is generally used for storing data in a structured way in an efficient manner for insert, update and retrieval of data in well defined formats. On the other hand, in file system the data stored in unstructured manner with an unrelated data.
2) A database management system organizes both physical and logical approach to the data on the other hand file-processing system integrates only the physical access.
3) A database management system is designed to organize multiple users accessing at same time with the same data. a file-processing system is generally designed to allow one or more programs to access different data at the same time.
4) A database management system is implemented to access data in form of queries. File processing system is designed to
…show more content…
They are the responsible to manage the DBMS’s use and also creating, modifying and maintaining the database. Which to ensure the database is functioning properly.
Function of database administrator:
To create Schema definition: It is a database administrator responsible to installation, configuration and upgrading hardware and operating system on given database and also to decide what information to be held in database.
To define the storage structure and access methods : Database administrator decide how the data represented in database and described by writing the storage structure definition and also specify the mapping between storage structure definition and the conceptual

You May Also Find These Documents Helpful

  • Good Essays

    The data is stored in the form of tables. The tables consists of rows and columns. The primary and secondary key help to eliminate data redundancy, enabling systematic storage of data.…

    • 686 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    database schema from the top to the bottom in the process of a database design. This Section examines the entity-relationship model and the object-oriented model as representatives of conceptual modeling. The entity-relationship model is widely used and the object-oriented model is gaining more acceptance for non-traditional databases.…

    • 4703 Words
    • 19 Pages
    Powerful Essays
  • Good Essays

    Exam

    • 2709 Words
    • 11 Pages

    • Describe how the problems of managing data resources in a traditional file environment are solved by a database management system • Describe the capabilities and value of a database management system • Apply important database design principles • Evaluate tools and technologies for accessing information from databases to improve business performance and decision making • Assess the role of information policy, data administration, and data quality assurance in the management of a firm’s data resources…

    • 2709 Words
    • 11 Pages
    Good Essays
  • Good Essays

    SDLC

    • 538 Words
    • 3 Pages

    Files are electronic lists of data that have been optimized to perform a particular transaction. A database is a collection of groupings of information that are related to each other in some other way. Furthermore a file must have a specific program created to read the particular file format, where as a database management system can access a set of data or data subsets to retrieve that data contained within.…

    • 538 Words
    • 3 Pages
    Good Essays
  • Good Essays

    A database is a collection of related files that are usually integrated, linked or cross-referenced to one another. The advantage of a database is that data and records contained in different files can be easily organized and retrieved using specialized database management software called a database management system (DBMS) or database manager. A database management system is a set of software programs that allows users to create, edit and update data in database files, and store and retrieve data from those database files all using a DBMS2. It consists of a combination of pre-written software programs controlling the following functions of a database: Storage; Organization; Management; Update; and Retrieval of data.…

    • 10143 Words
    • 41 Pages
    Good Essays
  • Powerful Essays

    System |Purposes |Examples |Uses | |Word processor |The word processor, Invented in the early 1900s an updated prototype of the typewriter, creates a document in digital format but goes one step further than the typewriter and stores the information. Word processors can track changes and make corrections as you type. |Microsoft word which widely used for in the business and personal world. Word perfect, Word pad, and Word open office writer |One of the biggest uses for me is writing my papers for class. The fast connivance to proof read and spell check save me time. Allows the user to save and share his document. Word processors gives the option of making comparisons of documents; in cases where several users may be working on the same documents, the comparison feature allows for differences in the documents to be easily viewed, making editing more streamline(brown). | |Hierarchical database |Hierarchal data can be organized data where each level of the data is organized, resembling a tree. Data can be arranged in a repeating series that ties or links the data together.Its designed to process and manipulate data in a number that takes advantage of the hierarchical(Prabhakran & Rajamani). |A family tree can be organized in a structured form. Prabhakaran & Rajamani). |This type of Data base is used mostly to save and retrieve information efficiently. | |Flat Database |A system where information can be stored. Flat files are simple data that files that take up very little space that other files.Flat files are like spread sheet where rows on the…

    • 1437 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    A database is an integrated collection of logically related data elements. A database consolidates records previously stored in separate files into a common pool of data elements that provides data for many applications. The data stored in a database are independent of the application programs using them and of the type of storage devices on…

    • 1553 Words
    • 7 Pages
    Good Essays
  • Good Essays

    DATABASE SQL

    • 592 Words
    • 2 Pages

    Traditional databases are organized by fields, records, and files. A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records. For example, a telephone book is analogous to a file. It contains a list of records, each of which consists of three fields: name, address, and telephone number.…

    • 592 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Book

    • 1742 Words
    • 7 Pages

    • Databases • A repository of data • DBMS (Database management system) • Software system that manages databases • The terms “Database”, “DBMS”, “data server”, “database server” often used interchangeably to refer to a DBMS • Why a DBMS? • Security • Can handle many users with good performance • Allows for concurrency while keeping data consistent • Protects from disaster…

    • 1742 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    Different Types of Dbms

    • 979 Words
    • 4 Pages

    A Database is a collection of records. Database management systems are designed as the means of managing all the records. Database Management is a software system that uses a standard method and running queries with some of them designed for the oversight and proper control of databases.…

    • 979 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Database System Concepts

    • 301237 Words
    • 1205 Pages

    Database management has evolved from a specialized computer application to a central component of a modern computing environment, and, as a result, knowledge about database systems has become an essential part of an education in computer science. In this text, we present the fundamental concepts of database management. These concepts include aspects of database design, database…

    • 301237 Words
    • 1205 Pages
    Good Essays
  • Best Essays

    Introducing Database System

    • 4276 Words
    • 18 Pages

    Introduction 1.1 Manual File System 1.1.1 Disadvantages of Manual File System 1.2 Computerised File System 1.2.1 Disadvantages of Computerised File System 1.3 Database System 1.4 Database 1.4.1 Characteristics of Database 1.5 Database Management System 1.5.1 Functions of Database Management System 1.5.2 Advantages of Database Management System 1.5.3 Disadvantages of Database Management System…

    • 4276 Words
    • 18 Pages
    Best Essays
  • Satisfactory Essays

    Bca Se Syllabus

    • 1858 Words
    • 8 Pages

    Block 1 : DBMS concepts : Introduction – Basics of Database – Three views of Data – Three level architecture of DBMS – Facilities – Elements of DBMS – Advantages and disadvantages – Database Models : File Management system and its drawbacks – Database Models : E-R Model, Hierarchical Model, Network Model, Relational Model.…

    • 1858 Words
    • 8 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Database management systems were developed to handle the following difficulties of typical file-processing systems supported by conventional operating systems. • Data redundancy and inconsistency • Difficulty in accessing data • Data isolation – multiple files and formats • Integrity problems • Atomicity of updates • Concurrent access by multiple users • Security problems…

    • 1023 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    dbms 2 marks

    • 347 Words
    • 3 Pages

    Database management system (DBMS) is a collection of interrelated data and a set of programs to access those data.…

    • 347 Words
    • 3 Pages
    Satisfactory Essays