1. Database Concepts

What is a database?
-Structured collection of related data.
Examples:Address book, Telephone Directory, Dictionary.

Why use Electronic Database?
  • speed
  • ease of use
  • versatility
What are types of Electronic Database?
  • Flat File Database-basically used for simple lists and may have duplication of data.
  • Relational Database - data is held in a number of cross-referenced files in order to reduce duplication.They make it easier to find, analyze, maintain and protect your data because it is all held in one place.
What are Electronic Database Components?
  • Database is composed of 1 or more tables
  • Tables is composed of 1 or more records
  • Records is composed of 1 or more fields
  • Fields has a Datatype
Sidenote: In order to create an relational database ,you need DBMS.


What is a DBMS?
  • stands for DataBase Management System
  • a set of software that are used to define, store, manipulate and control the data in a database.
    • define --- define data types, structures and constraints.
    • store --- store data; provide efficient access.
    • manipulate --- perform retrieval and update operations using a query language.
    •  control --- control access to data. 
Database System=Database+DBMS

4 comments:

  1. Mario SilvanoNovember 19, 2011 at 4:30 PM

    Please don't forget your valuable comments and suggestions. Thank you.

    ReplyDelete
  2. AnonymousDecember 2, 2011 at 11:43 PM

    good afternoon sir.. naa pa ba tong atong gibuhat sa lab sir? katong running program? pwede sir mangayo mi para ma studyhan namo? thank you soo much sir..

    ReplyDelete
  3. AnonymousJanuary 19, 2012 at 11:14 PM

    BELATED HAPPY BIRTHDAY SIR:)

    ReplyDelete
  4. Mario SilvanoFebruary 11, 2012 at 8:27 PM

    @Anonymous: Please become a member of our blogspot so that I could identify you. Thanks sa greeting.:)

    ReplyDelete

Subscribe to: Post Comments (Atom)