TAILIEUCHUNG - Database Modeling & Design Fourth Edition- P9

Database Modeling & Design Fourth Edition- P9: Database technology has evolved rapidly in the three decades since the rise and eventual dominance of relational database systems. While many specialized database systems (object-oriented, spatial, multimedia, etc.) have found substantial user communities in the science and engineering fields, relational systems remain the dominant database technology for business enterprises. | Advanced ER Constructs 27 Project are considered many the entity Manager is considered one. This is represented by the following assertions. Assertion 1 One engineer working under one manager could be working on many projects. Assertion 2 One project under the direction of one manager could have many engineers. Assertion 3 One engineer working on one project must have only a single manager Each engineer working on a particular Functional dependency project has exactly one manager but each manager of a project may manage project-name emp-id mgr-id many engineers and each manager of an engineer may manage that engineer on many projects. c One-to-many-to-many ternary relationship Employees can use many skills on any one of many projects and each project has many employees with various skills. Functional dependencies None d Many-to-many-to-many ternary relationship Figure continued 28 CHAPTER 2 The Entity-Relationship Model Assertion 3 could also be written in another form using an arrow - in a kind of shorthand called a functional dependency. For example emp-id project-name - mgr-id where emp-id is the key unique identifier associated with the entity Engineer project-name is the key associated with the entity Project and mgr-id is the key of the entity Manager. In general for an n-ary relationship each entity considered to be a one has its key appearing on the right side of exactly one functional dependency FD . No entity considered many ever has its key appear on the right side of an FD. All four forms of ternary relationships are illustrated in Figure . In each case the number of one entities implies the number of FDs used to define the relationship semantics and the key of each one entity appears on the right side of exactly one FD for that relationship. Ternary relationships can have attributes in the same way that many-to-many binary relationships can. The values of these attributes are uniquely determined by some combination of the keys of the .

TỪ KHÓA LIÊN QUAN
TÀI LIỆU MỚI ĐĂNG
65    137    1    24-12-2024
TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã 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.