Database Systems: Homework Assignment on DBMS and its Applications

This homework assignment delves into the core concepts of Database Systems and Database Management Systems (DBMS). It begins by establishing that a data table constitutes a database, explaining the rationale behind this classification. The assignment then explores the functionalities of a DBMS, including data input, deletion, and user access. Furthermore, it identifies various users of a DBMS, such as application developers, database designers, and administrators. The assignment also provides an overview of the advantages and disadvantages of using a database approach, discussing benefits like controlled redundancy and enhanced security, alongside drawbacks such as complexity and potential system failure. The assignment is well-supported by references from leading texts on database systems.

Question 1.
Yes this data table is database.
This is because, this table is a collection of logically related data that meets information need of
an organization, which explains what database is. We can see different columns that are related
to each other as per database explanation.
Question 2.
What are the functionalities of a DBMS?
a) Input data into a database by loading values from a data file.
b) Delete a data record from a table in the database.
c) Login as an administrator role.
d) Search for a customer’s purchase history.
Question 3.
Who are the users of a DBMS?
a) Application Developers
b) Physical database designers
c) DBMS Operators
d) Software package Developers
e) Parametric end users
f) Database administrators
g) Database designers
h) Data administrators
Question 4.
Can you enumerate the advantages and disadvantages of using database approach?
Advantages of Database approach
1. Database approach helps control redundancy in systems.
2. Database approach helps in restricting unauthorized access to database systems.
3. Database approach helps in storing of structures and techniques for efficient querying.
4. Database approach helps provide recovery of systems and backups in case of a risk.
5. Database approach helps provide multiple user interfaces of systems.
6. Database approach allows actions to be done on systems using given rules.
7. Database approach helps impose integrity constraints to database systems.
8. Database approach aids in complex relationships between data.
9. Database approach helps increase productivity

10. Database approach gives up-to-date requirements.
Disadvantages of Database approach
Some of the disadvantages of database approach is as listed below;
1. They are complex systems.
2. They need space in terms of size.
3. They are expensive.
4. They impose additional costs due to purchasing hardware.
5. Sometimes the performance is not good due to their complexity.
6. If the DBMS fails, it imposes failure of organization.
References
Nenand Jukic (2014); ‘Introduction to Databases and data warehouses.’ Boston.
Elvis C Foster, Shripad V Godbole. ‘Introduction to Database Systems.’
Date, CJ (1990), ‘An introduction to Databases Systems.’ Publisher, Addison-Wesley.
Saadiah Yahya, (2006); ‘Introduction to Database Systems’. McGraw Hill
ItL Educatinon Solutions Limited, eBook (2014); Introduction to Database Systems.
Atil Kahate (2006). ‘Introduction to Database Management Systems’. Publisher, Pearson.