{"id":12139,"date":"2022-07-05T05:36:09","date_gmt":"2022-07-05T05:36:09","guid":{"rendered":"https:\/\/www.booksofall.com\/id\/?post_type=product&p=12139"},"modified":"2022-07-05T05:46:20","modified_gmt":"2022-07-05T05:46:20","slug":"relational-databases-and-microsoft-access-mcfadyen","status":"publish","type":"product","link":"https:\/\/www.booksofall.com\/id\/relational-databases-and-microsoft-access-mcfadyen\/","title":{"rendered":"Relational Databases and Microsoft Access (McFadyen)"},"content":{"rendered":"

Relational Databases<\/a> were introduced by E. F. Codd in 1969 ; Codd\u2019s 1970 paper is considered one of the great papers in Computer Science.<\/p>\n

We begin with a very small example: a database with one relation, the list of employees shown in Table . You should notice this looks just like a two dimensional table of rows and columns. The name of the table is Employees, each column of the table has its own title, and each row has the same structure. Each row has a value for employee number, first name, last name, and gender. As tables of data appear in so many places (newspaper articles, text books, web pages, etc.) it is very likely you have seen and used this representation for data previously.<\/p>\n

MS Access is a relational database system for workstations that run the Microsoft Windows operating system. MS Access is typically used by individuals for data they use personally, but in some situations a single MS Access database may be used by a group of people or small department. MS Access databases are stored in a single file that has a file suffix of \u201c.accdb\u201d or \u201c.mdb\u201d. Databases created using MS Access 2007 and later have a file suffix \u201c.accdb\u201d, and databases created using MS Access 2003 or earlier have a file suffix \u201c.mdb\u201d. We will be using databases where the files have names ending in \u201c.accdb\u201d. You need to use MS Access 2007 or later to open these databases.<\/p>\n

The typical MS Access database<\/a> comprises several kinds of database objects such as indexes and tables. Each table represents a kind of entity (persons, places, things, events, etc.), or relationship between entities. For instance, if we are keeping track of departments and courses at our University then we should have two tables:<\/p>\n