Database Software
in database software we had to create a simple database on the scenario provided. on of the task was to we had to use at least three different data types in a table.
In database software we learnt how to set up database and tables. Tables organise data into columns and rows. for example in a database containing details about customers, examples of fields would be surname and address etc. Each customer in the database would be a record.
Next thing we done was fields. we had to set up a table by entering the field names that we require.
Now like we knew how to create a simple database we started to work on data types, we needed to set up the data type for each field. The data type determines what type of each of data a field can hold example a number.
The final thing we learnt in this unit was Primary key. In a database primary key it's very important. A primary key is just simply a dield that will uniquely identify a record.