Question
State whether the following are True or False. 1) The external schema defines how and where data are organised in physical data storage. 2) A
State whether the following are True or False.
1) The external schema defines how and where data are organised in physical data storage.
2) A schema separates the physical aspects of data storage from the logical aspects of data representation.
3) The conceptual schema defines a view or views of the database for particular users.
4) A collection of data designed to be used by different people is called a database.
5) In a database, the data are stored in such a fashion that they are independent of the programs of people using the data.
6) Using a database redundancy can be reduced.
7) The data in a database cannot be shared.
8) Security restrictions are impossible to apply in a database.
9) In a database data integrity can be maintained.
10) Independence means that the three levels in the schema (internal, conceptual and external) should be independent of each other so that the changes in the schema at one level should not affect the other levels.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started