Chapter 1, Problem 4PE

Explanation of Solution

Refer the section 1.2 in the textbook which describes about the disadvantages of File processing system (FPS).

According to the points discussed in section 1.2, the video uploading site need to construct the relevance to the points.

Data redundancy:

For a video site, there will not be any data redundancy because the database schema contains small number of relationships.

Data inconsistency:

According to this concept, if there is any non-updated metadata of the videos, then it leads to data inconsistency.  But the actual video data would not be consistent.

Data access difficulty:

Normally, the accessing of video is not a problem because, the video is accessed through some predefined interface.

Data isolation:

In the video site, the videos are not updated if new one is created or uploaded...