30 Questions
What is the primary benefit of using primary keys in a relational database?
Ensured data integrity
What is the primary advantage of using SQL in a relational database?
Enhanced data flexibility
Which of the following is NOT a characteristic of a relational database?
Data is stored in a hierarchical structure
What is the primary benefit of using an ERP system?
Integration of organisation's data and financial information
Which of the following ERP modules is responsible for managing customer relationships?
Customer relationship management
What is a disadvantage of implementing an ERP system?
Changes to an organisation's existing business process can be disruptive
What is a benefit of using relational databases in an ERP system?
Greater management visibility
What is a characteristic of relational databases that enables them to handle large amounts of data?
Scalability
What is a benefit of using ERP systems in an organisation?
Standardised business operating procedures
What is a disadvantage of ERP systems?
Complexity
Relational databases enforce data ______ through constraints like primary keys, foreign keys, and unique constraints.
integrity
Relational databases can handle large amounts of data and can scale ______ or vertically to accommodate growth.
horizontally
Relational databases offer robust ______ features such as user authentication, authorization, and encryption.
security
ERP modules include ______ and payroll.
human resources
ERP systems implement ______ Best Practises.
Industry
A disadvantage of ERP systems is that they can be ______ to implement.
time consuming
ERP systems can improve ______ service.
customer
ERP systems can make ______ operating procedures more efficient.
business
Relational databases are based on the ______ model, an intuitive, straightforward way of representing data in tables.
relational
ERP systems can increase ______ visibility and monitoring.
management
Relational databases can handle small amounts of data and can scale vertically to accommodate growth.
False
ERP systems can integrate an organisation's financial information into separate modules.
False
Data security is a disadvantage of using relational databases.
False
ERP systems can implement Industry Worst Practices.
False
Relational databases enforce data redundancy through constraints like primary keys, foreign keys, and unique constraints.
False
ERP systems can make business operating procedures more complicated.
False
Relational databases are based on the hierarchical model, an intuitive, straightforward way of representing data in tables.
False
ERP systems can decrease management visibility and monitoring.
False
Relational databases offer limited flexibility in querying data.
False
ERP systems are only used by small organisations.
False
Study Notes
Relational Databases
- Store and provide access to related data points
- Based on the relational model, representing data in tables
- Advantages:
- Enforce data integrity through constraints like primary keys, foreign keys, and unique constraints
- Allow for complex and flexible queries using SQL
- Can handle large amounts of data and scale horizontally or vertically
- Offer robust security features like user authentication, authorization, and encryption
Enterprise Resource Planning (ERP)
- Integrate an organization's information into one overall system
- ERP modules:
Financial
- Manage financial information
Human Resources and Payroll
- Manage employee data and payroll
Order to Cash
- Manage sales and payment processes
Purchase to Pay
- Manage procurement and payment processes
Manufacturing
- Manage production and inventory
Project Management
- Manage projects and tasks
Customer Relationship Management
- Manage customer interactions and data
System Tools
- Manage system configurations and settings
- Advantages:
- Integrate organization's data and financial information
- Capture data once and reduce redundancy
- Improve management visibility and monitoring
- Enhance access controls and security
- Standardize business operating procedures
- Improve customer service and manufacturing efficiency
- Implement industry best practices
- Disadvantages:
- High costs
- Time-consuming implementation
- Disruptive changes to existing business processes
- Complexity and resistance to change
- Risk of losing competitive advantage due to standardized processes
Documentation of Flowchart
- Set of documents and models (narratives, data flow, models, flowcharts)
- Includes inputs, processes, storage, output, and controls
- Allows auditors to monitor business operations and information
Different Systems
- Document: Illustrates the flow of documents through an organization
- Program: Logical representation of system inputs, processes, and outputs
- System: Actual steps of the activity, detailed to represent the logical sequence
- Context: Highest level, showing inputs and outputs into the system
- Level 0: Shows all major activity steps of a system
- Level 1: Shows one major activity divided into sub-activities
Relational Databases
- Store and provide access to related data points
- Based on the relational model, representing data in tables
- Advantages:
- Enforce data integrity through constraints like primary keys, foreign keys, and unique constraints
- Allow for complex and flexible queries using SQL
- Can handle large amounts of data and scale horizontally or vertically
- Offer robust security features like user authentication, authorization, and encryption
Enterprise Resource Planning (ERP)
- Integrate an organization's information into one overall system
- ERP modules:
Financial
- Manage financial information
Human Resources and Payroll
- Manage employee data and payroll
Order to Cash
- Manage sales and payment processes
Purchase to Pay
- Manage procurement and payment processes
Manufacturing
- Manage production and inventory
Project Management
- Manage projects and tasks
Customer Relationship Management
- Manage customer interactions and data
System Tools
- Manage system configurations and settings
- Advantages:
- Integrate organization's data and financial information
- Capture data once and reduce redundancy
- Improve management visibility and monitoring
- Enhance access controls and security
- Standardize business operating procedures
- Improve customer service and manufacturing efficiency
- Implement industry best practices
- Disadvantages:
- High costs
- Time-consuming implementation
- Disruptive changes to existing business processes
- Complexity and resistance to change
- Risk of losing competitive advantage due to standardized processes
Documentation of Flowchart
- Set of documents and models (narratives, data flow, models, flowcharts)
- Includes inputs, processes, storage, output, and controls
- Allows auditors to monitor business operations and information
Different Systems
- Document: Illustrates the flow of documents through an organization
- Program: Logical representation of system inputs, processes, and outputs
- System: Actual steps of the activity, detailed to represent the logical sequence
- Context: Highest level, showing inputs and outputs into the system
- Level 0: Shows all major activity steps of a system
- Level 1: Shows one major activity divided into sub-activities
Relational Databases
- Store and provide access to related data points
- Based on the relational model, representing data in tables
- Advantages:
- Enforce data integrity through constraints like primary keys, foreign keys, and unique constraints
- Allow for complex and flexible queries using SQL
- Can handle large amounts of data and scale horizontally or vertically
- Offer robust security features like user authentication, authorization, and encryption
Enterprise Resource Planning (ERP)
- Integrate an organization's information into one overall system
- ERP modules:
Financial
- Manage financial information
Human Resources and Payroll
- Manage employee data and payroll
Order to Cash
- Manage sales and payment processes
Purchase to Pay
- Manage procurement and payment processes
Manufacturing
- Manage production and inventory
Project Management
- Manage projects and tasks
Customer Relationship Management
- Manage customer interactions and data
System Tools
- Manage system configurations and settings
- Advantages:
- Integrate organization's data and financial information
- Capture data once and reduce redundancy
- Improve management visibility and monitoring
- Enhance access controls and security
- Standardize business operating procedures
- Improve customer service and manufacturing efficiency
- Implement industry best practices
- Disadvantages:
- High costs
- Time-consuming implementation
- Disruptive changes to existing business processes
- Complexity and resistance to change
- Risk of losing competitive advantage due to standardized processes
Documentation of Flowchart
- Set of documents and models (narratives, data flow, models, flowcharts)
- Includes inputs, processes, storage, output, and controls
- Allows auditors to monitor business operations and information
Different Systems
- Document: Illustrates the flow of documents through an organization
- Program: Logical representation of system inputs, processes, and outputs
- System: Actual steps of the activity, detailed to represent the logical sequence
- Context: Highest level, showing inputs and outputs into the system
- Level 0: Shows all major activity steps of a system
- Level 1: Shows one major activity divided into sub-activities
Explore the concepts and benefits of relational databases, including data integrity and flexibility, and how they store and provide access to related data.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free