Computer Science – Databases | e-Consult
Databases (1 questions)
Login to see all questions.
Click on a question to view the answer
Field: A field is a single piece of data about an entity. It represents a specific attribute or characteristic. Think of it as a column in a spreadsheet. Fields store individual pieces of information.
Record: A record is a collection of related data about a single entity. It represents a complete set of information for one instance of the entity. Think of it as a row in a spreadsheet. A record is formed by combining multiple fields.
Example: Consider a database of students. In this database:
- Fields would be things like 'Name', 'Age', 'Course', 'Address'. Each of these represents a distinct piece of information.
- A Record would be the complete set of information for one student, such as: Name = 'Bob Johnson', Age = 17, Course = 'Physics', Address = '456 Oak Ave'. This is a collection of values for all the fields related to that specific student.