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

programmer2programmer.net

 Tips
 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#
 ASP.Net
 SQL Server
  Oracle and DBA
 My SQL
  

100% Tested
Ready Academic IT Projects

BE, ME, BTech, BCA, MCA, MBA, Bsc-IT, MS, BIT, ADIT, DOEACC, IGNOU, SMU
readymadeproject.com

Free download of Sikkim Manipal University, SMU previous year, last year, sample question paper for  : [Fundamentals Of Database Management] BC0041. 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.   Fundamentals Of Database Management , BC0041 question paper includes multiple choice options and answer also.

Home Personal Member Forum Source Project Tips Contact
 

   SMU >> BCA >> BC0041

   Fundamentals Of Database Management

This is the collection of Sikkim Manipal University (SMU) question paper for BCA - Fundamentals Of Database Management. 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 Fundamentals Of Database Management 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
        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

  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