A localhost is a designated web server hosted from the current piece of hardware that only that piece of hardware can access on the web.
XAMPP is a free and open-source cross-platform web server solution stack package developed by Apache Friends, consisting mainly of the Apache HTTP Server, MariaDB database, and interpreters for scripts written in the PHP and Perl programming languages. That can host a dedicated localhost on the hardware being used.
The Apache HTTP Server, colloquially called Apache, is a free and open-source cross-platform web server software, released under the terms of Apache License 2.0. Which allows users to serve website onto the internet or localhost.
MySQL is a relational database management system based on SQL – Structured Query Language. which is most commonly used as web database to store large amounts of data.
phpMyAdmin is a popular and free open source tool used for administering MySQL with a web browser. Typical operations such as the management of databases, tables, indexes, permissions, and so on are executed with the user interface. Administrators can also use phpMyAdmin to directly execute any SQL statement.
A database is a structured set of data held in a computer, especially one that is accessible in various ways. most commonly composed of tables.
The database name is the name of the database such as “cooking recipes” which is assigned to the database by the creator.
A primary key is a specific choice of a minimal set of attributes that uniquely specify a tuple in a relation that is used to search for and find specific databases.
An attribute in a database management system refers to a database component such as a table.
Objects in databases is used to represent information in the form of objects such as stored procedures and sequences.
Auto increment is used in a database in the primary key when the primary key is an integer the auto increment will automatically assign a number to the data which is one higher than the previous key.
A list or sequence is an abstract data type that represents a countable number of ordered values, where the same value may occur more than once.
A method or function is a designated sequence of actions that take place in order when called in using the assigned call tag.
The top 6 things that should be included when creating a website is:
- An eye catching image or video in the middle of the front page to scroll or watch through.
- The logo clear and at the top left that can be easily identifiable.
- A navigation menu at the top of the website that is easy to use.
- Contrast between colours like white text on black background so that it is easy to see and read.
- Flows smoothly so that it is pleasing to use.
- Social media links that can be easily identified and accessed.
The Australian Computer Society Code of Ethics states rules that should be morally followed these rules are:
- The primacy of the Public Interest
- The Enhancement of Quality of Life
- Honesty
- Competence
- Professional Development
- Professionalism
These rules outlines that you should strive to improve the quality of life of the public while placing the interests of the public above those of personal, business, or sectional interests. You will be honest and work professionally and competently to enhance the integrity of the Australian Computer Society Code of Ethics.
Common browsers that are used for accessing the web are:
- Google Chrome
- Internet Explorer
- Mozilla Firefox
- Microsoft Edge
- Safari
Which all have their own advantages and disadvantages of using them and everyone has their own personal preference.
Terrell Masters 