PPSC Lecturer Computer science test preparation as per tentative PPSC syllabus for computer science lecturer 2020. Session No 3 is recorded for Database Management System. The syllabus covered in this session is taken and prepared from PPSC Syllabus for computer Sciences Paper for PMS Exam and GAT-Subject Computer Sciences. TheITeducation.com blog and youtube channel is helping the aspirants of PPSC Lecturer for Computer Science. We are providing for preparation in all respects by providing them syllabus, Mcqz, Parts Papers, recommended books and Computer Science MCQs bases Quiz test daily for preparation.
PSC Computer science Lecturer test preparation started 4 days ago when first session was recorded about Object Oriented Programming (First Session OOP was explained in detail. Second Session was bout Database system part 1. These all lectures are being recorded from Official property handouts of Virtual university of Pakistan. Since there is no PPSC lecturer Computer Sciences syllabus is officially declared. We saw the Official PPSC Computer Science syllabus for their PMS exam which we found same for GAT- Subject computer Science.
PPSC Lecturer Computer Science Preparation Session 3 about Database systems Part 2
In today’s Test preparation Session we will discuss Database Concepts as per PPSC and GAT- Subject computer science syllabus mentioned.
1. Relationships and Cardinalities in between Entities 2. Conceptual Database Design 3. Logical Database Design 4. VU LECTURE NO. 14 5. Reading Material 6. Relational Data Model 7.
Introduction to the Relational Data model 8. Mathematical Relations 9. Database Relations 10. VU LECTURE NO. 15 11. Reading Material 12. Database and Math Relations 13. Degree of a Relation 14. VU LECTURE NO. 16 15. Mapping Relationships 16. Binary Relationships 17. Unary Relationship 18. Data Manipulation Languages 19. Relational Algebra 20. VU LECTURE NO. 17 . 21. The Project Operator 22.
VU LECTURE NO. 18 23. Types of Joins 24. Theta Join 25. Equi–Join 26. Natural Join 27. Outer Join: 28. Semi Join 29. Relational Calculus 30. Tuple Oriented Relational Calculus 31.
Domain Oriented Relational Calculus: 32. Normalization 33. VU LECTURE NO. 19 34. Functional Dependency 35. Inference Rules 36. Normal Forms 37. VU LECTURE NO. 20 38. Second Normal Form 39. Third Normal Form 40. Boyce – Codd Normal Form 41. Higher Normal Forms 42. VU LECTURE NO. 21 43. Normalization Summary