INT306:DATABASE MANAGEMENT SYSTEMS
L:0 T:0 P:5
Course Outcomes:
• develop skills and understanding in the database design and make use of database
management systems for applications
• develop understanding about relational algebra, relational model and SQL for
implementing and maintaining databases
• develop understanding about the different issues involved in the design and
implementation of a database system
Unit I
Introduction to Databases : purpose of database systems, components of dbms,
applications of dbms, three tier dbms architecture, data independence, database
schema, instance, data modeling, entity relationship model, relational model
Unit II
Relational Query Languages : relational algebra, introduction to data definition
language, data manipulation, data control and transaction control language, integrity
constraints, database keys, sql basic operations, aggregate functions, sql joins, set
operators, views, subqueries
Unit III
Relational Database Design : data integrity rules, functional dependency, need of
normalization, first normal form, second normal form, third normal form, boyce codd
normal form, multivalued dependencies, fourth normal form, join dependencies, fifth
normal form and pitfalls in relational database design
Unit IV
Database Transaction Processing : transaction system concepts, desirable
properties of transactions, schedules, serializability of schedules, concurrency control,
recoverability
Unit V
Programming Constructs in Databases : flow control statements, functions,
stored procedures, cursors, triggers, exception handling
Unit VI
File Organization and Trends in Databases : file organizations and its types,
indexing, types of indexing, hashing, hashing techniques, introduction to big data,
nosql systems
Text Books:
1. DATABASE SYSTEM CONCEPTS by HENRY F. KORTH, ABRAHAM SILBERSCHATZ,
S. SUDARSHAN, MCGRAW HILL EDUCATION
References:
1. DATABASE SYSTEMS: MODELS, LANGUAGES, DESIGN AND APPLICATION
PROGRAMMING by RAMEZ ELMASRI, SHAMKANT B. NAVATHE, PEARSON
2. AN INTRODUCTION TO DATABASE SYSTEMS by C. J. DATE, S. SWAMYNATHAN,
A. KANNAN, PEARSON
3. SQL, PL/SQL: THE PROGRAMMING LANGUAGE OF ORACLE by IVAN BAYROSS,
BPB PUBLICATIONS
4. SIMPLIFIED APPROACH TO DBMS by PRATEEK BHATIA AND GURVINDER SINGH,
KALYANI PUBLISHERS
- Home-icon
- B TECH NOTES
- _Computer Science
- _Electronics
- _Civil Engineering
- _Mechanical
- _CAs (Class Tests)
- Btech Materials
- _Mid Term Q. papers
- _End Term Q.papers
- _Projects
- Most Viewed
- Blogging Buzz
- _Blogger themes
- _Wordpress
- __Templates
- __Plugins
- _Event Blogging
- _SEO/Keyword Research
- Full Stack WebD
- _Php/Laravel Scripts
- _Start Online Business
- Android Stuff
- _App Reviews
- _Gadgets Reviews
- _Android Development
- JOBS
1 Comments
Thanks for your interesting ideas.the information's in this blog is very much useful for me to improve my knowledge.
ReplyDeleteSelenium Training in Chennai
selenium training in tambaram
JAVA Training in Chennai
Python Training in Chennai
Hadoop Training in Chennai
IOS Training in Chennai
Selenium Training in Chennai
Selenium Training in OMR
Drop a suggestion at : codebuzzweb.com/p/contact-us.html
Upload Q.papers, notes, ppts : upload.codebuzzweb.com