COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Record
|
|
Table
|
|
Field
|
|
None of the above
|
Detailed explanation-1: -Database-is an integrated collection of logically related records or files. A database consolidates records previously stored in separate files into a common pool of data records that provides data for many applications. The data is managed by systems software called database management systems (DBMS).
Detailed explanation-2: -A record: Contains specific data, like information about a particular employee or a product. 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-3: -A database is a collection of organized tables. Each table is a collection of related records. Each record gives information about one item and is made up of many fields.
Detailed explanation-4: -A record is a collection of related fields. An Employee record may contain a name field(s), address fields, birthdate field and so on. A file is a collection of related records. Tables are also called datasheets.