CSC 210 – DATA MANAGEMENT 1
GROUP 2
MATRIC NO: U21CS1027 – U21CS1053
DEPARTMENT OF COMPUTER SCIENCE, AIR FORCE INSTITUTE OF
TECHNOLOGY
TOPIC: CONCISE DEFINITION, RELATIONSHIP AND
CONTRAST REGARDING DATABASE AND
DATABASE SYSTEMS
Contributors
S/N NAMES MATRIC NO.
1. MAHMUD AMINA AMIRA U21CS1027
2. USMAN UMAR FAROUK U21CS1028
3. ISAH JOSEPH SILAS U21CS1029
4. OKOROAFOR CHINEDU DAVID U21CS1030
5. LAKAN NANJI EMMANUELLA U21CS1031
6. KEN-USMAN JONAH FRANCIS U21CS1032
7. YUSUF JIBRIL IBRAHIM U21CS1033
8. ABDULKADIR GARZALI ADO U21CS1034
9. OLADEJO ABDULLATEEF BABATUNDE U21CS1035
10. OMACHE DAVID OHINI U21CS1036
11. UROM VICTOR CHIDERA U21CS1037
12. YUSUF ABDULLAHI BABI U21CS1038
13. STEPHEN ELKANAH F. U21CS1039
15. AYENI OLUWAFERANMI PASCAL U21CS1040
16. MUHAMMED ALAMIN SANI U21CS1041
17. AMINU ZAINAB U21CS1042
18. SHITTU ROHEEZ AMOO U21CS1043
19. MAHDI FATIMAH ZARAU U21CS1044
20. IYOWU MURITALA AKINTUNDE U21CS1045
21. SHITTU ROFEEQ ADELEKE U21CS1046
22. MUHAMMAD ABDURRAHMAN TANGBO U21CS1047
23. LANGAYA FOJIUMA JAMES U21CS1048
24. AHMED SALIM TIJJANI U21CS1049
25. MUHAMMAD AISHA HABIBU U21CS1050
26. NASIRU HASSANA DANJUMA U21CS1051
27. ARIYO OMOBOLAJI DANIEL U21CS1052
28. MUAZU ABDULRRAHMAN KABIR U21CS1053
Definitions
What is a Database?
A database is an organized collection of structured information, or data, typically
stored electronically in a computer system. It is usually controlled by a database
management system (DBMS) which include computerized library systems, flight
reservation systems; computerized parts inventory systems, and many content
management systems that store websites as collections of webpages in a
database.
What is a Database System?
A Database System however is a software application, programmed to store,
manage, and organize data. It provides a structured way to store information in
tables or other data structure forms making it easier to locate, update,
manipulate and use the data.
Relationship between Database and Database Systems
A database is a structured collection of data that is organized and stored for
efficient retrieval and manipulation. A database system, on the other hand,
encompasses both the database itself and the software that manages, stores,
retrieves, and manipulates the data within it. In other words, a database system
includes the database, the database management system (DBMS), and the
associated tools and utilities used to ensure data integrity, security, and efficient
access. It's a broader concept that involves the technology and software used to
manage and interact with databases.
Differences between a database and database system
1. Definition
In terms of Definition a Database is A collection of organized and structured
data stored in a computer system While A Database System is A software
application that manages, organizes, and stores databases, providing
functionalities for data storage, retrieval, and manipulation.
2. Scope
A Database Refers to the data itself, often a single collection of related
information while A Database System Encompasses the database along with the
software, hardware, and other components required to manage and interact with
the data.
Components
A Database Consists of data records, tables, fields, and relationships While A
Database System Comprises the database, database management system
(DBMS), storage, query processing, and user interfaces.
4. Functionality
A Database: Primarily concerned with storing and organizing data While A
Database System Offers a range of functionalities like data querying, data
manipulation, data security, concurrency control, and more.
5. Purpose
A Database Holds data for a specific application or domain while A Database
System Supports multiple databases for various applications and users.
6. User
A Database is Intended for a specific group or application While A Database
System Serves multiple users, applications, and organizations.
7. Management
A Database: Requires manual organization and maintenance While Database
System Offers automated management through the DBMS, handling tasks like
data integrity, backups, and indexing.
8. Scalability
Database Limited scalability, often designed for specific data volumes While A
Database System: Can handle varying levels of data volume and users, with
options for scaling up or out.
9. Security and Access Control
A Database has limited security features, often relying on external mechanisms
While A Database System Provides advanced security features, user
authentication, role-based access control, and encryption.
10. Data Redundancy and Consistency
A Database is Limited control over data redundancy and consistency While a
Database System Offers mechanisms to ensure data consistency and minimize
redundancy through normalization and transaction management.
Note: A database is just the structured collection of data, while a database system
includes the software and infrastructure to manage and interact with that data
effectively.
