content

Unit 1: Database Architecture

Important Questions

Q1. define database.

A database is a collection of data that is structured and easy to access, manage and update. This can be anything like text, numbers, videos, images, files, and more.

Q2. Define DBMS

A DBMS(Database Management System) is a software used to manage data in a database. This allows us to store, modify, update and delete data from a database.

Examples: MySQL, Oracle SQL, MongoDB, PostgreSQL, etc

GeeksForGeeks

Q3. Why do we need DBMS?

A DBMS makes the following tasks a lot simpler:

GeeksForGeeks

Q4. Define data model.

A Data Model is a blueprint-like representation of the data so that we can visualize and understand it.

AWS

Q5. Explain relational model.

A relational data model is where we use Tables to describe how our data is stored in a Relational Databases. Rows are called Tuples and Columns are called Attributes.

Student ID Name Age Field
1 John Smith 20 Computer Science
2 Jane Doe 21 Biology
3 Bob Johnson 19 Mathematics

Here, Student ID, Name, Age and Field come under Attributes(columns) and the Tuples(rows) hold student data corresponding to the attributes.

GeeksForGeeks

Q6. Explain Hierarchical model.

In a hierarchical model, data is organized in a tree-like structure which helps group multiple tables together.

graph LR
  Company[Company]
  DepartmentA[Department A]
  DepartmentB[Department B]
  DepartmentC[Department C]
  Employee1[Employee 1]
  Employee2[Employee 2]
  Employee3[Employee 3]
  Employee4[Employee 4]
  Employee5[Employee 5]
  Employee6[Employee 6]

  Company -->|contains| DepartmentA
  Company -->|contains| DepartmentB
  Company -->|contains| DepartmentC
  DepartmentA -->|employs| Employee1
  DepartmentA -->|employs| Employee2
  DepartmentB -->|employs| Employee3
  DepartmentB -->|employs| Employee4
  DepartmentC -->|employs| Employee5
  DepartmentC -->|employs| Employee6

Here, Company is the root node, The departments are parent nodes and the employees are the child nodes.

GeeksForGeeks

Q7. What is a schema?

A database schema is basically the structure of the relational database, so it defines how the data is organized.

This includes primary key, tuples, attributes, tables, fields, data types, relations and constraints.

GeeksForGeeks

IBM

Q8. What is an instance?

A Database instance is the collection of all the data stored at any given time. This is also called the current state, or database state.

GeeksForGeeks

Q9. What is DBMS architecture?

A DBMS (Database Management System) architecture refers to the overall design and organization of a DBMS, including the components, interfaces, and interactions between them. It provides a framework for managing and accessing data in a database.

Javatpoint

Q10. What is data independence?

Data independence is a property of a database management system by which we can change the database schema at one level of the database system without changing the database schema at the next higher level.

It has two types:

GeeksForGeeks

Q11. Define database language.

Database Language is a programming language used to define and manipulate a database.

It has 4 types based on what it does:

Scalar

Q12. What are the properties of database?

Q13. Explain different types of database users.

  1. Database Administrators (DBA): Responsible for implementing and managing the database system, including:
    • Defining and modifying schema.
    • Managing storage structure and access methods.
    • Creating security measures and user privileges.
    • Defining integrity constraints.
    • Establishing backup and recovery policies.

  2. Database Designers: Design the database structure, including tables, indexes, views, and stored procedures, determining how data is stored and related.

  3. End Users: Access the database for querying and reporting, categorized as:
    • Casual Users: Access the database occasionally for different information.
    • Naive Users: Unsophisticated users who interact via application interfaces without database knowledge.
    • Sophisticated Users: Familiar with databases, write SQL queries for their needs.
    • Stand-alone Users: Maintain personal databases using ready-made software.

Q14. What are the disadvantages of database?

  1. Increased Cost:
    • Hardware and Software: DBMS requires high-speed processors and large memory, leading to significant costs for hardware and software. Maintenance and licensing add to these expenses.
    • Staff Training: Hiring and training educated staff (DBAs, programmers) increases costs, as does outsourcing to software houses.
    • Data Conversion: Transitioning existing data to a DBMS involves high expenses for hiring designers and developers.

  2. Complexity: DBMS functionality requires in-depth knowledge from developers, DBAs, and end-users. Lack of expertise can lead to data loss and poor design decisions, making management challenging.

  3. Currency Maintenance: Keeping the system updated for efficiency is crucial. Regular updates and security measures incur additional training costs.

  4. Performance: DBMS may perform poorly for small organizations compared to traditional file systems, leading to slower application speeds and reduced usability.

  5. Frequent Upgrade/Replacement Cycles: New functionality and software upgrades often require hardware updates, making it difficult for users to adapt to constant changes and incurring training costs.

  6. Complex Design: Database design is intricate, time-consuming, and requires significant effort.

  7. Damaged Parts: Corruption in one part of the database can affect the entire system.

  8. Compatibility: DBMS software may not integrate well with other systems, complicating application development.

  9. Security: Vulnerabilities can arise if the DBMS is not properly configured, risking data loss or theft.

  10. Data Isolation: Scattered data across various files complicates the retrieval of relevant information.

  11. Difficulty in Accessing Data: Conventional file-processing systems may lack the necessary application programs for specific queries, leading to inefficiencies.

  12. Data Redundancy and Inconsistency: Multiple versions of the same data in different files can lead to inconsistencies and higher storage costs.

  13. Integrity Problems: Enforcing consistency constraints can be challenging, especially when multiple data items are involved, complicating program updates.

GeeksforGeeks

Q15. Explain different people in DBMS.

Refer Answer 13.

Q17. Explain different types of schemas.

  1. Physical Database Schema:
    • Defines how data is physically stored in storage systems, including files and indices.
    • Involves the actual code and syntax for creating the database structure.
    • The Database Administrator determines where and how to store data in storage blocks.
  2. Logical Database Schema:
    • Describes logical constraints, tables, views, entity relationships, and integrity constraints.
    • Illustrates how data is organized in tables and the connections between attributes.
    • Maintains relationships using ER modeling and enforces integrity constraints for data quality.
  3. View Database Schema:
    • Represents the interaction design between end-users and the database.
    • Allows users to interact with the database through an interface without needing to understand the underlying data storage mechanisms.

GeeksforGeeks

Q18. Explain different types of DBMS architectures.

  1. Client-Server Architecture: The design of a DBMS depends on its architecture. It can be centralized or decentralized or hierarchical. Database architecture is logically divided into two types. They are:
    • Two-tier Client/Server Architecture:
      • Consists of a user interface program and application programs on the client side.
      • Uses ODBC (Open Database Connectivity) to connect client programs to the DBMS.
      • Requests are sent from the application layer to the database layer, and results are returned to the application layer.
    • Three-tier Client/Server Architecture:
      • Separates tiers based on user complexity and data usage.
      • Most widely used architecture for designing a DBMS.
  2. Centralized DBMS Architecture:
    • Features a database stored and maintained in a single location (e.g., a server or mainframe).
    • Commonly used by organizations or institutions, such as businesses and universities.

Q19. What is database Representation? Explain different types with examples

Database representation refers to how data is structured, organized, and stored in a database. Different types of representations help in modeling and accessing data effectively. Here are the main types:

  1. Flat File Representation:
    • Data is stored in a single table or file, with records arranged in rows and fields in columns.
    • Example: A CSV file containing student records with fields like Name, Age, and Grade.
  2. Hierarchical Representation:
    • Organizes data in a tree-like structure where each record has a single parent and can have multiple children.
    • Example: An organizational chart where a manager has multiple employees reporting to them.
  3. Network Representation:
    • Similar to hierarchical but allows multiple parent-child relationships, forming a graph structure.
    • Example: A social network where users can have multiple friends and connections.
  4. Relational Representation:
    • Data is organized into tables (relations) with rows (records) and columns (attributes). Relationships between tables are established through foreign keys.
    • Example: A database with a “Students” table and a “Courses” table, linked by a Course ID.
  5. Object-oriented Representation:
    • Data is represented as objects, similar to programming languages, encapsulating both data and behavior.
    • Example: An object representing a car that includes properties like make, model, and methods for starting or stopping.
  6. Document Representation:
    • Data is stored in semi-structured formats, often using JSON or XML, suitable for hierarchical data.
    • Example: A JSON document representing a blog post with fields like title, author, and content.
  7. Graph Representation:
    • Data is represented as nodes and edges, allowing complex relationships and queries.
    • Example: A graph database representing a network of cities connected by roads, where cities are nodes and roads are edges.

Q20. What is the difference between logical and physical data independence? Explain briefly.

Logical Data Independence:

Physical Data Independence:

Summary

Source: