Preview

Nt1330 Unit 1 Study Guide

Powerful Essays
Open Document
Open Document
1178 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Nt1330 Unit 1 Study Guide
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
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Better Essays

    CITM 595 Chapter 11 Review
    • 1209 Words
    • 6 Pages

    CITM 595 Chapter 11 Review

    - order begins a paper-based journey around the company where it is keyed and rekeyed into the…

    • 1209 Words
    • 6 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    Dbm/380 Database Concepts
    • 461 Words
    • 2 Pages

    Dbm/380 Database Concepts

    A database is a set of programs and applications used to store data, this allows the data to be used by different individuals in different areas and access information from it quickly. A database stores the information so it can be used at a later time so additional information can be added, taken away, or used as needed. Once in the database the data is compressed so it takes up less space in the computer’s memory. The database allows those authorized to use the data within it and control the creation, maintenance, and use of a database. A database stores various kinds of files, data records, and other objects. There are a variety of database models; there is the relational model or object model, which supports applications. That use query languages, which are high-level programming languages, and dedicated database languages that simplify writing database application programs. The main function of a database is basically retrieving and presenting information it controls, in doing this it allows the users data access, protects the data’s and makes it more manageable. It also provides safety features for the data so that it is not lost or misplaced and if there is a serious event or natural disaster, fire, etc. it can be recovered and restored from a backup. In my work we use Microsoft Access as a relational database for employment records and to store our client information such as names, addresses, phone numbers, and email addresses from this database we send out a monthly newsletter with special offers on services and products. By using a database, an organization saves time and money because it is only a few simple steps and we can email all of our clients and customers a monthly newsletter which informs them about what is happening within the organization, services and products we offer, and what is on sale which generates more business. By using a…

    • 461 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Dbm 381 Week 1paper
    • 885 Words
    • 4 Pages

    Dbm 381 Week 1paper

    A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities (Pratt & Adamski, 2012, Chapter 1). How data is received, stored, processed, and made available to others has an effect on the success or failure of an organization. The use of different architecture is a most to fit the needs of the organization, however the value of the data still remains in been able to access and extract information from the database system, and the only way this can be reached is by organizing, storing, and analyzing it effectively. For many organizations these systems have become an essential part of their structural and operational success.…

    • 885 Words
    • 4 Pages
    Good Essays
    Read More
  • Powerful Essays

    Hcs/482 Systems Media Table
    • 1437 Words
    • 6 Pages

    Hcs/482 Systems Media Table

    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
    Read More
  • Powerful Essays

    Book
    • 1742 Words
    • 7 Pages

    Book

    • 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
    Read More
  • Powerful Essays

    Different Types of Dbms
    • 979 Words
    • 4 Pages

    Different Types of Dbms

    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
    Read More
  • Satisfactory Essays

    Dbms
    • 318 Words
    • 2 Pages

    Dbms

    The data based, DBMS, and the application programs together are termed as data base system…

    • 318 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    aaaaaaaaaaaaaaa
    • 22607 Words
    • 123 Pages

    aaaaaaaaaaaaaaa

    system if data were stored in an unorganized way or if there were no systematic way to…

    • 22607 Words
    • 123 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    DBMS
    • 3523 Words
    • 15 Pages

    DBMS

    Database management system (DBMS) is a computer program (or more typically, a suite of them) designed to manage a database, a large set of structured data, and run operations on the data requested by numerous users.…

    • 3523 Words
    • 15 Pages
    Powerful Essays
    Read More
  • Good Essays

    SDLC
    • 538 Words
    • 3 Pages

    SDLC

    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
    Read More
  • Good Essays

    Leo's Cuisine Point of Sale System
    • 10143 Words
    • 41 Pages

    Leo's Cuisine Point of Sale System

    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
    Read More
  • Best Essays

    Introducing Database System
    • 4276 Words
    • 18 Pages

    Introducing Database System

    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
    Read More
  • Satisfactory Essays

    Mis Management Information Systems
    • 1023 Words
    • 5 Pages

    Mis Management Information Systems

    • Collection of interrelated data • Set of programs to access the data • DBMS contains information about a particular enterprise • DBMS provides an environment that it both convenient and efficient to use…

    • 1023 Words
    • 5 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Mb0047 - Management Information Systems
    • 5590 Words
    • 23 Pages

    Mb0047 - Management Information Systems

    It is also called as integrated database Management System which supports in major functional areas.…

    • 5590 Words
    • 23 Pages
    Powerful Essays
    Read More
  • Good Essays

    Reasons for Computer Science
    • 598 Words
    • 3 Pages

    Reasons for Computer Science

    Base on storing information in the database, a reasonable large scale operation in a commercial, technical, administration or educational area might have resources which it uses to meet its objective that demands proper management (like storage, organizing, manipulating, retrieval and output) with the use of database, data accessibility, security,…

    • 598 Words
    • 3 Pages
    Good Essays
    Read More

Related Topics