TAILIEUCHUNG - Database Modeling & Design Fourth Edition- P15

Database Modeling & Design Fourth Edition- P15: 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. | Conceptual Data Modeling 57 include Employee Task Project Department Company Customer and so on. Multivalued Attributes Classify multivalued attributes as entities. If more than one value of a descriptor attribute corresponds to one value of an identifier the descriptor should be classified as an entity instead of an attribute even though it does not have descriptors itself. A large company for example could have many divisions some of them possibly in different cities. In that case division could be classified as a multivalued attribute of company but it would be better classified as an entity with divisionaddress as its identifier. If attributes are restricted to be single valued only the later design and implementation decisions will be simplified. Attribute Attachment Attach attributes to the entities they most directly describe. For example office-building-name should normally be an attribute of the entity Department rather than the entity Employee. The procedure of identifying entities and attaching attributes to entities is iterative. Classify some data elements as entities and attach identifiers and descriptors to them. If you find some violation of the preceding guidelines change some data elements from entity to attribute or from attribute to entity attach attributes to the new entities and so forth. Identify the Generalization Hierarchies If there is a generalization hierarchy among entities then put the identifier and generic descriptors in the supertype entity and put the same identifier and specific descriptors in the subtype entities. For example suppose five entities were identified in the ER model shown in Figure Employee with identifier empno and descriptors empname address and date-of-birth Manager with identifier empno and descriptors empname and jobtitle Engineer with identifier empno and descriptors empname high-est-degree and jobtitle 58 CHAPTER 4 Requirements Analysis and Conceptual Data Modeling Technician with identifier .

TỪ KHÓA LIÊN QUAN
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.