TAILIEUCHUNG - An Introduction to Database Systems 8Ed - C J Date - Solutions Manual Episode 2 Part 7

Tham khảo tài liệu 'an introduction to database systems 8ed - c j date - solutions manual episode 2 part 7', kỹ thuật - công nghệ, cơ khí - chế tạo máy phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | points or equivalently the size or duration of the gap between adjacent points. See Section . The following edited extract from reference goes part way to answering this exercise. Begin quote Replacing the pair of attributes FROM and TO by the single attribute DURING in each of the two relvars brings with it a number of immediate advantages. Here are some of them It avoids the problem of having to make an arbitrary choice as to which of two candidate keys should be regarded as primary. For example relvar S_FROM_TO had two candidate keys S FROM and S TO but relvar S_DURING has just one S DURING which we can therefore designate as primary if we wish without any undesirable arbitrariness. Similarly relvar SP_FROM_TO also had two candidate keys but relvar SP_DURING has just one S P DURING which again we can designate as primary if we wish. It also avoids the problem of having to decide whether the FROM-TO intervals in the previous version of the database are to be interpreted as closed or open with respect to FROM and TO. Previously those intervals were implicitly taken to be closed with respect to both FROM and TO. But now . d04 d10 d04 d11 d03 d10 and d03 d11 are four distinct possible representations of the very same interval and we have no need to know which if any is the actual physical representation. See reference for further explanation of the terms open and closed as used here. Yet another advantage is that integrity constraints to guard against the absurdity of a FROM-TO pair appearing in which the TO value is less than the FROM value are no longer necessary because the constraint FROM TO is implicit in the very notion of an interval type. That is constraints of the form FROM TO are effectively replaced by a generic constraint that implicitly applies to each and every individual interval type. Suppose relations r1 and r2 were both to include distinct FROM and TO attributes albeit with different names in each case instead of a single

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.