Normalization in DBMS | Aggregate function | Network vs Hierarchical Model | String fun

Best Hindi Videos For Learning Programming: Subscribe for more videos : Dear all, ProgrammingHUB YouTube channel for computer science students which includes programming like C,C++,core java, advance java , VB.net, C#.net , python etc and web technologies like HTML, JavaScript, PHP , ASP.NET etc and DBMS like oracle , SQL server , mySQL, ms Access Kindly refer following playlist C programing https://youtube.com/playlist?list=PLw-TmyTJYYTAo8yzEMD94Tg_4t-wNMFhs Core java https://youtube.com/playlist?list=PLw-TmyTJYYTAx-TMf85w_k1zN19u53hwj DBMS practical https://youtube.com/playlist?list=PLw-TmyTJYYTAdBO0Q3DsIyTZHNj9Y-sTc JavaScript practical https://youtube.com/playlist?list=PLw-TmyTJYYTBQHUqMETUsmxxJJ5LeuCaR JavaScript theory concepts https://youtube.com/playlist?list=PLw-TmyTJYYTBGIvA2AJ6HfkQkY-JEBXlp DBMS theory concepts https://youtube.com/playlist?list=PLw-TmyTJYYTB0Ngrggg606HQJPMa-Q46j Kindly subscribe channel and forward to computer science and engineering students. Thank You Any Query Contact (8793727493) (what’s app only) 1.       Define Normalization, list its types.( 2 marks). 2.       Explain Aggregate functions in oracle.(4 marks). 3.       Distinguish between network model and hierarchical model.( 4 marks). 4.       Explain any four String functions with example.(4 marks). 5.       Draw an E-R diagram of library management system( 6 Marks) 6.       Consider the following database Employee(emp_id,emp_name,emp_city,emp_addr, emp_dept,join_date) a)  Display the emp_id of employee who live in city    ‘Pune’ or ‘Nagpur’.(2 marks). b) Change the employee name ‘Ayush’ to ‘Ayan’.( 2 marks). c) Display the total number of employee whose dept is 50.(2 marks).         7. a) create user ‘Rahul’ b) grant create, select,insert,update, delete, drop privilege to ‘Rahul’ c) Remove the select privilege from user ‘Rahul’         8. Write a command to                           create table student (rollno, Stud_name,branch, class, DOB, City, Contact_no)                            and write down queries for following:                   (i) Insert one row into the table                   (ii) Save the data                   (iii) Insert second row into the table                   (iv) Undo the insertion of second row                   (v) Create save point S1.                   (vi) Insert one row into the table. Dbms lecture 1 diploma computer : introduction o DBMS https://youtu.be/lR37ri5oU7Q Lecture 2 : schema , abstraction , architecture https://youtu.be/v7ZuH5WRgtE Lecture 3 : database user , database architecture , DBA https://youtu.be/obKoZWo41pA Lecture 4: DDL , DML, DCL https://youtu.be/1Ev9Oy3R8Hs DBMS lecture 5 : integrity constraints : primary key , unique , not null , check , default, foreign key https://youtu.be/qM-fMjDPjMs DBMS lecture 6: paper solution winter 19 https://youtu.be/d8kXPBjxTAw Lecture 7 : normalization , summer 2019 paper solution https://youtu.be/VspIYJQjp JavaScript : CSS Lecture 1: Introduction JavaScript , server and client side scripting. https://youtu.be/bZT7pNe1-uY Lecture 2: Data types , operators , if - else ,switch case ,programs https://youtu.be/i2GLaMAJmro Lecture 3: for , while ,do while loop , programs. https://youtu.be/Qx3CjMSrJS4 Lecture 4: Array and Functions in JavaScript , programs. https://youtu.be/mI4CQ2hj7Bk Lecture 5: Operators and property in JavaScript. https://youtu.be/obwk877HOfc Like | subscribe | Share for more videos

Видео Normalization in DBMS | Aggregate function | Network vs Hierarchical Model | String fun автора DataZen