WDS-1
Databases:
According to the Wikipedia© Web Site, a Computer Database is a structured collection of records or data that is stored in a computer system. The structure is achieved by organizing the data according to a database model. The model in most common use today is the relational model. Other models such as the hierarchical model and the network model use a more explicit representation of relationships.
A computer database relies upon software to organize the storage of data. This software is known as a database management system (DBMS). Database management systems are categorized according to the database model that they support. The model tends to determine the query languages that are available to access the database. A great deal of the internal engineering of a DBMS, however, is independent of the data model, and is concerned with managing factors such as performance, concurrency, integrity, and recovery from hardware failures. In these areas there are large differences between products.
I have always wanted to learn more about database. Actually, I did not know much about it, other than the fact that it was necessary to have them in order to control large amounts of data in a server.
In the CIT-235 class, we will learn a little about MySQL databases and how to use it in our web sites. MySQL is an open source relational database management system (RDBMS) that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database. SQL is used to insert and manipulate data and is based on natural English. In the book “The Essential Guide to Dreamweaver CS3 with CSS, AJAX, and PHP”, we find the following example of how much easier and simpler it is to read the database as well as to get values from it.
“…to get the value of first_name and family_name from a database table called mebres, where username is equal to dpowers, you would use the fallowing command (or SQL query):”
SELECT first_name, family_name
FROM members
WHERE username = ‘dpowers’
***I had to fix a validation problem, so I had to re-submit it. The original submiting time of the assignament was on Saturday, September 20, 2008 6:16 PM
| Is it working? |
|---|
| Johan - 2008-12-09 16:02:40 |
| Comment: |
| I hope it works!!! Good job on the site!! hehe :) |
| Subject 01 |
|---|
| Name 02 - 2008-12-09 16:23:35 |
| Comment: |
| lkjh |
| What now?? |
|---|
| Johan - 2008-12-09 16:24:37 |
| Comment: |
| ???? |
| What now?? |
|---|
| Johan - 2008-12-09 16:26:17 |
| Comment: |
| ???? |
| What now?? |
|---|
| Johan - 2008-12-09 16:28:47 |
| Comment: |
| ???? |
| Is it working? |
|---|
| Name 03 - 2008-12-09 16:36:54 |
| Comment: |
| jhgkjhg |

