Extended Resources

• This link gives a detailed description on how database systems are managed and worked through. The speaker brings emphasis on the ER diagram and their relationship in structuring databases and queries. They also discuss database implementation in SQL Servers and briefly define what SQL (Structured Query Language) is.
  https://www.youtube.com/watch?v=n75iPNrzN-o  
• This article briefly describes the seven commonly used types of database management systems, explains the origins on how they were structured, and describes how each DBMS is used.
  https://www.c-sharpcorner.com/UploadFile/65fc13/types-of-database-management-syste ms/
• This article explains the seven best practices on how to protect and secure databases from hackers and other attackers.
  https://www.esecurityplanet.com/network-security/6-database-security-best-practices.htm l
• This article briefly explains some of the common malpractices in designing a database and database management systems.
  https://www.toptal.com/database/database-design-bad-practices
• This article goes into some of the specific types of user interfaces in database management systems. They are designed by mostly UI developers to utilize the information given in the database. They also explain each of the different types to give an idea of which is the best for the needs of each DBMS.
  https://www.geeksforgeeks.org/interfaces-in-dbms/
• Identifying Database Table Relationships
  One of the huge advantages of a relational database is that, once you have your data held in clearly defined, compact tables, you can connect or relate the data held in different tables. There are three types of relationships between the data you are likely to encounter at this stage in the design: one-to-one, one-to-many, and many-to-many. To be able to identify these relationships, you need to examine the data and have an understanding of what business rules apply to the data and tables. If you’re not sure, it can be helpful to meet with someone who does have a thorough knowledge of the data.
  https://condor.depaul.edu/gandrus/240IT/accesspages/relationships.htm
• Deciding on Tables and Fields for your Database Design:
  Each table in your database should hold the information on one subject. You might think of a subject as a collection of related information with common characteristics. For example, if you were creating a database to hold information about the operation of your ice cream stand, you might have an IceCream table. If you decided to sell sundaes as well as cones, you might add a Toppings table. Then, to associate ice cream and toppings in particular combinations and record the prices, you might add a Sundaes table.
  https://condor.depaul.edu/gandrus/240IT/accesspages/tables-fields.htm

 References:

 Introduction to the Module. (n.d.). Retrieved from  https://www.cs.uct.ac.za/mit_notes/database/htmls/chp01.html#risks-of-the-database-app  roach

Costs and Risks of Database Approach. (2010). Retrieved from  http://www.smartclass.co/2011/02/costs-and-risks-of-database-approach.html

Hooda, S. (2019, September 17). What are the Advantages of a Database Management System?  Retrieved from https://www.goskills.com/Development/Articles/Advantages-of-database-management-sy stem

Keuffel, W. “Battle of the Modeling Techniques.” DBMS Magazine (August 1996).

Kroenke, D., Auer, D., Vandenberg, S., Yoder, R., Database Processing, Fundamental, Design, and Implementation, Fifteenth, Edition, 2018.

Kroenke, D. “Waxing Semantic: An Interview.” DBMS Magazine (September 1994).

Kioko, O. N., & Bilal. (2011, March 28). Disadvantages of conventional file-processing system  Retrieved from http://punarvasi.com/disadvantages-of-conventional-file-processing-system/

Multi-user environments: Spreadsheets vs Databases. (2016, April 11). Retrieved from https://www.workingdata.co.uk/spreadsheets-vs-databases-round-1-multi-user

Oracle Database Administrator (DBA) Salary Guide. (n.d.). Retrieved from https://education.oracle.com/oracle-dba-salaries-guide

O. (2019, December 20). What are the Components of Database System Environment? Retrieved from https://www.owlgen.in/what-are-the-components-of-database-system-environment/

Parody, L. (2019, September 27). Databases for Frontend Developers. Retrieved from https://medium.com/@lizparody/databases-for-frontend-developers-2a4e9f16b7b4

Rahul, & Rahul. (2019, December 27). File Processing System – File System – Disadvantages of File Processing. Retrieved from https://www.tutorialcup.com/dbms/file-processing-system.htm

Sir, B. (2017, July 26). Disadvantages of File Oriented System. Retrieved from http://niravbaldha.blogspot.com/p/file-oriented-system.html

Thiru. (n.d.). Thiru. Retrieved from  http://www.myreadingroom.co.in/notes-and-studymaterial/65-dbms/506-database-develo pment-life-cycle.html

Vivek Gite. (2014, January 19). What is The Role Of the System Administrator? Retrieved from https://www.cyberciti.biz/faq/what-is-the-role-of-the-system-administrator/

WD, (2005) Retrieve from https://www.workingdata.co.uk/spreadsheets-vs-databases-round-1-multi-user/​)

Wang, X., Wang, Y., & Zhu, H. (2012). Energy-Efficient Multi-Job Scheduling Model for Cloud Computing and Its Genetic Algorithm. Mathematical Problems in Engineering​ ​, 2012​, 1–16. doi: 10.1155/2012/589243

What are the functions of the Database Administrator. (n.d.). Retrieved March 22, 2020, from http://www.pkirs.utep.edu/cis4365/Tutorials/Database%20Administration/8.00700/1_mul tipart_xF8FF_2_tutorial.htm

What is a database? (n.d.). Retrieved from  https://www.oracle.com/database/what-is-database.html