Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    23CB301 Unit1QB

    Uploaded by

    vanithasenthilemail

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    23CB301 Unit1QB

    Uploaded by

    vanithasenthilemail
    4 views2 pages

    Original Title

    23CB301-Unit1QB

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    4 views2 pages

    23CB301 Unit1QB

    Uploaded by

    vanithasenthilemail

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    Unit I

    Part – A Questions

    Computer Science and Engineering (Cyber


    Security)
    23CB301-Database Management Systems and
    Security
    Second
    Q.N CO’s Bloom’s
    Questions Level
    o
    Define Database Management System and its
    1. CO1 K1
    applications.
    2. List the advantages of DBMS CO1 K1
    3. Classify the levels of abstraction. CO1 K1
    4. Define Relational Calculus CO1 K1
    5. What are the operations in relational algebra? CO1 K1
    6. What are referential integrity constraints? CO1 K1
    7. Define SQL and data types supported by SQL CO1 K1
    8. List the DCL Commands used in SQL. CO1 K1
    9. Differentiate Delete and Drop command in SQL. CO1 K1
    10. List few advanced SQL commands. CO1 K1
    11. Define instance and schemas. CO1 K1
    12. List out string functions in SQL CO1 K1
    13. What is a primary key? CO1 K1
    14. Differentiate between Trigger and stored procedure CO1 K1
    15. Define dynamic SQL. CO1 K1
    Part – B

    Explain the Basic architecture of a database sys- CO1 K2


    1.
    tem with neat block diagram. (13)

    What is a data model? Explain various types of CO1 K2


    2. data model for describing the design of a data-
    base at the logical level. (13)

    Compare File Processing System and Data Base CO1 K4


    3
    Management System. (13)

    4. With relevant example to discuss the various CO1 K4


    operations of Relation Algebra. (13)
    5 (i) What is Embedded SQL? Give example. (7) CO1 K2
    (ii) What are aggregate functions? Explain five built-in
    aggregate functions. (6)
    Consider the following relations for a company Database
    Application: CO1 K3
    Employee(Eno, Name, Sex, Dob, Doj, Designation, Basic_Pay,
    Deptno) Department(Dept_no, Name)
    Project(Proj_no, Name, Dept_no)
    Worksfor(Eno, Proj_no, Date, Hours)

    The attributes specified for each relation is self-explanatory.


    However the business rules are stated as follows. A
    department can control any number of projects. But only
    one department can control a project. An employee can
    work on any number of projects on a day. However an
    6. employee cannot work more than once on a project he she
    worked on that day. The primary keys are underlined.
    (i) Identify the foreign keys. Develop DDL to implement the
    above schema. (3)
    (ii) Develop an SQL query to list the department number
    and the number of employees in each department. (3)
    (iii) Develop a view that will keep track of the department
    number, the number of employees in the department,
    and the total basis pay expenditure for each
    department. (3)
    (iv) Develop an SQL query to list the details of employees
    who have marked in more than three projects on a day.
    (4)
    Define Triggers and explain the use of trigger with your own
    CO1 K2
    7. example.

    8. CO1 K2
    What is a view? How can it be created? Explain with an
    example.

    You might also like