JNTU B.Tech III DATABASE MANAGEMENT SYSTEMS Previous Question Paper (August - 2022 - R16)

Database users are individuals who interact with the database to perform specific tasks, while database administrators (DBAs) are professionals responsible for the overall management, security, and performance of the database system.

Key differences include:

• Database Users: These individuals access the database through application programs or query languages. They are categorized as naive users (using pre-defined interfaces), application programmers (writing code to interact with data), or sophisticated users (executing complex queries directly). Their primary focus is data retrieval and manipulation for business operations.
• Database Administrators: These individuals have centralized control over the database system. Their responsibilities include schema definition, storage structure and access method definition, schema and physical organization modification, granting authorization for data access, and monitoring system performance. They ensure data integrity, security, and availability.

Database systems are essential in modern computing due to their ability to store, manage, and retrieve large volumes of data efficiently. Key applications include:

• Banking: Used for managing customer accounts, tracking transactions, loans, and credit card activities. It ensures atomicity and consistency in financial operations.
• E-commerce: Facilitates online shopping by managing product catalogs, inventory, customer profiles, order processing, and payment gateways.
• Education: Used by universities to maintain student records, course registrations, grades, and faculty information.
• Healthcare: Manages patient medical histories, diagnostic reports, billing, and scheduling, ensuring quick access to critical information.
• Manufacturing: Tracks supply chain management, production schedules, inventory levels of raw materials, and finished goods.
• Human Resources: Maintains employee records, payroll systems, attendance tracking, and performance appraisals.
• Transportation: Manages airline, train, or bus reservation systems, tracking schedules, seat availability, and passenger manifests.