ITE014 MOD 1

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

attribute

• properties or characteristics of an entity
• a single data block represents a specific number of bytes on the physical hard disk
• result of combining, comparing and performing calculations on data
• represents basic information about an entity

Answer explanation

Attributes provide more information about the entity and help distinguish one entity from another

he proposed the relational model for database systems

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

model that creates a diagram of entity relationships from business specifications or narratives

• flat file
• single table
• conceptual data model
• entity relationship model

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

when was the concept of relational database porposed?

• 1972.0
• 1971.0
• 1927.0
• 1980.0

basic storage structure

• primary key
• column
• row
• table

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

• 5.0
• 2.0
• 1.0
• 3.0

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

• field
• foreign key
• column
• primary key

Each row of data in a table is uniquely identified by a primary key

• True
• False