Posts

Showing posts from August, 2019

17CS53 DBMS

Database Management System Module 1 Introduction   Notes                PPT Module2 Relational Algebra   Notes     PPT 3ia Important question click here    Data model       Types of Key & attributes      E r diagram         Sql Command      Aggregate function       Sub query        SQL JOIN   Normal form 1NF, 2NF, 3NF     Assessment 1 1 Explain DBMS advantage, disadvantage,  characteristics 2. explain database user,  DA,  DBA 3. Explain 3 schema architecture 4. explain components environment f DBMS (refer data model link) 5. Explain types of key 6Explain types of attribute 7. Draw Er diagram for company database 8. Explain create and insert command with an examples assignment 2 1 explain the following  order by groupby having between clauses  2 explain 1nf 2nf 3nf  3 explain sub query for insert update delete select  4 explain types of join 5 explain aggregate function 6 explain  views and stored procedures 7 Retriev