Advantages of a database - ANSWER - Economies of scale
- Metadata can represent complex relationships
- Query optimization
- Enforcing integrity constraints
- Access Security
- Buffering and Caching
- Indexes
- Backup and Recovery
- Enforcing standards
Database Administrator Responsibilities - ANSWER - Coordinating and monitoring
its use
- Authorizing access to the database
- Security and response times
- Acquiring software and hardware resources
Database Designer Responsibilities - ANSWER - Identifying the data to be stored
- Choosing appropriate structures to represent and store this data
End User - ANSWER Person who requires access to the data, including:
- Casual end users
- Naïve or parametric end users
- Sophisticated end users
- Standalone users
System Anaylst - ANSWER Determines system requirements
Application Programmers - ANSWER Writes programs to the user specifications
DBMS Designers - ANSWER Designs and implements the DBMS modules and
interfaces as a software package
Tool Developers - ANSWER Creates tools and modules for a DBMS
Operators and Maintenance Personnel - ANSWER Responsible for running and
maintenance of hardware and software environment for database system
- Metadata can represent complex relationships
- Query optimization
- Enforcing integrity constraints
- Access Security
- Buffering and Caching
- Indexes
- Backup and Recovery
- Enforcing standards
Database Administrator Responsibilities - ANSWER - Coordinating and monitoring
its use
- Authorizing access to the database
- Security and response times
- Acquiring software and hardware resources
Database Designer Responsibilities - ANSWER - Identifying the data to be stored
- Choosing appropriate structures to represent and store this data
End User - ANSWER Person who requires access to the data, including:
- Casual end users
- Naïve or parametric end users
- Sophisticated end users
- Standalone users
System Anaylst - ANSWER Determines system requirements
Application Programmers - ANSWER Writes programs to the user specifications
DBMS Designers - ANSWER Designs and implements the DBMS modules and
interfaces as a software package
Tool Developers - ANSWER Creates tools and modules for a DBMS
Operators and Maintenance Personnel - ANSWER Responsible for running and
maintenance of hardware and software environment for database system
