Different+database+structure

=Different database structure=

By Tanweer/ Waqar
Primary key A field that identifies a record in a table. In a students table, for instance, a key built from last name + first name might not give you a unique identifier. To identify each student, you might add a special Student ID field to be used as the primary key.

Relational database A ** database ** consisting of more than one ** table .** In a multi-table database, you don’t only need to define the structure of each table you also need to define the relationships between each table in order to link those tables correctly.

**Database **

Database is often used interchangeably with the term table (Lotus Approach, for instance, uses the term database instead of table). Technically, they are different. A table is a single store of related information a database can consist of one or more tables of information that are related in some way. For instance, you could track all the information about the students in a school in a students table. If you then created separate tables containing details about teachers, classes and classrooms, you could combine all four tables into a timetabling database. Such as multi-table database is called a relational database.

Flat file A database that consists of a single table. Lightweight database programs such as the database component in Microsoft Works are sometimes called 'flat-file managers’ because they can only handle single-table databases. More powerful programs, such as FileMaker Pro, Access, Approach and Paradox, can handle multi-table databases, and are called relational database managers