无聊的人 发表于 2025-3-26 23:57:21
Normalization,We are doing pretty well at designing a database. So far, you have learned how use cases and a data model can help you understand many of the complexities of the actual problem you are trying to represent. In the previous chapter, you saw how to represent the main parts of the data model in a relational database. To recap:惰性气体 发表于 2025-3-27 04:16:48
http://reply.papertrans.cn/19/1823/182299/182299_32.png商业上 发表于 2025-3-27 07:37:24
http://reply.papertrans.cn/19/1823/182299/182299_33.pngepicardium 发表于 2025-3-27 12:12:08
http://reply.papertrans.cn/19/1823/182299/182299_34.pngIntersect 发表于 2025-3-27 15:47:13
Yi Ding,Yonghua Song,Changzheng Shaosarily the correct one. Often a table or spreadsheet is designed to mimic a possible data entry screen or a hoped-for report. This practice may be adequate for solving the immediate problem (e.g., storing the data somewhere); however, mimicking a data entry screen or report in your database design oAccommodation 发表于 2025-3-27 17:51:08
Fatih Yilmaz,Yunus Emre Yuksel,Murat Ozturko make sure we really understand the problem. This may sound obvious, but it is surprising how often people set about implementing a database before they understand the problem completely. There are two things we need to do: understand what tasks all the people who will use the system need to carryCanary 发表于 2025-3-28 00:07:23
http://reply.papertrans.cn/19/1823/182299/182299_37.pngfetter 发表于 2025-3-28 04:51:58
https://doi.org/10.1007/978-3-8349-3958-6ry out. Tasks were represented with use cases, and a simple data model was developed to represent the required data. In Chapter 4, you saw that a great deal can be learned about a problem by questioning some of the details of simple relationships, particularly the number of objects involved at each积云 发表于 2025-3-28 07:35:13
Waldemar Cruz,Fanghui Liu,Laurent Michelmight like. We might find that we have some objects for which some of the attributes do not really apply. For example, if we have a class to record information about all the people associated with a company, we might find that some have hourly pay rates while others have annual salaries. In many resglans-penis 发表于 2025-3-28 13:24:15
Eldan Cohen,J. Christopher Beckloped an initial data model. By looking carefully at the details of the model, we were able to develop questions to help understand further subtleties and complexities about the real-world problem. We then looked at a number of situations that occur in many models in the hope that these would be use