HamroCSIT Logo
HAMRO CSIT
  • Course New
  • Entrance
    • Entrance Preparation
    • MCQ Questions
    • Colleges
    • Entrance Class
    • Entrance Books
    • Free Entrance Video Course
  • Semester
    • First Semester
    • Second Semester
    • Third Semester
    • Fourth Semester
    • Fifth Semester
    • Sixth Semester
    • Seventh Semester
    • Eight Semester
  • Questions
  • Subscription Automated
  • Notices
  • Articles
  • More
    • Ask Question
    • College Ambassadors
    • Financial Support Program
    • Contribute
    • Contact Us
Login Register
Hamro CSIT User Account
  • Sign In
  • Create Account


Shape | Hamro CSIT Shape | Hamro CSIT Shape | Hamro CSIT Shape | Hamro CSIT
Subject

Database Management System

The course covers the basic concepts of databases, database system concepts and architecture, data modeling using ER diagram, relational model, SQL, relational algebra and calculus, normalization, transaction processing, concurrency control, and database recovery.

Subject Image | Hamro CSIT
  • Chapters
  • Syllabus
  • Question Banks
  • Questions
  • Text Book
  • Practical
  • Viva
Page navigation
  • «
  • Current Page 1
  • Page 2
  • Page 3
  • Page 4
  • Last »
  • »
HamroCSIT User
What are desirable properties of transactions? Explain conflict-serializability with example.
Not Answered Database Management System Asked on 2081 Exam
HamroCSIT User

Consider the library database schema containing the tables given below where primary keys are underlined.

USER (UserID, User_name, Address)
USES (UserID, BookID, Issued_date, Returned_date)
BOOK (BookID, Book_name, Author, PublisherID)
PUBLISHER (PublisherID, Publisher_name, Address)

Specify the following queries in both SQL and Relational Algebra on this database schema:
a. Retrieve names of all books issued to the user “Hari”.
b. Retrieve the names of all books published by “ABC publication”.
c. Count the number of books published by the author “Ram”.

Not Answered Database Management System Asked on 2081 Exam
HamroCSIT User
What do you mean by entity type and entity set? Construct an ER diagram for an airline ticket booking system where customers buy airline tickets online. The system should provide discounts on the basis of number of tickets bought. It should also keep records of buyers on the basis of number of times buyer visits the system. It should also filter the unwanted visitors to manage traffic congestion.
Not Answered Database Management System Asked on 2081 Exam
HamroCSIT User
Define specialization. Explain disjoint constraint with example.
Not Answered Database Management System Asked on 2081 Exam
HamroCSIT User
Explain transaction deadlock with example.
Not Answered Database Management System Asked on 2081 Exam
HamroCSIT User
Explain deferred update approach in database recovery.
Not Answered Database Management System Asked on 2081 Exam
HamroCSIT User
Explain relational algebra natural join (*) operation with example.
Not Answered Database Management System Asked on 2081 Exam
HamroCSIT User
Define the terms data, database, DBMS, database system, and database catalog.
Not Answered Database Management System Asked on 2081 Exam
HamroCSIT User
Classify database management systems based on the data model.
Not Answered Database Management System Asked on 2081 Exam
HamroCSIT User
What are informal design guidelines for relational schemas.
Not Answered Database Management System Asked on 2081 Exam
Page navigation
  • «
  • Current Page 1
  • Page 2
  • Page 3
  • Page 4
  • Last »
  • »
Question's Answer
Solution Video
Solution
Share

Share this link via

Or copy link

logoHAMROCSIT

Hamro CSIT is a comprehensive web and mobile platform that provides B.Sc. CSIT students with resources like notes, syllabi, question banks, solved past papers, practical files, and free entrance preparation materials — all in one place.

  • [email protected]
Semester
  • First Semester
  • Second Semester
  • Third Semester
  • Fourth Semester
  • Fifth Semester
  • Sixth Semester
  • Seventh Semester
  • Eighth Semester
Links
  • About Us
  • FAQs
  • Sitemap
  • Privacy Policy
  • Terms and Conditions
  • College Ambassadors
  • Financial Support Program
Hits Counter
20250876
Google Play App Store
Follow Us

Copyright 2026 | HAMROCSIT | All Right Reserved

Official Payment Partner Esewa Logo
HAMROCSIT.COM

Copyright 2024 | HAMROCSIT.COM | All Right Reserved - Nymna Technology