Categories

Newsletter

News and Updates

Database Management Systems Maximize

Database Management Systems

TP SOLVED SERIES

More details

RTMNU2018/BCCA/TPSS/03/04

82.00 Rs

82.00 Rs per Series

» Add to my wishlist

4 other products in the same category:

For
 
[Bachelor of Commerce (Computer Application)]
 
Part-II, Third Semester Students of
 
 ‘Rashtrasant Tukadoji Maharaj Nagpur University (RTMNU)’
 
 
Edition 2018
 

Syllabus
 
Database Management System (3T4)
 
UNIT – I 
Introduction: Concept of the System, Types of Decisions, Information System, Classification of information System, Conventional File Processing System, Database System, Components of Database Management System, Economic Justification of Database Approach. Database Concepts: Introduction, Data, Information, Metadata, Terminologies of Files, Association between Fields, Association between Files (Record Types), File Organization. Data Structure: Introduction, Location Methods, Types of Pointer, Inter record Data Structure.
 
UNIT – II 
Data Models: Introduction, Classification of Data Model, Entity Relationship Model. Database Design: Introduction, Steps of Database Design, Normalization, Case Problem, Data Volume and Usage Analysis, Integrated Case Study-Database Design for Academic institution. Implementation Design: Introduction, Implementation Design, Guidelines for Mapping Conceptual Data Model into a Desired Logical Data Model, Problem Design Guidelines.
 
UNIT – III 
Structured Query Language - I: Table Fundamentals, Viewing data in the Tables, Eliminating Duplicate Rows when Using a Select Statements, Sorting Data in a Table, Creating a Table From a Table, Inserting Data into a Table from Another Table, Delete Operations, Updating the Contents of a Table, Modifying the Structure of Tables, Renaming Tables, Truncating Tables, Destroying Tables, Creating Synonyms.
 
UNIT-IV
Structured Query Language - II: Data Constraints, Types of data Constraints, Defining Different Constraints on a Table, Computations Done on Table Data, ORACLE Functions, Date Conversion Functions, Data Functions, Miscellaneous Functions, Grouping Data from Tables in SQL, Sub Queries, Joins, Concatenating Data From Table Columns, Using the UNIONS, INTERSECT and MINUS Clause.
 

No customer comments for the moment.

Write your review

Database Management Systems

Database Management Systems

TP SOLVED SERIES

Write your review