description of this data designed to meet tine information needs of an

Description of this data designed to meet tine

This preview shows page 46 - 55 out of 72 pages.

description of this data, designed to meet tine information needs of an organization. Meta-Data or Data Dictionary The description of the data is known as System Catalog System Catalog or Data Dictionary or Data Dictionary or Meta-Data or Meta-Data
Image of page 46

Subscribe to view the full document.

Data-Base Management System: Entity Entity An entity is a distinct object (a person, place or a thing, concept or event) in the organization that is to be represented in the database. Attribute Attribute An attribute is a property that describes some aspect of the object that we wish to record. Relationship Relationship A relationship is an association between several entities.
Image of page 47
Data-Base Management System: Database Management System (DBMS) Database Management System (DBMS) A software system that enables users to define, create and maintain the database and provides controlled access to this database. Data Definition Language (DDL) Data Definition Language (DDL) It allows users to define the database. The DDL allows users to specify the data types, structures and constraints on the data to be stored in database. Data Manipulation Language (DML) Data Manipulation Language (DML) It allows user to Insert, update, delete and retrieve data from database. Query Language Query Language General enquiry facility to the data, called a Query Language.
Image of page 48

Subscribe to view the full document.

Data-Base Management System: Data Entry and Reports Data Entry and Reports DBMS Data Base Sales application Program Contacts application Program Sales Contacts
Image of page 49
Data-Base Management System: Components of DBMS Hardware Software Data Procedures People Hardware Software Data Procedures People Machine Bridge Human
Image of page 50

Subscribe to view the full document.

Data-Base Management System: Advantages of DBMS Control of data redundancy (Non Duplicate) Data Consistency (Single Up-dation) More information from the same amount of data Sharing of data Improve data integrity and Consistency Improved security Enforcement of standards Economy of scales Balancing of conflicting requirements Improved data accessibility and responsiveness Increased productivity Improved maintenance through data independence Increase concurrency Improved backup and recovery services
Image of page 51
Data-Base Management System: Disadvantages of DBMS Complexity Size Cost of DBMS Additional Hardware cost Cost of conversion Performance Higher impact of a failure
Image of page 52

Subscribe to view the full document.

Data-Base Management System: Functions of a DBMS Data Storage, retrieval and update A user-accessible catalog Transaction support Concurrency control services Recovery Services Authorization / Authentication Services Support for data communication Integrity Services Services to promote data independence Utility Services
Image of page 53
Systems from a Functional Perspective Sales and Marketing Systems Manufacturing and Production Systems Finance and Accounting Systems Human Resource Management Systems Quality Assurance Systems Global Tracking Systems
Image of page 54

Subscribe to view the full document.

Image of page 55
  • Fall '15
  • KHURRAM SHEHZAD

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes