Embedded Files
Organized collection of structured information stored electronically for easy access management and retrieval
Organized collection of structured information stored electronically for easy access management and retrieval
Relational databases
Relational databases
set of tables from which data can be accessed in different ways without reorganizing the database tables
set of tables from which data can be accessed in different ways without reorganizing the database tables
Notice how it has
Notice how it has
Tables: to hold the data
Tables: to hold the data
Rows: represents individual record within a table
Rows: represents individual record within a table
Columns: attributes with specific data
Columns: attributes with specific data
Primary keys: unique identifier for each row in a table
Primary keys: unique identifier for each row in a table
Foreign keys: establishing a link between
Foreign keys: establishing a link between
Types of relationships
Types of relationships
One to one: both tables can have only one record that matches the other
One to one: both tables can have only one record that matches the other
One to many: table contains records that can relate to one none or many
One to many: table contains records that can relate to one none or many
Many to many: a record in either table can relate to any number of records in another table.
Many to many: a record in either table can relate to any number of records in another table.
Page updated
Google Sites
Report abuse