ABSTRACT
As discussed in Chapter 2, Edgar Codd’s premise for the relational database was that data should be arranged in simple two-dimensional, unordered tables. By properly arranging data in this fashion, we can ask questions about the contents of the database (generate queries) in a straightforward way; we essentially ignore the physical way data is actually stored. To begin, we explore the “proper table” idea and then look at functional dependencies (FDs). As Codd suggested, we will not create our database with physically linked records but rather just ensure that our data is in a suitable form. ”e suitable form means that data is normalized, and normalization is achieved by following the notion of FDs.
