Unit 1 of 4 · BCA Sem 3

Unit 1: Introduction to databases and data models

Database Management Systems-I notes · PTU syllabus (UGCC2512)

3 min read4 topics8 exam questions
On this page
  1. Unit summary
  2. Data, database and DBMS
  3. File system vs DBMS
  4. Database users and the DBA
  5. Data models
  6. Key terms
  7. Quick revision
  8. Important questions

Unit summary

Almost every application — banking, college ERPs, e-commerce, social media — stores its data in a database. A Database Management System (DBMS) is the software that stores, retrieves and protects that data. This unit introduces data, databases and DBMS, their applications, advantages and disadvantages, the people who use and manage databases, and the main data models.

After this unit you can

  • Define data, information, database and DBMS
  • Compare the file system approach with a DBMS
  • Describe the roles of database users and the DBA
  • Compare hierarchical, network, relational and object-oriented data models

PTU syllabus topics

  • Definitions of data
  • database and DBMS
  • database applications
  • advantages/disadvantages of DBMS
  • roles of database users and administrators
  • data model types (hierarchical, network, relational, object-oriented)
1

Topic 1

Data, database and DBMS

GraphThree-schema architecture
External level (user views)Conceptual level (whole database)Internal level (physical storage)

Logical data independence separates external from conceptual; physical data independence separates conceptual from internal

  • Data: raw facts (e.g. "Ana", 85, "BCA").
  • Information: processed, meaningful data ("Ana scored 85 in BCA").
  • Database: an organised collection of related data stored so it can be accessed easily.
  • DBMS: software that creates, stores, manages and controls access to databases. Examples: MySQL, Oracle, PostgreSQL, SQL Server, MongoDB.

Applications: banking (accounts, transactions), airlines and railways (reservations), universities (students, results), hospitals, e-commerce (orders, inventory), telecom and social media.

Example

In a college: "Ana", 85 and "BCA" are data. "Ana of BCA scored 85" is information. The organised collection of all student records is a database. MySQL or Oracle, the software that stores and retrieves it, is the DBMS.

2

Topic 2

File system vs DBMS

ComparisonFile system vs DBMS
File system
DBMS

Redundancy

High: same data in many files

Controlled

Consistency

Inconsistent copies are common

Maintained by constraints

Data access

Need a new program for each query

Easy queries with SQL

Security

Weak

User-level access control

Concurrency

Problems with simultaneous users

Managed safely

Backup and recovery

Manual

Built in

Disadvantages of a DBMS: high cost of software and hardware, complexity, need for trained staff, and performance overhead for very small, simple applications.

Example

The problem with files: a student's address is stored in both the fees file and the library file. When she moves, only the fees file is updated. The two now disagree (inconsistency caused by redundancy). In a DBMS the address is stored once.

3

Topic 3

Database users and the DBA

UserRole
Database Administrator (DBA)Manages the whole database: schema, security, backup, performance
Database designersDecide the structure: tables, keys, relationships
Application programmersWrite programs that use the database
End users (naive and sophisticated)Use the database through forms or queries

Responsibilities of the DBA: defining the schema, granting access, backup and recovery, monitoring performance, and maintaining integrity and security.

Example

Users of a bank's database: the teller using a screen is a naive user. The programmer who wrote the screen is an application programmer. The analyst writing SQL queries is a sophisticated user. The DBA creates accounts, grants permissions and takes backups.

4

Topic 4

Data models

A data model is a set of concepts for describing the structure of a database, its relationships and its constraints.

ComparisonData models
Structure
Example use

Hierarchical

Tree: one parent, many children

IBM IMS, file folders

Network

Graph: records linked by many-to-many sets

IDMS

Relational

Tables of rows and columns linked by keys

MySQL, Oracle

Object-oriented

Objects with data and methods

Multimedia, CAD databases

The relational model (E. F. Codd, 1970) is the most widely used because of its simplicity and the power of SQL.

Exam tip

Also mention the three-level architecture (external, conceptual, internal) and data independence if asked about DBMS architecture.

Example

Same data, three models: departments and their employees are stored as a tree in the hierarchical model, as records linked by pointers in the network model, and as two tables joined by dept_id in the relational model, the one used today.

Key terms

Database
An organised collection of related data
DBMS
Software for creating and managing databases
DBA
The person responsible for managing the database
Data redundancy
Unnecessary duplication of data
Data model
Concepts for describing a database's structure

Quick revision

  • Data → information; database → DBMS.
  • DBMS reduces redundancy and inconsistency and adds security and concurrency.
  • DBA manages schema, security, backup and performance.
  • Models: hierarchical (tree), network (graph), relational (tables), object-oriented.

Important exam questions

Practice questions written to the PTU exam pattern for this unit's syllabus: short answers (Section A style) and long answers (Sections B and C style).

Short-answer questions

  1. Q1.Differentiate between data and information.
  2. Q2.Define a DBMS and give two examples.
  3. Q3.List four advantages of a DBMS over a file system.
  4. Q4.What are the duties of a DBA?
  5. Q5.Name four data models.

Long-answer questions

  1. Q1.Compare the file processing system and the DBMS approach in detail.
  2. Q2.Explain the different types of database users and the role of the DBA.
  3. Q3.Explain the hierarchical, network and relational data models with diagrams.

Stuck on this unit?

Message SBS on WhatsApp for help with Database Management Systems-I, or to ask about studying BCA at Synetic.

WhatsApp us