CS403

Midterm & Final Term
Short Notes

Database Management System Lectures: 45


Past Papers Mcq's

Mid Term Important Mcqs From Lec 01 to 22 (Past Papers included) Download PDF


Final Term Important Mcqs From Lec 23 to 45 (Past Papers included) Download PDF


Final Term Important Mcqs From Lec 01 to 45 (Past Papers included) Download PDF

Past Papers Subjective

Mid Term Important Subjective From Lec 01 to 22 (Past Papers included) Download PDF


Final Term Important Subjective From Lec 23 to 45 (Past Papers included) Download PDF


Final Term Important Subjective From Lec 01 to 45 (Past Papers included) Download PDF


Lectures:

1 Lecture - Introduction to the course 2 Lecture - Difference between Data and Information 3 Lecture - Database Architecture 4 Lecture - Internal or Physical View / Schema 5 Lecture - Database Development Process 6 Lecture - Detailed Data Flow Diagram 7 Lecture - Entity-Relationship Data Model 8 Lecture - Attributes 9 Lecture - Relationships 10 Lecture - Roles in Relationships 11 Lecture - Inheritance Is 12 Lecture - Steps in the Study of system 13 Lecture - Identification of Entity Types of the Examination System 14 Lecture - Relational Data Model 15 Lecture - Database and Math Relations 16 Lecture - Mapping Relationships 17 Lecture - The Project Operator 18 Lecture - Types of Joins 19 Lecture - Functional Dependency 20 Lecture - Second Normal Form 21 Lecture - Normalization Summary 22 Lecture - The Physical Database Design Considerations and Implementation 23 Lecture - Physical Record and De-normalization 24 Lecture - Vertical Partitioning 25 Lecture - Rules of SQL Format 26 Lecture - Categories of SQL Commands 27 Lecture - Alter Table Statement 28 Lecture - Attribute Allias 29 Lecture - Data Manipulation Language 30 Lecture - ORDER BY Clause 31 Lecture - Inner Join 32 Lecture - Application Programs 33 Lecture - Designing Input Form 34 Lecture - Data Storage Concepts 35 Lecture - File Organizations 36 Lecture - Hashing 37 Lecture - Index 38 Lecture - Ordered Indices 39 Lecture - Introduction to Views 40 Lecture - Introduction to Views part-2 41 Lecture - Updating Multiple Tables 42 Lecture - The Concept of a Transaction 43 Lecture - Incremental Log with Deferred Updates 44 Lecture - Uncommitted Update Problem 45 Lecture - Locking Idea
CS403 is a course offered by Virtual University that focuses on the fundamentals of computer architecture and assembly language programming. The course is designed to give students an understanding of the basic principles of computer architecture, the organization of the CPU, and the programming of assembly language. The course covers a wide range of topics, including the basics of computer architecture, assembly language programming, memory hierarchy, input/output operations, interrupts, and system buses. The course also includes discussions on the role of compilers and interpreters in computer programming and the fundamentals of operating systems. The book for CS403 covers all the topics discussed in the course in a comprehensive and detailed manner. The book is divided into several chapters, each of which covers a specific topic related to computer architecture and assembly language programming. The chapters are well-organized, and each topic is presented in a clear and concise manner, making it easy for students to understand the concepts and principles. The book includes numerous examples, exercises, and problems that help students to apply the concepts and principles learned in the course. The exercises and problems are designed to challenge students and test their understanding of the material. The book also includes solutions to the exercises and problems, making it easy for students to check their work and learn from their mistakes. Overall, the book for CS403 is an excellent resource for students who are interested in learning about computer architecture and assembly language programming. It is well-written, comprehensive, and easy to understand, making it an ideal resource for both beginners and advanced learners.