# PPSC Lecturer Computer Science Test Preparation

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

#### Author: Habibullah Qamar

Its me Habib Ullah Qamar working as a Lecturer (Computer Sciences) in Pakistan. I have an MS(M.Phil) degree in computer sciences with specialization in software engineering from Virtual University of Pakistan Lahore. I have an experience of more than 15 years in the filed of Computer Science as a teacher. Blog Writing is my passion. I have many blogs, This one is special made with the aim of providing 100% Free online coaching and training to the students of under-graduate and postgraduate classes. Most of the students enrolled in computer sciences, information technology, software engineering and related disciplines find it difficult to understand core concepts of programming and office automation. They find difficult in understanding and solving their assignments.