MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

DATABASE MANAGEMENT SYSTEM

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A description of the data elements in a database, the relationships among them, and the logical model used to organize and describe the data.
A
Subschema
B
Logical view
C
Physical view
D
Schema
E
External-level schema
Explanation: 

Detailed explanation-1: -A database schema defines how data is organized within a relational database; this is inclusive of logical constraints such as, table names, fields, data types, and the relationships between these entities.

Detailed explanation-2: -A schema is defined as: description of data elements in a database, relationships among them, and logical model used to organize and describe data.

Detailed explanation-3: -A data model describes the data and relationships that will be stored in the database.

Detailed explanation-4: -Every data element in a database is stored in a column of a table, and each column is defined to have a data type. The data type places limits on the types of values you can put into the column and the operations you can perform on them.

Detailed explanation-5: -Often referred to as data that describes other data, metadata is structured reference data that helps to sort and identify attributes of the information it describes.

There is 1 question to complete.