Object-Role Modeling Fundamentals: A Practical Guide to Data Modeling with ORM by Terry Halpin
Author:Terry Halpin [Halpin, Terry]
Language: eng
Format: azw3, pdf
Publisher: Technics Publications
Published: 2015-04-07T16:00:00+00:00
Figure 3.1 An ORM schema for Table 3.1, including value constraints
In principle, value constraints could be declared for CountryCode and CountryName, but the value lists would be very large (about 240 values in each list), and they would be somewhat unstable, since countries sometimes change their name, and over time some countries can be removed from or added to the official lists. So weâll leave the conceptual schema as shown in Figure 3.1. When this is mapped to a relational schema, the code and name fact types for Country map to the table scheme Country(countryCode, countryName) with CountryCode as the primary key, and CountryName as a secondary key. We can now populate this table with the relevant data (e.g. based on country codes and names from the ISO 3166 standard). Such a table may be used in many databases, and is often called a reference table.
Although value constraints may seem fairly trivial, they are useful for picking up data entry errors, especially those that result from accidentally hitting the wrong key. Figure 3.2 provides a more comprehensive sample of value constraint settings for object types. These value constraint settings may also be applied to roles.
Ranges specified as n..m are assumed to be closed, so the end values n and m are included. For example, 0..100 includes 0 and 100 as well as the numbers in between. To exclude the start value n from the range, prepend a left parenthesis, and to exclude the last value m from the range, append a right parenthesis. So a range of the form (n..m excludes n but includes m; a range of the form n..m) includes n but excludes m; and a range of the form (n..m) excludes both n and m. This is useful if the underlying data type is a real number (e.g. float or decimal). On an ORM diagram, ranges are always displayed inside braces. For example, the range displayed as {(0..100} covers the positive (above 0) numbers up to 100. If desired, a square bracket may be used to explicitly indicate inclusion (the default). For example, â(0..100â and â(0..100]â mean the same. You may also combine enumerations and/or ranges into a single constraint, as in Figure 3.2(c).
Download
Object-Role Modeling Fundamentals: A Practical Guide to Data Modeling with ORM by Terry Halpin.pdf
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Windows Terminal Tips, Tricks, and Productivity Hacks by Will Fuqua(1378)
Augmented Reality with Unity AR Foundation by Jonathan Linowes(1157)
Sketching User Experiences by Buxton Bill(582)
Object-Role Modeling Fundamentals: A Practical Guide to Data Modeling with ORM by Terry Halpin(555)
Beginning AutoCAD 2020 Exercise Workbook by Cheryl R. Shrock(533)
You Donât Know JS: Up & Going by Kyle Simpson(514)
Adobe InDesign for Absolute Beginner: Tips and Techniques to Creating Professional Books and Magazines for Online and Desktop Publishing using InDesign by Scott Walter & Scott Walter(456)
SketchUp For Dummies by Bill Fane & Mark Harrison & Josh Reilly(447)
AI 2041: Ten Visions for Our Future by Kai-Fu Lee & Chen Qiufan(447)
Windows 10: The Missing Manual by Pogue David(440)
100 Principles of Game Design by unknow(437)
Advanced Game Design by Michael Sellers(422)
The Rainbow Stack: A Casual Guide to UX Design by Jawara Joseph(407)
Research Methods in Human-Computer Interaction by unknow(407)
Mastering InDesign Templates by Murphy Monica & Knorr Mancini Margot(404)
Hands-On Data Visualization by Jack Dougherty(400)
Photoshop Elements 12 All-in-One For Dummies by Barbara Obermeier & Ted Padova(399)
Connected, Intelligent, Automated: The Definitive Guide to Digital Transformation and Quality 4.0 by Radziwill N. M(379)
TensorFlow 2.0 Computer Vision Cookbook by Jesus Martinez(364)