tailieunhanh - modern database management 8th edition PHẦN 3

Cá nhân có thể sử dụng cuốn sách này miễn phí này Personal Edition Khái niệm cơ bản của MySQL cho học viên trực quan được cấp phép để sử dụng cá nhân theo Giấy phép Creative Commons. Cá nhân có thể tải về cuốn sách này miễn phí và chia sẻ nó với những người khác. | CHAPTER 3 MODELING DATA IN THE ORGANIZATION when we receive a copy of the bid signed by an officer of the customer. This definition is also a good example to note how one definition can use other entity type names in this case the definition of bid uses the entity type name Customer . For some entity types the definition must specify what history is to be kept about instances of the entity type. For example the characteristics of an ITEM in Figure 3-1 may change over time and we may need to keep a complete history of the individual values and when they were in effect. As we will see in some examples later such statements about keeping history may have ramifications about how we represent the entity type on an E-R diagram and eventually how we store data for the entity instances. Attributes Attribute A property or characteristic of an entity or relationship type that is of interest to the organization. Each entity type has a set of attributes associated with it. An attribute is a property or characteristic of an entity type that is of interest to the organization later we will see that some types of relationships may also have attributes . Thus an attribute has a noun name. Following are some typical entity types and their associated attributes STUDENT Student_ID Student_Name Home_Address Phone_Number Major AUTOMOBILE Vehicle_ID Color Weight Horsepower EMPLOYEE EmployeeJD Employee_Name Payroll_Address Skill In naming attributes we use an initial capital letter followed by lowercase letters. If an attribute name consists of two words we use an underscore character to connect the words and we start each word with a capital letter for example EmployeeJName. In E-R diagrams we represent an attribute by placing its name in the entity it describes. Attributes may also be associated with relationships as described later. Note that an attribute is associated with exactly one entity or relationship. Notice in Figure 3-5 that all of the attributes of DEPENDENT are .

TỪ KHÓA LIÊN QUAN
crossorigin="anonymous">
Đã 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.