Slide 1.9: Languages and software to be used (cont.)

Languages and Software to Be Used (Cont.)

SQL (Structured Query Language)
A standard language for creating, updating, and querying databases


SELECT name, course FROM enrollments; /* CREATE TABLE Courses ( number CHAR(10) PRIMARY KEY, name VARCHAR(16) ) ENGINE=InnoDB; CREATE TABLE Enrollments ( name VARCHAR(32), course CHAR(10), PRIMARY KEY( name, course ), FOREIGN KEY( course ) REFERENCES Courses( number ) ) ENGINE=InnoDB; */

(X)HTML [(eXtensible) HyperText Markup Language]
HTML is a language for giving instructions for its layout on the page and marking a document containing cross-references that indicates its logical structure. XHTML is a stricter and cleaner version of HTML.


<html> <body> <form action=""> <select name="cars" size="2"> <option value="volvo">Volvo</option> <option value="saab">Saab</option> <option value="fiat" selected="selected">Fiat</option> <option value="audi">Audi</option> </select> </form> </body> </html>

XML (eXtensible Markup Language)
A specification that allows designers to create their own customized tags, enabling the definition, transmission, validation, and interpretation of data between applications and between organizations


<?xml version="1.0"?> <note> <to>Tove</to> <from>Jani</from> <heading>Reminder</heading> <div>Don't forget me this weekend!</div> </note>