Vocab

Question 1

Apache

Answer 1

Open source web server application

This software serves as the Hypertext Transfer Protocol (HTTP), compiling the scriptung language, databases, and HTML from a website’s server to send to the users machine.

Question 2

MAMP

Answer 2

Mac web server software elements:
The operating system (Mac)
Web server (Apache)
Databases (MySQL)
Scripting language (PHP)

There is also WAMP and LAMP for Windows and Linux

Question 3

FTP

Answer 3

File transfer protocol

Used to transfer files between across a network

Use ftp:// instead of http://

Question 4

Flat file

Answer 4

Database store in just one file and use delimiters to define where elements and records start and end.

Question 5

Delimiter

Answer 5

Separating markers, such as commas

Question 6

Database

Answer 6

Contains one or more tables

Question 7

Relation (or table)

Answer 7

Contains tuples and attributes

Question 8

Tuple (or row)

Answer 8

A set of fields which generally represent an “object” like a person or music track

Question 9

Attribute (also column or field)

Answer 9

One of possibly many elements of data corresponding to the object represented by the row

Question 10

Schema

Answer 10

The metadata, or descriptors/perimeters of attributes(columns)