Database Design Using Entity-Relationship Diagrams by Sikha Bagui

Posted by

By Sikha Bagui

Bagui and Earp's "Database layout utilizing Entity-Relationship Diagrams" is a really good written booklet. it truly is transparent, concise, and good laid out. It additionally meets their meant viewers and reason. From web page xiii of the Preface:

"This booklet is meant for use via database practitioners and scholars for information modeling. it's also meant for use as a supplemental textual content in database classes, platforms research and layout classes, and different classes that layout and enforce databases."

And, from web page xvii of the Introduction:

"This booklet used to be written to help scholars in database periods and to assist database practitioners in knowing find out how to arrive at a distinct, transparent database layout utilizing an entity dating (ER) diagram."

The in basic terms purposes I provide it a score of 4 stars out of 5 rather than 5 stars out of 5 are only a question of flavor. First, there isn't loads of breadth to this fabric. So, i am not all that yes entire publication is warranted (it relatively might be coated in full-fledged database books). moment, the vast majority of the ebook specializes in "Chen-like" ER diagrams simply because they're well-used and implementation autonomous (which is nice reasoning). yet, i am lovely yes that almost all databases are relational these days, so extra insurance within the vein of the final bankruptcy (the Barker-like relational ER version) will be an exceptional factor. If i'll supply the booklet 4 and one part stars, i'd (it's fairly that good). yet, for the reason that i will not, 4 stars must do. if you happen to come to a decision you actually need a supplemental textual content in ER Diagrams, you cannot get it wrong with this booklet.

Show description

Read or Download Database Design Using Entity-Relationship Diagrams PDF

Similar storage & retrieval books

The geometry of information retrieval

Keith Van Rijsbergen demonstrates how varied versions of knowledge retrieval (IR) should be mixed within the related framework used to formulate the final rules of quantum mechanics. the entire usual effects may be utilized to handle difficulties in IR, reminiscent of pseudo-relevance suggestions, relevance suggestions and ostensive retrieval.

Social Networks and the Semantic Web

No matter if we replaced the internet or the internet has replaced us is tough to parent, regardless of the knowledge of hindsight. Social Networks and the Semantic internet offers significant case experiences. the 1st case learn exhibits the probabilities of monitoring a examine neighborhood over the net, combining the data bought from the internet with different facts assets, and studying the implications.

Combinatorial search

With the appearance of desktops, seek thought emerged within the sixties as a space of analysis in its personal correct. Sorting questions bobbing up in desktop technological know-how have been the 1st to be completely studied. yet quickly it used to be discovered that the intrinsic complexity of many different information buildings will be fruitfully analyzed from a seek theoretic standpoint.

Accidental Information Discovery. Cultivating Serendipity in the Digital Age

Unintentional details Discovery: Cultivating Serendipity within the electronic Age offers readers with an attractive dialogue at the methods serendipity―defined because the unintentional discovery of valued information―plays an incredible function in artistic problem-solving. This insightful source brings jointly discussions on serendipity and knowledge discovery, learn in laptop and knowledge technology, and fascinating techniques at the artistic approach.

Extra resources for Database Design Using Entity-Relationship Diagrams

Sample text

The following chapters develop the ER design methodology in a step-by-step manner. 1 If X → Y, can you say Y → X? Why or why not ? 3 Does the following data have to be decomposed? Name Address City State Car Color Year Smith 123 4th St. Pensacola FL Mazda Blue 2002 Smith 123 4th St. Pensacola FL Nissan Red 2001 Jones 4 Moose Lane Santa Clive CA Lexus Red 2000 Katie 5 Rain Circle Fort Walton FL Taurus White 2000 References Armstrong, W. "Dependency Structures of Data Base Relationships," Proceedings of the IFIP Congress, 1974.

The sub-attributes, such as first name, middle initial, and last name, are called simple, atomic, or elementary attributes. 4: An ER Diagram with a Composite Attribute — name Once again, the test of whether or not an attribute will be composite will depend entirely on the circumstances that the database designer encounters — the desire of the "user" for which the database is being built. For example, in one database it may not be important to know exactly which city or state or zip code a person comes from, so an address attribute in that database may not be broken up into its component parts; it may just be called address.

7. Embellish the building entity to include the address of the building, which will be the primary key. 8. Once again, embellish the building entity to include names (and only the names) of the janitorial staff. 9. Add a multi-valued attribute to the building entity. 10. How many attributes can an entity have? [2]The "domain of values" is the set of values that a given attribute may take on. The domain consists of all the possible legal values that are permitted on an attribute. A data type is a broader term used to describe attributes, but "data type" includes the idea of what operations are allowable.

Download PDF sample

Rated 4.60 of 5 – based on 17 votes