ABSTRACT

This chapter introduces the basics of relational database modeling by discussing and explaining all the various parts and pieces making up a relational database model, as well as all the terminology and phrasing. Tables are the most important piece in the puzzle of the relational database model, for which columns in tables are of less significance but still essential to the semantics of the database model as a whole. There are many different types of datatypes, and they can vary often more in name than actual function when examining different datatypes for different database vendors. Complex datatypes are object datatypes, and those available object datatypes vary depending on the database vendor. One-to-one relationships are rare in relational database models in comparison to one-to-many relationships, except for unusual database models.