Introduction to Databases

DATA MANIPULATION

Tuesday, November 26, 2024

TYPES OF COMPUTER

BASED DATABASES

 A flat file database is a database that stores data in

one table and is organized in rows and columns .

RELATIONAL DATABASES

 A relational database stores data in more than one linked

table stored in a file. Relational databases are designed so
that the same data is not stored in various tables.

 Each table within a relational database will have a

primary key. That holds unique data.

 Some tables will have one or more foreign key fields.

 A foreign Key in one table will point to a primary key in

another table.



Table 1

Primary Key
Student ID

Table 2

Parent is is the

primary Key

Student ID is
foreign Key