Home > Download > SMU - Question Paper > BCA > BC0041

Fundamentals Of Database Management

This is the collection of Sikkim Manipal University (SMU) question and answers for Fundamentals Of Database Management. 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 Fundamentals Of Database Management, SMU - Bachelor of Computer Application.

Course Name        BCA (Bachelor of Computer Application)

Subject Code       BC0041 (Fundamentals Of Database Management)

Get Questions        PART - A    PART - B    PART - C

Fundamentals Of Database Management Syllabus.

Unit 1 Fundamentals of DBMS
Introduction, DBMS & Approaches to Data Management, Advantages of Database Systems, Functions of a DBMS, Role of the Database Administrator, Types of Database
Systems

Unit 2 Physical Storage Structure of Databases
Introduction, Physical Storage Structure, Clustering, Indexing, Self Assessment Questions, Hashing, Linear Search, Collision Chain

Unit 3 Introduction to Relational Model
Introduction, The Relational Model , Properties of Relations, Integrity Rules Relational Algebra Operators

Unit 4 Database Processing
Introduction, Database Architecture, Application Logic, One Tier Architectures, Two Tier Client/Server Architectures, Advantages of Database Processing, Economy of Scale, Efficient extraction of relevant Information, Sharing of Data, Balancing Conflicting Requirements, Environment of Standards, Controlled Redundancy, Consistency , Integrity , Security , Flexibility and Responsiveness, Data Independence, Three Level Architecture of a Database, Services of a Database System, Functions of Database Management Systems

Unit 5 Relational Operators & Standards
Introduction, Relational Model – a Review, Relation, Formal definition of a relation SQL – The Relational database standard, Database Creation, Sorting, Built-in Functions, Joining Tables, Union, Relational Algebra

Unit 6 Database Design
Introduction, Introduction to Database Design, E-R Modeling, Basic Constructs of E-R Modeling , Degree of a Relationship , ER Notation , Normalization, Functional Dependence, First Normal Form, Second Normal Form, Third Normal Form, Boyce-Codd Normal Form, Multi-valued Dependencies and Fourth Normal Form Database Design Goals

Unit 7 Database Security and Authorization
Introduction, Introduction to Database Security Issues , Types of Security, Threats to Databases, Database Security and the DBA, Access Protection, User Accounts, and Database Audits, Discretionary Access Control Based on Granting and Revoking Privileges, Types of Discretionary Privileges, Specifying Privileges Using Views, Revoking Privileges, Propagation of Privileges Using the grant option, Mandatory Access Control and Role-based Access Control or Multilevel Security, Comparing Discretionary Access Control and Mandatory Access, Control, Role-Based Access Control, Access Control Policies for E-Commerce and the Web, Introduction to Statistical Database Security, Introduction to Flow Control, Covert Channels, Encryption and Public Key Infrastructures, The Data and Advanced Encryption Standards, Public Key Encryption, Digital Signatures

Unit 8 ORDBMS and Concepts of Data Mining and Data Warehousing
Introduction, The Evolution of Database Systems Technology, The Informix Universal Server, Categories of INFORMIX Universal Server, Overview of Data Mining Technology,  Goals of Data Mining and Knowledge Discovery. Association Rules, Market-Basket Model, Support, and Confidence, Additional Considerations for Association Rules, Classification, Clustering, Approaches to Other Data Mining Problems , Discovery of Sequential Patterns, Discovery of Patterns in Time Series, Regression, Neural Networks, Genetic Algorithms, Applications of Data Mining, Commercial Data Mining Tools, Data Warehousing, Introduction, Definitions, and Terminology, Characteristics of Data Warehouses, Data Modeling for Data Warehouses, Building a Data Warehouse, Typical Functionality of a Data Warehouse, Data Warehouse versus Views, Problems and Open Issues in Data Warehouses , Difficulties of Implementing Data Warehouses, Open Issues in Data Warehousing

Unit 9 SQL
Introduction, SQL - An Overview, Data Manipulation Language, Data Definition Language , Data Control Language, Implementation of DML Statements, Basics of the SELECT Statement , Conditional Selection , Relational Operators, More Complex Conditions: Compound Conditions / Logical Operators In & Between ,SQL Order of Logical Operations (each operates from left to right) , Using LIKE , Joins , Keys, Performing a Join , DISTINCT and Eliminating Duplicates , Aliases & In / Subqueries, Miscellaneous SQL Statements - Aggregate Functions , Views , Creating New Tables, Altering Tables, Adding Data , Deleting Data , Updating Data , Miscellaneous Topics - Indexes , Group By & Having , More Subqueries, Exists & All , UNION & Outer Joins, Cartesian product

Unit 10 Transaction Processing, Recovery and Concurrency
Introduction, Transactions, Read And Write Operations, Transaction and System Concepts, Transaction and System Concepts, Recovery from System Failures, Concurrency Control Mechanism, Locking, Deadlocks

Home > Download > SMU - Question Paper > BCA > BC0041