Create a database structure

What is a Database? A database is store of data that has been organised (sorted) in some way. Databases of data are held on a computer. Example of a database with stored data. The database below shows you an example of stored medical patients data: Database Structures (Files/Tables, Records, Fields, Data) # Databases are so useful because they store data in a structured way.# When data is structured (organised) it can be manipulated easily and then output in different.ways Files/Tables A collection of records and fields is called a file. Database files are viewed as tables.  Database Records A database record shows all the data about one person or object. Database Fields Database fields hold/store the single items of data that make up a record.

Primary key:

The relation between Tables

Add caption

Flashcards

Steps  of  creating relationship between Tables