Basics of Data Base Management System detail syllabus for Textile Technology (Textile Technology), 2021-22 scheme is taken from AKTUs official website and presented for the AKTU B.Tech students. For the course code (KOE067), exam duration, teaching hr/week, practical hr/week, total marks, internal marks, theory marks, duration, credits, and other details do visit complete semester subjects post given below.
For the Textile Technology 7th Sem Syllabus for AKTU B.Tech 2021-22 Scheme you can visit Textile Technology 7th Sem 2021-22 Scheme. For the Open Elective-1 scheme of Textile Technology 7th Sem 2021-22 regulation do refer to Open Elective-1 Textile Technology 7th Sem scheme. The detail syllabus for basics of data base management system is as follows.
Course Outcomes:
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
Unit I
Introduction: An overview of database management system, database system vs file system, database system concepts and architecture, views of data – levels of abstraction, data models, schema and instances, data independence, database languages and interfaces, data definition languages, DML, overall database structure, transaction management, storage management, database users and administrator. Data Modeling using the Entity Relationship Model: ER model concepts, notation for ER diagram, mapping constraints, keys, concepts of super key, candidate key, primary key, generalization, aggregation, reduction of an ER diagrams to tables, extended ER model, relationships of higher degree.
Unit II
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
Unit III
Structured Query Language (SQL): Basics of SQL, DDL, DML, DCL, advantage of SQL, SQL data type and literals, types of SQL commands, SQL operators and their procedure, tables -creation & alteration, defining constraints, views and indexes, queries and sub queries, aggregate functions, built-in functions, insert, update and delete operations, joins, unions, intersection, minus, transaction control commands. PL/SQL: Introduction, features, syntax and constructs, SQL within Pl/SL, DML in PL/SQL Cursors, stored procedures, stored function, database triggers, indices
Unit IV
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
Unit V
Database Security – Types of security, system failure, backup & recovery techniques, authorization & authentication, system policies, levels of security – physical, OS, network & DBMS, privileges – grant & revoke. Recent Trends in Database Management Systems: Centralized and Client-Server Architectures, Distributed Databases, Object-Oriented Database, Spatial & Temporal Databases, Decision Support Systems, Data Analysis, Data Mining & Warehousing, Data Visualization, Mobile Databases, OODB & XML Databases, Multimedia & Web Databases, Spatial and Geographical Databases, Web and Mobile Databases, Active Databases
Text Books:
- Elmasri, Navathe, ‘Fundamentals of Database System’, Addision Wesley.
- Korth, Silbertz, Sudarshan, ‘Database Concepts’, Mc Graw Hill.
- Bipin C. Desai, ‘An Introduction to Database System’, Galgotia Publication.
- Majumdar & Bhattacharya, ‘Database Management System’, McGraw Hill.
- Date C.J., ‘An Introduction to Database System’, Addision Wesley.
- Ramakrishnan, Gehrke, ‘Database Management System’, McGraw Hill.
- Atul Kahate, ‘Introduction to Database Management Systems’, Pearson Education.
- Paul Beynon Davies, ‘Database System’, Palgrave Macmillan.
- Bharti P.K., ‘ An Introduction to Database Systems’, JPNP.
- Rajesh Narang, ‘Database Management System’, PHI.
- Singh, S.K., ‘Database System Concepts – design & application’, Pearson Education.
- Leon & Leon, ‘Database Management Systems’, Vikas Publishing House.
- O’Neil, ‘Databases’, Elsevier Pub.
- Ivan Bayross, ‘SQL, PL/SQL – The Programming Language of Oracle’, BPB Publications.
- P.S. Deshpande, ‘SQL and PL/SQL for Oracle 10g, Black Book’, Dreamtech Press.
- George Koch, Kevin Loney, ‘Oracle: The Complete Reference’, McGraw Hill.
- Coronel, Morris and Rob, ‘Database Principles: Fundamentals of Design, Implementation and Management’, Cengage Learning.
- Gillenson, Paulraj Ponniah, ‘Introduction to Database Management’, Wiley.
- G. K. Gupta, ‘Database Management Systems’, McGraw Hill.
- Shraman Shah, ‘Oracle for Professional’, SPD.
For the syllabus of all the subjects of B.Tech Textile Technology 7th Sem, 2021-22 scheme do visit Textile Technology 7th Sem syllabus subjects.
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.