ICS Part 2 Chapter 3 Database Design Process Database Distribution Strategies

ICS Part 2 Chapter 3 Database Design Process Database Distribution Strategies and File Organization

ICS Part 2 Chapter 3 Database Design Process Database Distribution Strategies and File Organization 

In this lecture we discuss with Practicals & Animation at the end of lectures : 

1)What Elements are combined produce physical Database Design? 

1. Data Volume & Usage Analysis

2. Data Distribution Strategy 

i) Centralized 

ii) Partitioned 

iii) Replicated 

iv) Hybrid 

3. File Organization 

4. INDEXES 

5. Integrity Constraints 

6) Now So Let's Start For Practical With Example 

Book IT Series

  #ICSPart2 #Chapter3 #Database #Design #Process #DataDistributionStrategy #fileOrganization #index

Next Lecture is most important We Will Start : 

Q: What is FILE ORGANIZATION ? What are different Criteria for selecting a File Organization 

Q: Briefly Describe the implementation phase of database development process. 

Q: Short Questions 

SUPERIOR COLLEGE MANDI BAHAUDDIN #1Trending 

(C) Computer Lecturer: Shahzaib Naz