Software Development Unit 2 Databases. What is a database?. A collection of data organised in a manner that allows access, retrieval and use of that data. Data is a collection of unprocessed items, which can include text, numbers, images, audio and video.
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
The 3 main functions of a database are: valuable assets, because data is used to generate information.
An electronic database allows you to define the data including its:
Allows you to:
Allows you to
A DBMS is the program that creates the database and can manipulate the data within it.
A database defines each field by a number of characteristics such as field size and data type.
Example: of ways (relationships
2. The of ways (relationshipsmost common relationship is a one-to-many relationship.
Example of ways (relationships
3. A of ways (relationshipsmany-to-many relationship means that for each record in the first table, many records are required in the second table AND for each record in the second table, many records are required in the first table.
Validation of ways (relationships
Sorting of ways (relationships
Searching of ways (relationships
Reporting of ways (relationships
Data Entry Screens of ways (relationships
1. Backing up the data on a regular basis – making a copy of the entire database.
- Data can be backed up daily, weekly, monthly or continuously.
2. Attempting to eliminate factors that cause accidental losses.
3. Preventing of ways (relationshipsunauthorised access to data which can result in it being stolen, misused or corrupted eg