DBMS - Database management system Full syllabus in detail.
Unit I Introduction to database system : - database application , evolution of DB and DBMS, Why need data management? Introduction and application of DBMS File system and various database system, Data models, DBMS architecture, Data independence, Data modelling using entity- relationship model, Enhanced er modelling. Unit II relationship database concept and design: introduction to relational database that means RDBMS. structure of relational database relational model terminology attributes tuples relations relational db schema relational algebra basic operation: selection and projection set theoretic operation union intersection set difference and division join operation inner and outer left outer right outer full outer and join relational database design functional dependency definition trivial and nontrivial FD 1NF 2NF 3NF decomposition using fd preservation BCNF Multivalued dependency 4NF Join Dependency and 5NF ...
Comments
Post a Comment