According to Ewebarchitecture.com (n.d.), “MySQL can be integrated into a Web environment, and it supports C, Pearl, Java via the Java Database Connectivity API (JDBC), and Python programming.” There is a lot of flexibility with MySQL to work with these programming languages and can be used with Windows, Linux, and UNIX operating systems. MySQL is a client/server system in which software is installed on a computer to access the database on a server to save, modify, and query data. With MySQL, people can use it with data warehousing where it can scale up into the terabytes for holding data. It can support the data warehousing due to the high-performance to query data and has strong support for web functions. Security is another strong point for MySQL by having power mechanism to allow authorized user to access the database using Secure Shell (SSH) and Secure Socket Layer (SSL) for …show more content…
The approach to take when creating the database from a model would be to start with creating normalized tables sets for the entities and the attributes for each one. Once the tables are created, the attributes for the primary and foreign keys can be set with the relationship if it is going to one-to-one, one-to-many, or many-to-many. However, going from the model to the database structure, there is more information which will be needed. With communication from the customer, need to figure out if any of the fields needs an input mask such as dates or phone numbers to ensure that phone numbers and dates are put in one way. For an example, some people may type the date as 1 August 2016, but the management of the company wants to make sure the dates in the database are created August 1, 2016, there for an input mask for ensure the dates are all the same. Other information needed would be the security needs of the database. If the database is planned to hold sensitive information, the database needs to be setup with security groups and users, each of the groups may have certain access controls to access different data. For an example, an accounting group may allow users in the accounting section to financial information and no access to any other part of the database. The creator of the database will need to know if there are any data that needs to be loaded or