Database and Data Dictionary Management - Essay Example

People: the people that use and manage the database system include system administrators, database administrators, database designers, programmers and end users. 2. Procedures: procedures are the rules that govern the use of the database system. 3. Data: data is the raw material stored in the database. It is used to generate information. 4. Hardware: hardware consists of the physical devices that make up the system. Examples of hardware include computers, disk drives, and networks 5. Software: software consists of the programs that run on a computer.

We Will Write A Custom Essay Sample On

For Only $13.90/page

order now

The software that makes up a database system is the operating system, the DB’S, and application programs and utilities The functions of a DB’S are: 1 . Data dictionary management: removes structural and data dependency from the system by storing information about data and relationships in a central location. 2. Data storage management: used for the storage of data and any related data entry forms or screen definitions, report definitions, data validation rules, procedural code, and structures that can handle video and picture formats. 3.

Data transformation ND presentation: transform any data entered into required data structures. 4. Security management: sets rules that determine specific users that are allowed to access the database. 5. Multiuse access control: enables multiple users to access the database simultaneously without affecting the integrity of the database. 6. Backup and recovery management: brought to mind whenever there is potential outside threats to a database. 7. Data integrity management: enforces integrity rules to prevent problems caused by redundant and inconsistent data.