Software Applications

Question 1

As organizations expand their operational systems to include new software applications and services, the number of system resource requests will increase relationally. On the human resource side, as the number of employees increases, the number of user requests (both internally and externally) increases as well.

Considering the impact of service and user requests on an organization’s operational systems, the organization must build a database capable of supporting the current workload, with room for growth.

To complete this assignment, answer the following questions in a minimum of 2 pages (not counting title page and references page):

• What are the main scaling strategies for database systems?
• How do the hardware requirements differ in each architecture?
• What are the benefits of relational database and non-relational database structures? Use APA formatting style (title page, references page, and in-text citations)

Question 2

Pick and define 10 key terms from the given list below. The length of each term definition should be between 50-80 words. Define the terms in the context of database management and use examples when appropriate or needed.

1. Database-management system(DBMS) 
2. File-processing systems 
3. Data inconsistency
 4. Consistency constraints 
5. Data abstraction 
6. Instance 
7. Schema
 8. Physical data independence 
9. Data models 
10. Database languages 
11. Metadata 
12. Application program 
13. Normalization
 14. Data dictionary 
15. Storage manager 
16. Query processor 
17. Transactions 
18. Two- and three-tier database architectures 
19. Data mining 
20. Database administrator (DBA)