Page 1 - Home Assignment-Relational Databases
P. 1

Computer Science

                                                    Class – XII



                                        Topic: Relational Databases


                   1.  ___________________ is a freely available open source RDBMS that implements
                       SQL.
                   2.  MySQL provides a dummy table named __________________, with one row and one
                       column but no content.
                   3.  The ___________________ allows us to perform task related to data definition.

                       (DDL/ DML/ TCL/ DCL)
                   4.  _____________________ are words that have a special meaning in SQL.
                       (Keyword/ Literal/ Variable)
                   5.  What is DBMS?
                   6.  Discuss following advantages of DBMS software
                          a.  Redundancy is reduced
                          b.  Data consistency is maintained
                          c.  Data independence is maintained
                          d.  Data integrity is maintained
                   7.  Who all are the different users of a DBMS software?
                   8.  What is data model? What is its importance? Write key features of relational data

                       model?
                   9.  Define following terms. Give one example for each
                          a.  Database
                          b.  Table/Relation
                          c.  Field/Attribute
                          d.  Tuple/Record
                          e.  Degree
                          f.  Cardinality

                   10. Define domain with respect to a table. Give an example.
                   11. Define following terms. Give a suitable example of each key from a table containing
                       some meaningful data.
                          a.  Candidate key
                          b.  Primary key
                          c.  Alternate key
                          d.  Foreign key
                   12. What is SQL? Discuss any four advantages of SQL.
                   13. What are DDL and DML statements?
                   14. Categories following as DDL, DML, DCL and TCL commands:
                       Create, select, update, alter, revoke, commit, insert, truncate, rename, delete, grant,

                       drop, rollback, savepoint, set transaction
   1