Relational Schema
Question 1 |
The relation schema describes:
Set of tuples (Records) | |
Set of fields (Column heads/Attributes) | |
Set of associated values | |
Domain of each field |
Question 1 Explanation:
The relation schema describes set of fields (Column heads/Attributes).
Question 2 |
A____is a pictorial depiction of the schema of a database that shows the relations in the databases, their attributes, and primary keys and foreign keys.
Relational query languages | |
Relational algebra
| |
Flow diagram | |
Schema Diagram |
Question 2 Explanation:
In database terms, a schema is the organisation and structure of a database. Both schemas and schemata can be used as plural forms. A schema contains schema objects, which could be tables, columns, data types, views, stored procedures, relationships, primary keys, foreign keys, etc.
A database schema can be represented in a visual diagram, which shows the database objects and their relationship with each other.
A database schema can be represented in a visual diagram, which shows the database objects and their relationship with each other.
Question 3 |
The order of schema ?10?101? and ???0??1 are ___________ and ______________ respectively.
5.3 | |
5.2 | |
7.5 | |
8.7 |
Question 4 |
Logical data independence is the ability to change________schema without having to change_____ Schema
internal; external | |
conceptual; internal | |
conceptual; external | |
internal; conceptual |
Question 4 Explanation:
The three-schema approach provides for three types of schemas with schema techniques based on formal language descriptions:
→External schema for user views
→Conceptual schema integrates external schemata
→Internal schema that defines physical storage structures
→External schema for user views
→Conceptual schema integrates external schemata
→Internal schema that defines physical storage structures
There are 4 questions to complete.