ITE014 MOD 1

what is relational database?

• a software that controls the storage, organization, and retrieval of data
• a centralized and structured set of data stored on a computer system
• a collection of relations or two-dimensional tables.
• a type of database that stores data in a single table

one kind of data in a table

• primary key
• row
• field
• column

column that refers to a primary-key column in another table

• field
• foreign key
• column
• primary key

row

• one kind of data in a table
• the one value found at the intersection of a row and a column
• data for one table instance
• basic storage structure

primary key

• column that refers to a primary-key column in another table
• the one value found at the intersection of a row and a column
• basic storage structure
• unique identifier for each row

the one value found at the intersection of a row and a column

• field
• column
• table
• row

basic storage structure

• primary key
• column
• row
• table

he proposed the relational model for database systems

• Dr. E.G. Codd
• Dr. E.F. Cowell
• Dr. E.F. Codd
• Dr. E.F. Coll

when was the concept of relational database porposed?

• 1972.0
• 1971.0
• 1927.0
• 1980.0

how many tables does it need to consider a database relational?

• 5.0
• 2.0
• 1.0
• 3.0