Fundamentals Of Database Management Systems For MU Sem 1 F. Y. B.Sc. (Information Technology) Course Code :USIT103 Academic Year 2022-2023 (Paperback, Pankaj B. Brahmankar, Mrs. Bhakti Pushkar Patil, Reviewed by Prof. Jagruti S. Raut)
Author: Pankaj B. Brahmankar, Mrs. Bhakti Pushkar Patil, Reviewed by Prof. Jagruti S. Raut
150 Pages
Language: English
Publisher: Tech-Neo Publications
Description
I Database system : Concept and Architecture, Relational model and Relational database constraints.
Relational Algebra. (Refer Chapter 1)
12
II Conceptual modelling and database design : Data modelling using the Entity Relationship model (ER).
The enhanced entity relationship model. Relational database design by ER and EER model. Practical
database design methodology and use of UML diagrams. (Refer Chapter 2)
12
III Database Design theory and normalization : Basics of functional dependencies and normalization for
relational databases. Relational database design and further dependencies.
(Refer Chapter 3)
12
IV Introduction to SQL : Complex queries, triggers, views, joining database tables and schema
modification. Query Processing and optimization. File structure, hashing and indexing.
(Refer Chapter 4)
12
V Transaction management and concurrency control and recovery : Introduction to transaction
processing concepts and theory. Concurrency control technique. Database recovery technique.
(Refer Chapter 5)
12
Read More
Specifications
Book
Fundamentals Of Database Management Systems For MU Sem 1 F. Y. B.Sc. (Information Technology) Course Code :USIT103 Academic Year 2022-2023
Author
Pankaj B. Brahmankar, Mrs. Bhakti Pushkar Patil, Reviewed by Prof. Jagruti S. Raut
Binding
Paperback
Publishing Date
2022
Publisher
Tech-Neo Publications
Edition
1
Board
MU
Exam
F. Y. B.Sc. (Information Technology)
Semester I - Mumbai University
Standard
MU
Number of Pages
150
Language
English
Subject
Fundamentals of Database
Management Systems
(USIT103)