Scribd
Upload
25 views10 pages

ICT Task

The document outlines key concepts related to data, databases, and Database Management Systems (DBMS), including definitions and examples. It discusses types of databases in MS Access, functions of DBMS, and various database objects such as tables, forms, queries, and reports. Additionally, it explains relationships between data, including one-to-one, one-to-many, and many-to-many relationships.

Uploaded by

nodybrakat2010
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
25 views10 pages

ICT Task

The document outlines key concepts related to data, databases, and Database Management Systems (DBMS), including definitions and examples. It discusses types of databases in MS Access, functions of DBMS, and various database objects such as tables, forms, queries, and reports. Additionally, it explains relationships between data, including one-to-one, one-to-many, and many-to-many relationships.

Uploaded by

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

ICT Task

By : Renad Mohamed
Learning objectives

▪ Definition of data, database & DBMS


▪ Types of database in MS Access
▪ Functions of DBMS
▪ Database objects
▪ Relationships
Definition of Data, Database & DBMS

▪ Data: Information about something or someone

▪ Database: Arrangement of data in a manner that can be retrieved


easily

▪ DBMS: It is a set of computer programs that controls & manages the


creation & use of database in the computer

▪ Examples of DBMS programs: MS Access, Oracle, Fox Pro &


FoxBASE
Types of database in MS Access

Flat File Relational


When data is stored in When data is stored in a form that
form of plain text & cannot data are related to each other it
incorporate multiple tables supports multiple tables
Functions of DBMS

▪ Reduces data ▪ Enforces standards:


redundancy:
Certain standards can be applied in
To reduce the duplication of data data representation

▪ Facilitates sharing of ▪ Ensure data security:


data: Protect the data
Different users can access the same
database ▪ Maintains integrity:
Keep some constrains when the data
▪ Controls data is entered
inconsistency:
Controls the automatically updated
data
Database Objects
Objects you can use while creating a
MS Access 2010 database:

▪ Table: ▪ Forms:
Stores information in the form of rows Customise screens to provide an
(records) & columns (fields) easy way to enter & view data in a
table or query

▪ Queries: ▪ Reports:
These are used for sorting , grouping These present the data in a table or
or filtering data in the database query in a printed format
Database objects

▪ Records ▪ Primary key


A record is all of the data or It is a field to uniquely identify every
information about one person or one single record in a database
thing Record = Row

▪ Fields ▪ Foreign Key


A field is one piece of data or It is used to link tables together & create a
information about a person or thing relationship, moreover, it is a field in one
Fields = columns table that is linked to a primary key in
another table
▪ Data Types
▪ Referential integrity
Like : Alphanumeric or text,
Number, Currency, Date/time Ensures that there are no orphan records
& prevents you from deleting related
records
Relationships

▪ One to One
In one to one relationship each record in one table has only one related
record in the other table

▪ One to Many
Means a record in table A can have many matching records but in table B it
can have only one matching record

▪ Many to Many
Means a record in table A can have many matching records in table B & table
B can have many matching records In table A
That is the end of the presentation
Thanks for reading

By: Renad Mohamed


Under supervision of :
Miss/Sara Nasser

You might also like