Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

RDBMS Terms, etc.

Followers

April 12, 200124 yr

Earlier, someone was asking about Filemaker terms versus other databases. I recently started researching this and have gleaned that there are actually 3 sets of terms: the FMP terms, other Relational Database Management System terms (Oracle, Access, SQL, etc) and then the general terms used in relational data modeling theory. I hope the info below holds it's format well enough so you can see it. If anyone has any corrections, please post.

In FMP----------Other RDBMS----------Relational Theory

File---------------Table----------------------Entity

Field-------------Column-------------------Attribute

Records---------Rows---------------------Tuples

Relationships--Joins---------------------Links

Layout------------Object--------------------Element

Find---------------Query---------------------Query

Security Groups----------------------------Roles

Also, some other useful terms I've run across in my readings:

RDBMS