University Database Management System Design and Implementation Report

This report provides a detailed overview of database management system (DBMS) design and implementation. It begins with an introduction to databases and the justification for their use within an organization, emphasizing data retrieval and storage. The report then delves into the Entity Relationship (ER) model, offering a visual representation of the database structure. It further explores necessary IT controls, including integrity, input, and data validation controls, to ensure data accuracy and security. The report also addresses ethical, privacy, and security issues, such as the collection of user data, data misuse, and the importance of data protection. The conclusion summarizes the impact of a well-designed DBMS on business processes, highlighting its significance for efficient and accurate data processing. The report includes a bibliography of cited sources.

Running head: DATABASE MANAGEMENT SYSTEM DESIGN AND IMPLEMENTATION
Database Management System Design and
Implementation
Name of the Student
Name of the University

2DATABASE MANAGEMENT SYSTEM DESIGN AND IMPLEMENTATION
Table of Contents
Introduction: 3
Justification of the Use of Database: 3
Entity Relationship Model: 5
IT Controls Needed: 6
Ethical, privacy and security issues: 6
Conclusion: 7
Bibliography: 8

3DATABASE MANAGEMENT SYSTEM DESIGN AND IMPLEMENTATION
Introduction:
The database is the storage where all the organizational data are stored. In order to
retrieve the data from the storage and inserting the data into the storage, a system is required.
This system is called database management system (Nidzwetzki & Guting, 2016). Various
database management systems are present at the market. The ACCESS is the Microsoft Product
which supports various operations on the data.
Within the study, the database management system of proposed organization has been
discussed along with various issues. The ERD or Entity Relationship Diagram is the way of
representing the database in visual format. The proposed ERD has been done using generic rule.
Justification of the Use of Database:
Database management includes gathering and controlling information that is produced by
an organization/association. Information can be acquired through gather data through deals,
showcasing as well as organization site. While grouping an organization database, allows first
consider what may be incorporated into customer records (Gouhar, 2017). On an exceptionally
fundamental level, organizations would need to store the names, surname, sexual orientation and
critically these days; the email address. Organizations rely upon data for different reasons.
Principally the initial step is realizing what data it is you need to gather. Choosing how to gather
it is another issue (Yunus et al., 2017). To recover customer information, it should be possible
through deals, promoting, call focuses and additionally the organization site.
Organizations need to survey these gathering indicates all together figure out where the
best and most helpful data is originating from. Organizations that take after these means can be
rest guaranteed that they can focus on the correct group of onlookers. Recognizing the devices to

4DATABASE MANAGEMENT SYSTEM DESIGN AND IMPLEMENTATION
expand chances to increase new customers and in addition develop existing customers. Without
the correct data or legitimate management systems set up, an organization is in danger of losing
cash, sitting around idly, and possibly endangering customer connections (Hababeh, Khalil &
Khreishah, 2015). An appropriately oversaw database empowers organizations to settle on vital
business choices with certainty that will emphatically affect business execution. The accessibility
of data conceivably changes data into usable information. A superior oversaw database won't just
simplicity openness to information yet in addition improve it conceivable to create quality
information on which better choices are based. Nature of data is a far reaching way to deal with
advancing the precision and legitimacy (Prout et al., 2015). While having a database
management framework set up does not ensure data quality, it gives a system to encourage data
and its quality activities.
The proposed database management system is for supporting the business need. As the
organization handles various projects and numerous employees working on it. The database
management system will be collecting data from various users and store it into database. The
DBMS will store the data of the materials and the suppliers. The database is a complex one and
must support at least two many-to-many relations.
The proposed database will provide the below advantages to the selected organization.
1) The DBMS makes a domain in which end clients have better access to
progressively and better-oversaw data. Such access makes it workable for
end clients to react rapidly to changes in their condition (Lee et al., 2015).
2) The more clients get to the data, the more noteworthy the dangers of data
security break. Partnerships contribute extensive measures of time,

5DATABASE MANAGEMENT SYSTEM DESIGN AND IMPLEMENTATION
exertion, and cash to guarantee that corporate data are utilized
appropriately. A DBMS gives a system to better implementation of data
protection and security arrangements.
3) Wider access to very much oversaw data advances a coordinated
perspective of the association's activities and a clearer perspective of the
comprehensive view (Aken et al., 2017). It turns out to be substantially
less demanding to perceive how activities in a single section of the
organization influence different portions.
4) The DBMS makes it conceivable to create brisk responses to specially
appointed inquiries. From a database point of view, a question is a
particular demand issued to the DBMS for data control—for instance, to
peruse or refresh the data. Basically, an inquiry is an inquiry, and a
specially appointed question is a spontaneous inquiry. The DBMS sends
back an answer (called the question result set) to the application.
Entity Relationship Model:
Figure 1: The Entity Relationship Model

6DATABASE MANAGEMENT SYSTEM DESIGN AND IMPLEMENTATION
(Source: Created by Author)
IT Controls Needed:
Integrity Controls: It will reject the invalid data inputs. This control will prevent the
unauthorized outputs of data. It will also protect the data. This control will function against the
malicious and accidental tampering.
Input Controls: The input control stops the system from allowing erroneous or invalid
data into the system.
Value limit control: This control is responsible for checking numeric input of data for
ensuring data accuracy.
Completeness control: This control makes sure that inputted data are complete and asper
organization policy (Arulraj & Pavlo, 2017).
Data validation control: This control validates that the data is supported by the DBMS
configurations.
Transaction logging: A methodology through which any modification to the DBMS is
logged with this kind of audit data as input data, user ID, time, date, and kind of modification
(Coronel & Morris, 2016).
Ethical, privacy and security issues:
Various organizations collect unnecessary and repeated user data which results in ethical
issues. The organization will never collect the data from the user illegally. The database
administrator will have entire power over the system. Database Administrator may collect the

7DATABASE MANAGEMENT SYSTEM DESIGN AND IMPLEMENTATION
information of the users unauthorized way. The administrator may alter few of the to favor a
person or vice versa.
Privacy is one of the biggest ethical issues in database management system. Recent cases
of data misuses by renowned organizations has proven that data in internet is never secure.
Governments are using social media organizations and other enterprises to collect public data
(Abbasi, Sarker & Chiang, 2016). Various organizations sell the user data to other companies for
making extra profit.
Security is the biggest issues in database management. The data is the heart of the
business. The database system holds the crucial and sensitive information regarding the business.
The systems can be attacked by various threats. The database system can also be attacked by the
insiders.
Conclusion:
From the above study it can be concluded that the database is one of the biggest assets of
an organization. The proposed database for the selected organization will have great impact on
the business processes. The efficient and accurate data processing will enhance the quality of
business.

8DATABASE MANAGEMENT SYSTEM DESIGN AND IMPLEMENTATION
Bibliography:
Abbasi, A., Sarker, S., & Chiang, R. H. (2016). Big data research in information systems:
Toward an inclusive research agenda. Journal of the Association for Information
Systems, 17(2).
Arulraj, J., & Pavlo, A. (2017 ). How to build a non-volatile memory database management
system. In Proceedings of the 2017 ACM International Conference on Management of
Data (pp. 1753-1758). ACM.
Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management.
Cengage Learning.
Gouhar, A. (2017). Database Management System. International Journal of Engineering Science,
11766.
Hababeh, I., Khalil, I., & Khreishah, A. (2015). Designing high performance web-based
computing services to promote telemedicine database management system. IEEE
transactions on services computing, 8(1), 47-64.
Lee, H., Chapiro, J., Schernthaner, R., Duran, R., Wang, Z., Gorodetski, B., ... & Lin, M. (2015).
How I do it: a practical database management system to assist clinical research teams
with data collection, organization, and reporting. Academic radiology, 22(4), 527-533.
Nidzwetzki, J. K., & Guting, R. H. (2016). DISTRIBUTED SECONDO: An extensible highly
available and scalable database management system. FernUniversität, Fakultät für
Mathematik und Informatik.

9DATABASE MANAGEMENT SYSTEM DESIGN AND IMPLEMENTATION
Prout, A., Kepner, J., Michaleas, P., Arcand, W., Bestor, D., Bergeron, B., ... & Mullen, J. (2015,
September). Enabling on-demand database computing with MIT SuperCloud database
management system. In High Performance Extreme Computing Conference (HPEC),
2015 IEEE (pp. 1-6). IEEE.
Van Aken, D., Pavlo, A., Gordon, G. J., & Zhang, B. (2017). Automatic database management
system tuning through large-scale machine learning. In Proceedings of the 2017 ACM
International Conference on Management of Data (pp. 1009-1024). ACM.
Yunus, M. A. M., Krishnan, S. K. G., Nawi, N. M., & Surin, E. S. M. (2017). Study on Database
Management System Security Issues. JOIV: International Journal on Informatics
Visualization, 1(4-2), 192-194.