COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Subschema
|
|
Logical view
|
|
Physical view
|
|
Schema
|
|
External-level schema
|
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.