COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Database
|
|
|
Table
|
|
|
Record
|
|
|
File
|
Detailed explanation-1: -Correct option is C)Collection of fields is called records In a database, a record is a group of fields within a table that are relevant to a specific entity. Records are composed of fields, each of which contains one item of information. A set of records constitutes a file.
Detailed explanation-2: -It is often called a DB. A common database can be compared to a filing system which is arranged by fields, records, and files. A field is a specific piece of data, a record is a total set of fields, and a file is a group of records. For example, a phone book can be considered a file with a list of records.
Detailed explanation-3: -A field: Contains data about one aspect of the table subject, such as first name or e-mail address. A field value: Each record has a field value. For example, Contoso, Ltd. or someoneexample.com.
Detailed explanation-4: -Database-is an integrated collection of logically related records or files.
Detailed explanation-5: -What is a record? A record is a group of related data with the same structure. Just like in a traditional spreadsheet, records in a relational database are stored as horizontal rows within a table, and contain values that correspond with that table’s fields, or columns.