Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    DBMS Assignment - 1

    Uploaded by

    IT 04 ADITYA SAGAR PANDEY
    This document contains 20 questions about database management systems. The questions cover topics such as the advantages of DBMS over flat files, entity relationship diagrams, database schemas, SQL commands, data modeling, and extended entity relationship modeling concepts like specialization and generalization. Students are asked to define keys, draw diagrams, explain terms, discuss database architecture, and more. The goal is to assess the student's understanding of fundamental database concepts.

    Copyright:

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

    DBMS Assignment - 1

    Uploaded by

    IT 04 ADITYA SAGAR PANDEY
    29 views2 pages
    This document contains 20 questions about database management systems. The questions cover topics such as the advantages of DBMS over flat files, entity relationship diagrams, database schemas, SQL commands, data modeling, and extended entity relationship modeling concepts like specialization and generalization. Students are asked to define keys, draw diagrams, explain terms, discuss database architecture, and more. The goal is to assess the student's understanding of fundamental database concepts.

    Original Title

    DBMS Assignment -1

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains 20 questions about database management systems. The questions cover topics such as the advantages of DBMS over flat files, entity relationship diagrams, database schemas, SQL commands, data modeling, and extended entity relationship modeling concepts like specialization and generalization. Students are asked to define keys, draw diagrams, explain terms, discuss database architecture, and more. The goal is to assess the student's understanding of fundamental database concepts.

    Copyright:

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

    DBMS Assignment - 1

    Uploaded by

    IT 04 ADITYA SAGAR PANDEY
    This document contains 20 questions about database management systems. The questions cover topics such as the advantages of DBMS over flat files, entity relationship diagrams, database schemas, SQL commands, data modeling, and extended entity relationship modeling concepts like specialization and generalization. Students are asked to define keys, draw diagrams, explain terms, discuss database architecture, and more. The goal is to assess the student's understanding of fundamental database concepts.

    Copyright:

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

    ASSIGNMENT NO.

    01(UNIT-1)
    Course Outcome-1, Session 2023-24
    SUB: Data Base Management Systems (KCS-501)
    Q.1. Explain the disadvantage of Flat Files and advantage of DBMS over Flat File based
    system.

    Q.2 Explain the definition and integrity constraints of following keys:

    a. Super Key
    b. Candidate Key
    c. Primary Key
    d. Foreign Key

    Q.3 Construct the ER diagram of College Database.

    Q.4 Find the relations and its attribute set of above ER diagram.

    Q.5 Explain the different shift operations with example.

    Q.6 Explain the following term with proper example:

    a. Weak Entity Set


    b. Participation Constraint
    c. Overlapping Constraint
    d. Generalization
    e. Specialization
    f. Aggregation.

    Q.7 Find the minimum number of tables needed to represent M, N, P, R1, R2 in Figure and

    what will be the correct attribute set for tables?

    Hint: Relation between M to P is many to one and P to N is one to many.


    Q.8 What is the main difference between logical and physical data independence?

    Q.9 What do you mean by external schema, Conceptual schema and Internal schema?

    Q.10 What are interfaces? Explain in brief.

    Q.11 What do you mean by Data abstraction? Explain its types in details.
    Q.12 What are data models? Also explain their types.
    Q.13 Explain DDL, DML and DCL in detail with the help of suitable examples.

    Q.14 What is the difference between procedural and non-procedural DML?


    Q.15 Discuss the three level architecture of database system. Also discuss the role of Data base
    administrator.
    Q.16 What are schema and instances? Explain physical schema, conceptual schema and
    external schema with a neat diagram.

    Q.17. Write SQL command to create, modify and delete database structures with a Student/
    Department table.

    Q.18 What is extended Entity –Relationship model? Explain specialization and Generalization
    with respect to PERSON database.

    Q.19 Construct an E-R diagram for a Hospital with a set of patients and a set of medical
    doctors. Associate with each patient, a log of various test and examination conducted.

    Q.20 What is extended Entity –Relationship model? Explain specialization and Generalization
    with respect to PEOPLE database.

    You might also like