A few computing questions (PHP, HTML, JQuery, Javascript and MySQL)?

1. Describe two ways to ensure database transactions are executed atomically in MySQL

2. create table movies (

title varchar(120) not null,

year int(4),

director_name varchar(80) not null,

director_nationality varchar(80),

actor_name varchar(80),

role_name varchar(80),

primary key (title)

);

There are many faults with this database design.

Briefly describe two main faults with the design (ignoring any minor syntax errors).

Give an alternative database design for the application that corrects as many faults as possible, without introducing additional, unnecessary, details.

3. What are two key JavaScript features that makes Ajax applications possible?

4. Briefly describe two methods other than cookies for maintaining state in a typical dynamic web application.

5. Briefly describe three different methods for displaying an HTML page with a full-width header, two equal-height columns, and a full-width footer.

That's all for now.