- Reduces Data Redundancy, most data items are stored in only one file, which greatly reduces duplicated data.
- Improved data Integrity, when users modify data in the database, they make change to one file instead of multiple files.
- Shared data, The data in a database environment belongs to and is shared, usually over a network, by the entire organization.
- Easier Access, the database approach allows nontechnical users to access and maintain data, providing they have the necessary privileges.
- Reduces Development Time, it often is easier and faster to develop programs that use the database approach.
4. How to use a Simple Query Wizard:
- Select the fields from the Available Fields list you want to be displayed in the resulting query.
- Assign a name to the query, so that you can open it later.
- View the query result on the screen.
Query by example is a feature that has a graphical user interface to assist users with retrieving data.
5. Advantages of object-oriented database:
They can store more type of data, access this data faster, and allow programmers to reuse object.
Four examples of object-oriented database:
- A multimedia database stores images, audio clips, and/or video clips, for example, a GIS database stores maps and other geographic data.
- A groupware database stores documents such as schedules, calendars, manuals, memos, and reports.
- A computer-aided design database stores data about engineering, architectural, and scientific design.
- A hypertext database contains text links to other types of documents. A hypermedia database contains test, graphic, video, and sound.