DBMS

Question 1

Application of DBMS to banking

Answer 1

Banking: DBMS is used to manage customer accounts, transactions, loans, and financial records. For example, a bank’s DBMS would store information about customer accounts, their balances, transaction history, and loan details.

Question 2

Application of DBMS to retail

Answer 2

Retail: DBMS is utilized for inventory management, sales tracking, and customer relationship management (CRM). For instance, a retail company’s DBMS would store product information, sales records, customer details, and purchase history.

Question 3

Healthcare

Answer 3

Healthcare: DBMS helps in managing patient records, medical history, appointments, and billing information. Hospitals use DBMS to store patient demographics, diagnoses, treatment plans, and test results securely.

Question 4

Education

Answer 4

Education: DBMS is used for managing student records, course schedules, grades, and administrative data. Schools and universities utilize DBMS to store information about students, faculty, courses, and academic programs.

Question 5

Manufacturing

Answer 5

Manufacturing: DBMS assists in managing production schedules, inventory levels, and supply chain operations. Manufacturing companies use DBMS to track raw materials, production processes, and product distribution.

Question 6

Telecommunication

Answer 6

Telecommunications: DBMS is used for managing subscriber information, call records, and network configurations. Telecommunication companies store customer details, call logs, billing information, and network infrastructure data in DBMS.

Question 7

E-commerce

Answer 7

E-commerce: DBMS helps in managing product catalogs, order processing, and customer interactions. E-commerce platforms utilize DBMS to store product listings, customer profiles, order history, and payment information.

Question 8

Transportation

Answer 8

Transportation: DBMS assists in managing logistics, vehicle tracking, and scheduling operations. Transportation companies use DBMS to store information about routes, vehicles, shipments, and delivery schedules.

Question 9

Government

Answer 9

Government: DBMS is used for managing citizen records, taxation data, and public services. Government agencies store information about citizens, property ownership, tax payments, and regulatory compliance in DBMS.

Question 10

Entertainment

Answer 10

Entertainment: DBMS helps in managing content libraries, user profiles, and viewing preferences. Streaming services use DBMS to store media assets, user accounts, viewing history, and personalized recommendations.

Question 11

What is DBMS

Answer 11

A Database Management System (DBMS) is a software system that provides an interface for users and applications to interact with databases

Question 12

Functionalities of DBMS

Answer 12

DBMS applications encompass various functionalities, including data storage, retrieval, organization, security, concurrency control, and backup and recovery

Question 13

Closing point of DBMS

Answer 13

DBMS applications are utilized across industries to manage vast amounts of data efficiently and securely, supporting tasks such as transaction processing, data analysis, decision-making, and information sharing.

Question 14

Finance

Answer 14

For storing information about holdings, sales, and purchases of financial instruments such as stocks and bonds; also for storing real-time market data to enable online trading by customers and automated trading by the firm

Question 15

Human resources

Answer 15

For information about employees, salaries, payroll taxes and benefits and for generation of paychecks