Practical 1:
Use the file below: DB_ex1a.doc
Practical 2:
Complete the quiz
http://www.w3schools.com/sql/sql_quiz.asp
Activities 4 - 7 in textbook
Homework:
Textbook Short questions: Q4, 5
Long questions: Q1,2
Submit on or before 2nd June 8:20a.m.
Classwork Q4. Insert statement can be found in MySQL2_insert.txt below
CARS
registration char(6)
make char(10)
model char(10)
coloor char(6)
engine_size integer numeric(6,0)
price numeric(10,0)
door integer
sunroof char(3)
automatic char(3)
mileage numeric(10,0)