Explain the functions of a database

Assignment Help Operation Management

Reference no: EM133650174

Question: You are the senior data administrator at a small to mid-size organization. The IT department director wants you determine the best data configuration which will maximize operational efficiency and effectiveness for the organization based on the following organizational information:

Sales and marketing
- Customer relations management system (data & database not connected to any other system)
- Data resides in a cloud-based solution
Human resources
- Payroll and benefits system (data & database not connected to any other system)
- Data resides in on-premise servers
Building and grounds
- Work order system and inventory system (data & database not connected to any other system)
- Data resides in an on-premise Network Attached Storage (NAS)
Finance and accounting
- Budgeting and capital expenditure system (data & database not connected to any other system)
- Data resides in an on-premise server
Information technology (data & database not connected to any other system)
- Help desk and work order system (data & database not connected to any other system)
- Data resides in an on-premise Storage Area Network (SAN)
Administration
- Separate report interfaces to each system

Your report (paper) must:

Define each data storage term: database, data warehouse, data pool, data lake, and data mart.
Explain the function(s) of a database, a data warehouse, a data pool, a data lake, and a data mart.
Explain the relationship between databases, data warehouses, data pools, data lakes, and data marts.
Identify the most efficient and effective data and database configuration for the organization and explain why your selection is the most efficient and effective.
Identify potential data recovery risks with your solution.

Reference no: EM133650174

Questions Cloud

How should the adaptive leadership toolkit be communicated : How should the adaptive leadership toolkit be communicated to the organization's leadership to help gain buy-in?

What remedy under the ucc would allow such a recovery : This lays out the what and why of business ethics and provides an overview of the book. What remedy under the UCC would allow such a recovery?

How have global factors come into play : How can a company use operations/supply chain management to make them more competitive? Why is cost control so important with competing with other firms

What roles do you play that may conflict : What roles do you play that may conflict with one another currently or in the past? If you can not think of any, how about in the future?

Explain the functions of a database : Explain the functions of a database, a data warehouse, a data pool, a data lake, and a data mart. Explain the relationship between databases, data warehouses

Discuss the role buddhism plays in the western world : Discuss the role Buddhism plays in the Western world (e.g., in the United States), based on your understanding of the readings, research, and experience.

Identify a suitable contractor to build the repair shop : Identify a suitable contractor to build the repair shop and While the identification of the contractor is ongoing, design the repair shop with inputs

Which questions be asked as content elements are inherently : When planning contagious content strategies for top funnel awareness. Which questions be asked as to whether the content elements are inherently shareworthy?

Advise which hco setting this program work best in : Provide a summary description. Don't forget to use a citation for the compliance program. EXAMPLE: Is it a training program? A handbook

User Account

All Pages