B.E Jadavpur University Information Technology - Database Management Systems (2nd Year First Semester) -2019 model question papers



Download Model question papers & previous years question papers

Posted Date: 11 Feb 2020      Posted By:: Shouvik Maj    Member Level: Silver  Points: 3 (₹ 3)

2019 B.Tech. Information Technology B.E Jadavpur University Information Technology - Database Management Systems (2nd Year First Semester) -2019 Question paper



Course: B.Tech. Information Technology   University/board: Jadavpur University

Are you looking for the old question papers of Jadavpur University Information Technology - Database Management Systems ? Here is the previous year question paper from Jadavpur University. This is the original question paper from the IT Department for second year first semester exam conducted by Jadavpur University in year 2019. Feel free to download the question paper from here and use it to prepare for your upcoming exams.



{Scroll Below to get the PDF Attachment file of the Original Question Paper}

Exam Name- B.E Information Technology Exam
2nd Year- 1st Semester

Subject- Database Management Systems

Total Time- Three Hours
Maximum Marks- 100

Syllabus

Introduction: History of Evolution of DBMS and advantages over traditional file system,
Three-schema architecture of DBMS and Data Independence. Introduction to DDL and
DML. Ideas about different kind of users of DBMS and available databases in market.
Data Model: Introduction to Relational data model and object oriented data model; Keys,
Entity-Relationship Model, Relational Algebra , Tuple and Domain Relational Calculus
Database Design: Conceptual database design, Different types of dependencies, Theory of
normalization, preservation of dependencies, Lossless decomposition, Armstrong's axioms,
Views, Database security,
SQL: Introduction to SQL, Stored Procedures and Triggers, Application development
using SQL and embedded SQL programming
Data Storage and Querying: Physical data structure ,Evaluation of Relational Algebra
expressions; Query equivalence and Query Optimization, Join algorithm(s)
Transaction Management: Transaction Processing, Concurrency control and Recovery
management ,Transaction Model Properties and State , Serializability, Lock-based and
Time-stamped based Protocols, Two-phase Locking
Advanced Topics: Brief introduction to Distributed database systems, Temporal databases,
Object oriented and object-relational database, Data warehousing, Data mining



Attachments:





Return to question paper search

Next Question Paper: B.E Jadavpur University Information Technology - Computer Architecture (2nd Year First Semester) -2019

Previous Question Paper: B.E Jadavpur University Information Technology - Mathematics III (2nd Year First Semester) -2019

Related Question Papers:


  • B.E Jadavpur University Chemical Engineering - Mathematics III (2nd Year First Semester) -2019


  • B.E Jadavpur University Chemical Engineering - Machine Design (2nd Year First Semester) -2019


  • B.E Jadavpur University Chemical Engineering - Machine Design and Drawing (2nd Year First Semester) -2019


  • B.E Jadavpur University Chemical Engineering - Engineering Thermodynamics (2nd Year First Semester) -2019


  • B.E Jadavpur University Chemical Engineering - Elementary Electronics (2nd Year First Semester) -2019


  • Categories


    Submit Previous Years University Question Papers and make money from adsense revenue sharing program

    Are you preparing for a university examination? Download model question papers and practise before you write the exam.


    Looking for University or College admissions in India for 2020 - 2021 Academic Year?

    APPLY NOW
    Top Contributors
    TodayLast 7 Daysmore...

    Awards & Gifts

    Online Members

    More...
     
    SpiderWorks Technologies Pvt Ltd, Kochi - India. © All Rights Reserved.