Computer Science Reviews (A level)

Exchanging data

Example of a form

DBMS

Stands for Database Management System. DBMS is software which allows you users to organise, edit, create and destroy data

Features:

-Allows separate of the apps from the DB itself

-Concurrency controls- this controls people trying to edit data at the same time, so will lock a -record if someone is already editing

-Data Validation/constraint

-User management/ access rights

-Set up schema aka views

-Enforce referential integrity- a child table can't be parentless, so when dropping a table, its children must be dropped first

-e.g. Access, MySQL

-SQL:

--DDL (Data Definition Language)- create/drop table, add fields/primary keys

--DML (Data Manipulation Language)- insert, delete, update, query 

Web Dev Languages

HTML

-Hyper text markup language

-Is the standard for developing webpages

-Uses tags

-Specifies the content of webpages

-Allows formatting of elements to be specified

<tag>content</tag> 

Some syntax:

< a>

< img src=""> 

Form syntax:

<form>

<label></label>

<input>

<input>

</form> 

CSS

Element selector- selects elements by tagname

Identifier ID- applied to a single element, selected with #

Class- can be applied to many elements, selected with 

Cheatsheet:

.className, #idName{

font: font-size font-family;

border: border-width border-style border-color;

background-color: color;