Welcome to www.programmer2programmer.net tips for SMU Question Paper for BT0066


 Microsoft Certification
 Final Year Project Idea
 Connection Strings
 Password Recovery
 SQL Injection
 Encryption & Decryption
 LIVE Academic Project
 Project #1 - VB6, Access
  Project #2 - VB.Net, SQL
 Project #3 - ASP, Access
 Project #4 - ASP.NET, C#
 Project #5 - VB6, SQL
 Project #6 - Stegano
 Project #7 - C
 Project #8 - C++
 Project #9 - JAVA, MySQL
 Project #10- PHP, MySQL
 Project #11- JSP, Oracle
 Project #12- C# Face Exp
 Project #13- Mobile Bank
 Download MBA Project
 MBA Project Topic
 Project Viva Question
  2017 New Projects
 Project Synopsis Download
 University Question Paper, Assignment and Projects
 SMU - Question Paper
 SMU - Assignment
 SMU - Synopsis Projects
 SCDL - Assignment
 IGNOU - Synopsis Projects
 Welingkar - Projects
 Project Report Formats
 Interview Question Answer
 General & HR Round
 Visual Basic 6
 VB.Net & C#
 SQL Server
  Oracle and DBA

100% Tested
Ready Academic IT Projects


Free download of Sikkim Manipal University, SMU previous year, last year, sample question paper for  : [Database Management Systems ] BT0066 . Find question and answer for Part-A 2 marks, Part-B 4 Marks and Part-C 8 marks. Free download of question paper of previous year test.   Database Management Systems , BT0066 question paper includes multiple choice options and answer also.

Home Personal Member Forum Source Project Tips Contact

   SMU >> BSc IT >> BT0066

   Database Management Systems

This is the collection of Sikkim Manipal University (SMU) question paper for BSc IT - Database Management Systems . It will help you to prepare your examination. All questions are classified as per question type like PART - A of 2 marks, PART - B of 4 marks and PART - C of 8 marks same as actual examination. SMU question paper set which includes year 2017, 2016, 2015 SMU question papers of Database Management Systems are updated regularly and it is absolutely free to use. SMU Question paper includes multiple choice question and answer as same as real and original examination. It will help you to study and prepare for your final SMU examination.

Sikkim Manipal University
SMU Question Paper
Latest and Updated
FREE to Download
  1. BCA
  2. MCA
  3. BSc IT
  4. MSc IT
  5. MBA

   Get SMU Assignment   

Course Name
        BSc IT (Bachelor of Science in Information Technology)

Subject Code      
BT0066 (Database Management Systems )

Get Questions        PART - A    PART - B    PART - C

Database Management Systems Syllabus.

Unit 1: Basic Concepts of DBMS
What is Database? ; Database System Applications; Data Independence; Data Modelling for a Database; Entities and their attributes; Relationships and types. Advantages and Disadvantages of DBMS; DBMS Vs RDBMS.

Unit 2: Database System Architecture
The Three Level of the Architecture; The External Level; The conceptual Level; The Internal Level; Mapping. MySQL Architecture; SQL Server 2000 Architecture; Oracle Architecture ;Database Management System Facilities ;Database Management System Structure; Database Manager; Database Administrator; Data Dictionary Distributed Processing. Information and Communications Technology System (ICT); Client / Server Architecture.

Unit 3: Database Models and Implementation
Data Models; Relational Data Model; Hierarchical Model; Network Data Model; Object/Relational Model; Object-Oriented Model. Entity-Relationship Model; Modelling using E-R Diagrams; Notation used in E-R Model; Relationships and Relationship Types. Associative Database Model.

Unit 4: Full Organization for Conventional
DBMS Storage devices and its characteristics; Magnetic Disks; Physical Characteristics of Disks; Performance Measures of Disks; Optimization of Disk-Block Access; File Organization; Fixed-Length Records; Variable-Length Records; Organization of records in files: Sequential file Organization, Indexed Sequential Access Method (ISAM),Virtual Storage Access Method (VSAM).

Unit 5: An Introduction to RDBMS
An informal look at the relational model; Relational Database Management System RDBMS Properties; Overview of Relational Query Optimization; System Catalog in a Relational DBMS; Information Stored in the System Catalog; How Catalogs are Stored.

Unit 6: An Introduction to SQL
Categories of SQL Commands; Data Definition; Data Manipulation Statements: SELECT - The Basic Form, Sub queries, Functions, GROUP BY Feature, Updating the Database; Data Definition Facilities; Views; EMBEDDED SQL: Declaring Variables and Exceptions, Embedding SQL Statements. Transactions: Consistency and Isolation,

Unit 7: Relational Algebra Basic
Operations; Union; Difference ( - );Intersection ();Cartesian Product (x).Additional Relational Algebraic Operations; Projection (); Selection (); OIN ();Division ().

Unit 8: Relational Calculus
Tuple Relational Calculus; Semantics of TRC Queries; Examples of TRC Queries; Domain Relational Calculus; Relational ALGEBRA vs. Relational CALCULUS.

Unit 9: Normalization
Functional Dependency; Anomalies in a Database; Properties of Normalized Relations; First Normalization; Second Normal Form Relation; Third Normal Form; Boyce-Codd Normal Form (BNCF);Fourth and Fifth Normal Form.

Unit 10: Distributed Databases
Structure of Distributed Database; Tradeoffs in Distributing the Database; Advantages of Data Distribution; Disadvantages of Data Distribution; Design of Distributed Databases; Data Replication; Data Fragmentation.

Unit11: Introductions to Object Oriented Database Management System
What is Next Generation Data Base System? New Database Application; what is Object Oriented Database Management System? Features of Object Oriented System; Advantages of Object Oriented Database Management System; Deficiencies of Relational Database Management System; Difference between Relational Database Management System and Object Oriented Database Management System; Alternative Objective Oriented Database Strategies.

  Get Questions        PART - A    PART - B    PART - C

 Click here to get more question paper of MCA, BCA, BSC IT, MSC IT, MBA of SMU

(C) Atanu Maity, 2006-2017