P2Pprogrammer 2 programmer

Home > Download > SMU - Question Paper > BSc IT > BT0066

Database Management Systems

This is the collection of Sikkim Manipal University (SMU) question and answers for Database Management Systems . It will help to prepare your examination. All question paper are classified as per semester, subject code and question type of Part A, Part B and Part C with multiple choice options as same as actual examination. SMU question papers includes year 2024, 2023, 2022 Sem I, II, III, IV, V, VI examinations of all subjects.

SMU question test set of old, last and previous year are updated regularly and it is absolutely free to use. Question paper includes Visual basic 6, VB.Net, C#, ASP.Net, Web, Oracle, Database, SQL, Software Engineering, C, C++, OOPS, MBA, MCA, BSC IT I have requested you kindly send me the question paper of Database Management Systems , SMU - Bachelor of Science in Information Technology.

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.

Home > Download > SMU - Question Paper > BSc IT > BT0066