13. Extend Problem 6.7 to create an ERD that captures data about the tape cartridges used in the backup system. Every Sunday night a full backup is made of all network drives. A full backup creates an identical copy of the network drives on the tape cartridges. Due to the large amount of information, a full backup requires many tapes. On the other nights of the week an incremental backup is made. An incremental backup stores only files modified since the last backup (either full or incremental). Incremental back-ups are much smaller than a full backup, and consequently many incremental backups fit on a single tape. A tape contains only full or incremental backup information – the unused portion of the last tape used for a full backup is never used to store incremental backups. Your company wants to keep track of tapes, full backups, and incremental backups. An ID and state should be tracked for each tape. For full backups, the system needs to track the creation date and the number of tapes used. For an incremental backup it should track the date it was made. The relationships between the backup type and the tape will capture which tapes participated in which backup. (Hint: the state of a tape should be an attribute of the tape entity - unformatted, blank, etc. They are not attributes and are possible values for the state attribute.)
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.