Introduction Database and Database Management System

Introduction Database and Database Management System

Open Ended

What do you know about DATABASE?

Open Ended

What do you want to know about database?

Learning Objective

• Important term about database

• Function of DBMS and database objects

What do you think about this image?

Database

• Important database terms

• Function of DBMS

• Database Objects

Important Database Terms

Database, Database Management System, Table Record, Field

Database

A database is an organized collection of structured information, or data, typically stored electronically in a computer system

https://www.oracle.com/database/

what-is-database/

Database

 a database is an organized collection of data stored and accessed electronically from a computer system

https://en.wikipedia.org/wiki/Database

Database

 a database is an integrated collection of logically related records in the form or tables

https://en.wikipedia.org/wiki/Database

Fill in the Blanks

Express in two words the similarity of that 3 database definitions above!

Google database center

what happens?

DBMS

Database management System is a set of computer programs that control the creation, maintenance and use of the computerised database by the user.

Multiple Select

Choose the correct DBMS applications.

• MS Access

• CorelDraw

• Fox Pro

• Excel

Table

A table is a collection of related information in the form of rows and columns.

Poll

How many tables appear in the previous slide picture?

• 1

• 3

• 9

• 4

Structure of database

Record

a record is one row of a table. It includes complete information arranged horizontally.

Fill in the Blanks

KTP record? (3 columns name separate by one space)

Field

A vertical column in a table that stores information of the same type

Multiple Choice

Fields name in the table Rating

• ArtistId, AlbumId, ArtistName

• RatingId, AlbumId, Rating

• Artist, Album, Rating

Open Ended

Game list

Open Discussion

What will happen if there is no database while you play online games?