Skip to Main Content
Databases Illuminated, 4th Edition
book

Databases Illuminated, 4th Edition

by Catherine M. Ricardo, Susan D. Urban, Karen C. Davis
March 2022
Intermediate to advanced content levelIntermediate to advanced
682 pages
22h 58m
English
Jones & Bartlett Learning
Content preview from Databases Illuminated, 4th Edition

3.3 Attributes

The attributes of an entity are the defining properties or qualities of the entity type. For the Student entity type, the defining properties might be the student’s ID, name, major, and number of credits accumulated. The attributes are the representation in the model of those properties, namely stuId, lastName, firstName, major, and credits. Normally, an entity instance will have a value for each of its attributes. An attribute is represented in an ER diagram by an oval with the name of the attribute inside. A line connects the attribute oval to the rectangle for the entity set it describes.

Figure 3.1 shows several examples of attributes connected to their entity sets. Just as with entities, different designers may disagree about ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL and Relational Theory, 3rd Edition

SQL and Relational Theory, 3rd Edition

C.J. Date

Publisher Resources

ISBN: 9781284231595