1 / 17

RELATIONSHIPS

RELATIONSHIPS. Generally there are two main database types: flat-file and relational. Flat-file database is a type of database that contains only a single table.

cole-rose
Download Presentation

RELATIONSHIPS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. RELATIONSHIPS Generally there are two main database types: flat-file and relational

  2. Flat-file database is a type of database that contains only a single table.

  3. Relational database contains more than one table, and the tables are related to one another. In a relational database, data can be subdivided into different tables.

  4. Access is a relational database management system. Relationships are used to link tables to one another.

  5. Types of Relationships • ONE-to-ONE • ONE-to-MANY • MANY-to-MANY

  6. One-to-One • for example, you can store general information about students in one table and password and username information in another table that is linked to the first table.

  7. One-to-many • In a one-to-many relationship, a record in one table can have multiple matching records in another table. • One-to-many relationships are the most common relationships in Access databases.

  8. MANY-to-MANY • In a many-to-many relationship, many records in one table can have many matching records in another table

  9. Relationships can be established by linking two fields located in different tables. • The field from the first table, called Primary key field (must be a unique field that can be a key field or Indexed, No duplicate field) links to a corresponding field (called a Foreign key) in the second table.

  10. The Primary key field in the first table and Foreign key in the second table can have different names in their tables, but they must be of the same data type

More Related