0% found this document useful (0 votes)
9 views18 pages

DBMS, GOC and PowerPoint

Uploaded by

oforjose3.0
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
9 views18 pages

DBMS, GOC and PowerPoint

Uploaded by

oforjose3.0
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 18

DATABASE MANAGEMENT SYSTEM

(DBMS)
A database is a systematic collection of data.
A Database Management System is a collection of programs which
enables its users to access database, manipulate data and help in
representation of data.
It also helps control access to the database by various users.
Charles Bachmen’s Integrated Data Store (IDS) is said to be the first
DBMS in history.
TYPES OF DBMS
The following shows the evolution of DBMS categories
Object
Navigational Relational
SQL DBMS Oriented
DBMS DBMS
DBMS

There are four types of DBMS


Hierarchical DBMS
Network DBMS
Relational DBMS
Object Oriented Relation DBMS
EXAMPLES OF DBMS

• Microsoft Access
• Microsoft SQL
• MySQL
• Oracle
• IBM DB2
• Firebird
DETAILED FUNCTIONS OF A DBMS
A Database Management System
1. creates and maintains database schema;
2. creates table structures;
3. carries out data retrieval;
4. carries out data update;
5. ensures data integrity;
6. controls concurrency/shared update;
7. ensures security of data and database structures;
8. ensures backup and recovery;
DIFFERENCE BETWEEN DBMS AND SPREADSHEET

Database Management Systems can create associations that cannot be


made with electronic spreadsheets
Database Management Systems can create custom views while
electronic spreadsheets cannot.
DBMS is more powerful than a spreadsheet, especially for handling
large volume of data.

• Identify any other four


OBJECTS IN A DBMS

The following objects exist in a database


1. Table
2. Query
3. Form
4. Report
5. Macro
6. Module
TABLE
 A Table contains records (rows) and
fields (columns).
 Used for storing raw data.
 Each record contains information
about one thing, with the same piece
of information.
NB: Programs like SQL (Structured Figure 1-1: A table contains records (rows) and fields
(columns).
Query Language) server and MySQL are
used to link tables to existing tables in
order to access databases in databases
created.
QUERIES

 For selecting your data and getting useful information from


tables.
 Queries are operations carried out on your data to answer
specific data needs.
 For combining information from several tables.
 Action query does something specific to the records you select
e.g. sort, delete etc.
FORM

A form is used for


1. editing existing data
2. displaying your data on screen.
3. Entering data, especially into
more than one related table, is
to use a form.
Figure 1-2: A form shows information from one table record at a time.

Figure 1-2 shows a form for entering


names and addresses for an Address
Book table .
QUIZ

How many fields are there?


How many records are
there?
REPORTS

• For presenting output in a well formatted manner. E.g. Changing


and adding objects like logo, header or footer.
• For Printing Data on paper and one can save reports as PDF
(Portable Document Format) and XPS (Microsoft’s equivalent of a
PDF) files for e-mailing or posting on the web.
NB: Most reports are based on queries; you use a query to choose the
information that appears in the report.
The report design defines the order in which records appear, which
fields appear where, and which fonts, font size, colour, gridlines and
spaces to use.
MACROS
• For saving keystrokes.
• Macros are programs that automate the commands you give when you
use access.
NB: Access includes two separate programming languages, one for macros
and a separate one (VBA, or Visual Basic for Applications) for higher
programs.
To create macros, Access helps you write them by providing menus of
commands.

MODULES are used for writing one’s own program.


HISTORICAL
DEVELOPMENT OF
COMPUTERS
Generations of computers
ARTIFICIAL
INTELLIGENCE
1940 – 1956 1956 – 1963 1964 – 1971
Used Vacuum tubes for Used transistors in place Used Integrated
circuitry. of vacuum tube. circuits in place of
Used magnetic drums for Used magnetic core transistors.
memory. drums for memory. Keyboards were used
Punch cards and paper Punch cards for inputs. for inputs.
tapes for inputs. Outputs were
Outputs displayed on
Outputs displayed on printouts. displayed on
printouts. monitors.
Symbolic or Assembly
Machine language language was used.
(lowest level language)
was used.
1971– Present Present – Beyond
Micro processors Use of Artificial
replaced Integrated Intelligence.
Circuits. Use of Parallel
High level Languages processing and super
like C, C++, etc. were conductors
used.
PUNCH MAGNETIC DISKS
CARDS

Paper tape

UNIVAC I ENIAC I Systems


READING EXERCISE:
Understanding Data Processing SS 1
Chapter 4; pg. 25 – 30.
Instruction: After reading the above chapter carefully, Identify the different
generations of computers and outline their characteristics using the headers
below.
 Year of development
 Technology used
 Method of Input and Output
 Type of Language used
 Examples
 Any other unique characteristic(s)
Handy tricks and tips
Some keyboard shortcuts to help you on your way!
During a presentation

 Spacebar or Click the mouse moves to the next slide or next animation
 Press B to blacken the screen during a presentation or W to whiten it
 Ctrl + P gives you a pen to draw on a slide (Esc will return to your cursor).
 Press the desired slide number + enter on the keyboard to jump to that slide.

During Normal View

 F5 Starts the presentation from the beginning


 Prt Sc copies an image of whatever is on the current screen to the clipboard
 Ctrl + Z undoes the last action you did
 Ctrl + C copies highlighted text or an object
 Ctrl + V pastes the last item added to the clipboard
 Ctrl + D copies and pastes in one action

You might also like