Week #5 – Database Management 1.

What
is a database?

A database is an organized collection of structured data, usually stored in a

computer system. It is designed to allow for efficient storage, retrieval, and
management of data in a way that facilitates easy access and manipulation of
information.

In a database, data is typically organized into tables, each of which contains a

specific type of data or information. Each table consists of columns, which represent
different types of information, and rows, which represent individual records or
instances of that information.

Databases are used in a wide variety of applications, from basic spreadsheet

programs to complex enterprise systems. They can be used to store and manage
customer information, financial records, product inventories, and much more. With
the rise of big data and the Internet of Things (IoT), databases are becoming
increasingly important for managing and analyzing large volumes of data generated
by a wide range of sources.

2. Types of databases commonly used in AIS

a. Relational database: This is the most commonly used database in AIS. It stores
data in tables that are related to each other through keys or links. This type of
database is useful for storing structured data such as financial transactions,
customer information, and inventory records.
b. Object-oriented database: This type of database stores data in objects, which
are like containers that hold both data and the instructions to process that data.
Object-oriented databases are useful for complex data structures and data that
requires more flexibility in its management.
c. Multidimensional database: This type of database stores data in a way that
allows for quick analysis and reporting. It is useful for financial reporting and
decision-making, as it enables users to analyze data from multiple angles and
dimensions.
d. Distributed database: This type of database stores data across multiple
locations or servers, but appears to the user as a single database. Distributed
databases are useful for organizations that have

Week #5 – Database Management

 multiple locations or need to share data across different departments or
divisions.
e. NoSQL database: This is a non-relational database that is useful for handling
unstructured data such as social media data, log files, and other types of data
that do not fit into a structured format. NoSQL databases are known for their
ability to handle big data and scale horizontally, making them a good choice for
AIS applications that require large-scale data processing.

3. Relational Databases for AIS

Relational databases are the most commonly used database type in Accounting
Information Systems (AIS). They are designed to store structured data in tables that
are related to each other through keys or links.

Here are some of the key features and benefits of using a relational database in
AIS:

a. Data consistency: Relational databases enforce data consistency by

requiring that data be stored in a structured format. This ensures that data is
accurate and reliable, which is important in accounting and financial
applications.
b. Data integrity: Relational databases use a variety of tools and techniques to
ensure data integrity, including data validation, constraints, and transaction
processing. This helps to prevent data errors and inconsistencies.
c. Querying and reporting: Relational databases provide powerful querying and
reporting tools that enable users to extract and analyze data from multiple
tables. This is useful for generating financial reports, analyzing trends, and
making informed decisions.
d. Security: Relational databases provide robust security features that help to
protect sensitive financial data from unauthorized access or manipulation.
This includes features such as access controls, encryption, and auditing.
e. Scalability: Relational databases can scale to accommodate large amounts of
data, making them suitable for organizations that need to manage large
volumes of financial data.

Week #5 – Database Management

Some examples of popular relational databases used in AIS include Oracle, MySQL,
 and Microsoft SQL Server. These databases are widely used in accounting and
financial applications and offer a range of features and benefits for managing
financial data.

4. Database Management Systems for AIS

Database Management Systems (DBMS) are software applications that allow users to
manage, store, and retrieve data from a database. In Accounting Information Systems
(AIS), DBMS are used to manage financial data, such as transaction records, financial
statements, and inventory data.

Here are some of the key features and benefits of using a DBMS in AIS:

a. Data storage and retrieval: DBMS provide efficient and reliable data storage and
retrieval capabilities, making it easy to manage large volumes of financial data.
b. Data security: DBMS offer robust security features to protect financial data from
unauthorized access or manipulation. This includes access controls, encryption,
and auditing.
c. Data backup and recovery: DBMS provide tools for backing up and restoring
data in case of a system failure or data loss. This ensures that financial data is
protected and can be quickly restored in the event of a disaster.
d. Data integrity and consistency: DBMS enforce data integrity and consistency
by using tools such as constraints, validation rules, and transaction processing.
This ensures that financial data is accurate, reliable, and consistent.
e. Scalability: DBMS can scale to accommodate large volumes of financial data,
making them suitable for organizations that need to manage large amounts of
financial data.

5. Database Design for AIS

Database design is an important aspect of Accounting Information Systems (AIS),

as it determines how financial data is stored and accessed within the system.

Week #5 – Database Management Here are

some key considerations for database design in AIS:

a. Identify data entities: The first step in database design is to identify the key
data entities that will be stored in the database, such as customers,
transactions, and inventory items.
 b. Define relationships: Once the data entities have been identified, it is
important to define the relationships between them. For example, transactions
may be related to customers and inventory items.
c. Normalization: Normalization is a process used to eliminate data redundancy
and ensure data consistency. This involves breaking down data into smaller,
more manageable entities, and organizing it into tables.
d. Choose appropriate data types: It is important to choose appropriate data
types for each field in the database, based on the type of data that will be
stored. For example, dates should be stored as date/time data types, while
text fields should use character data types.
e. Indexing: Indexing is a process used to improve database performance by
creating indexes on frequently searched fields. This helps to speed up data
retrieval and improve system responsiveness.
f. Data security: Data security is an important consideration in database design
for AIS. This includes features such as access controls, encryption, and
auditing.
g. Scalability: Database design should take into account the scalability
requirements of the system, as financial data can grow rapidly over time. This
involves ensuring that the database can scale to accommodate large
amounts of data.

6. Database Administration for AIS

Database Administration (DBA) is a critical role in managing and maintaining databases

used in Accounting Information Systems (AIS). DBAs are responsible for ensuring that
the database is running smoothly, that data is secure and available when needed, and
that the system is optimized for performance.

Week #5 – Database Management Here are some

key tasks involved in database administration for AIS:

a. Database installation and configuration: DBAs are responsible for installing

and configuring the database software, including setting up user accounts,
security settings, and other system configurations.
a. Performance tuning: DBAs must monitor database performance and optimize
the system to ensure that it runs efficiently. This includes tasks such as tuning
database parameters, optimizing queries, and managing indexes.
b. Backup and recovery: DBAs are responsible for creating and managing backup
and recovery procedures to ensure that data can be restored in case of a system
 failure or data loss.
c. Security management: DBAs must ensure that the database is secure and that
access to sensitive data is restricted to authorized users. This includes tasks
such as managing user accounts and access controls, and implementing
encryption and other security features.
d. Monitoring and maintenance: DBAs must monitor the system to detect and
resolve issues, such as database errors, system failures, or other performance
problems. This may involve performing regular maintenance tasks such as
database defragmentation and optimizing disk usage.
e. Capacity planning: DBAs must plan for the future growth of the system by
monitoring usage patterns and predicting future data growth. This includes
planning for hardware upgrades, storage capacity, and other system resources.

7. Conclusion

In conclusion, database management is a critical component of Accounting Information

Systems (AIS). A well-designed and managed database ensures that financial data is
stored securely, accurately, and efficiently, and can be easily accessed when needed.
Relational databases are commonly used in AIS due to their ability to manage complex
data relationships, and a variety of database management systems are available to
meet the specific needs of an organization.

Week #5 – Database Management

Effective database administration is also essential for maintaining database
performance, security, and reliability. This involves tasks such as database installation
and configuration, performance tuning, backup and recovery, security management, and
monitoring and maintenance. By ensuring that these tasks are performed effectively,
DBAs can help to ensure that the database used in AIS meets the needs of the
organization, and that financial data is accurate, reliable, and available when needed.

Overall, database management plays a critical role in ensuring the success of AIS and
in supporting the financial operations of an organization. It is important for organizations
to invest in the appropriate database management tools and resources to ensure that
their financial data is managed effectively and efficiently.