BE Civil Engineering Semester 3 (SE Second Year)University of Mumbai

View all notifications

Database and Information Retrieval System Semester 3 (SE Second Year) BE Civil Engineering University of Mumbai Topics and Syllabus

Create free account

      Forgot password?
CBCGS [2017 - current]
CBGS [2013 - 2016]
Old [2000 - 2012]

Topics with syllabus and resources

100.00 Introduction Database Concepts
  • What is a database? ,
  • Characteristics of databases, Example of database,
  • File system V/s Database system, What is DBMS?,
  • Users of Database system, Advantage of using an enterprise database,
  • Concerns when using an enterprise database,
  • Data Independence, DBMS system architecture, Database Administrator
200.00 Entity–Relationship Data Model
  • Introduction, Benefits of Data Modeling,
  • Types of Models,
  • Phases of Database Modeling,
  • The Entity-Relationship (ER) Model,
  • Generalization,
  • Specialization and Aggregation,
  • Extended Entity-Relationship (EER) Model.
300.00 Relational Model and Algebra
  • Introduction , Mapping the ER and EER Model to the Relational Model ,
  • Data Manipulation , Data Integrity ,Advantages of the Relational Model,
  • Relational Algebra , Relational Algebra Queries, Relational Calculus.
400.00 Structured Query Language (Sql)
  • Overview of SQL,
  • Data Definition Commands,
  • Set operations,
  • aggregate function,
  • null values,
  • Data Manipulation commands,
  • Data Control commands,
  • Views-Using Virtual Tables in SQL,
  • Nested and complex queries.
500.00 Introduction to Transactions Management and Concurrency
  • Transaction concept, Transaction states,
  • ACID properties, Implementation of atomicity and durability,
  • Concurrent Executions, Serializability, Recoverability,
  • Concurrency Control: Lockbased , Timestamp-based ,
  • Validation-based protocols,
  • Deadlock handling,
  • Recovery System: Failure Classification, Storage structure,
  • Recovery and atomicity, Log based recovery, Shadow paging
600.00 Graphical User Interface

Murphy ’s Law of G U I Design, Features of G U I, Icons and graphics, Identifying visual cues, clear communication, color selection, GUI standard, planning GUI Design Work.

  • Visual programming :
  • Sharing Data and Code: Working with Projects, Introduction to Basic language, Using inbuilt controls and ActiveX controls, creating and using classes, Introduction to Collections, Using and creating ActiveX Components, dynamic data exchange, object linking and embedding.
  • Creating visual software entities: Working with text, graphics, working with files, file management, serial communication, and multimedia control interfaces.
View in app×