Database Reference
In-Depth Information
1. Metadata, which literally means “data about data”
2. In network model, root node may have multiple child nodes.
3. In network model, a child node has only one parent node.
4. A schema is the physical layout of tables in a database
5. A back end , responsible for interfacing with the user
6. DDL stands for …………..
7. DCL stands for …………..
8. DML stands for …………..
9. SQL stands for …………..
10. Drop command is used to ………….. a table.
11. Create command is used to ………….. a table.
12. Insert command is used to ………….. data
13. Select command is used to ………….. data1.
Long Answer Type
1. What is data modeling?
2. Expalin various types of Datamodels.
3. What do you understande by architecture of DBMS?
4. Explain database schema levels.
5. What is the role of Schems?
6. What is difference between distributed and centerlized DBMS?
7. Classify DBMS.
8. Explain Database schema levels.
9. Write various advantages or disadvantages of Relational Model.
10. What is database state and instance?
11. What do you mean by data independence?
12. Explain terms DDL, DML,and DCL.
13. What do you mean by interface?
14. What is the role of view level in data abstaction?
(True/ False) (True/ False) (True/ False) (True/ False) (True/ False)
15. What is the difference between Procedural DML and Non-procedural DML?
Chapter 3
DATA MODELING USING E.R. MODEL
3.1 DATA MODELS
