database SQL

Ok what i need in this assignment is to do SQL. BUT what i need more is to do this assignment in TEACHER WAY don't ever do it in your way if u CAN"T then don't ask me to choose u .He explain every thing in the Lecture note and the labs and he post some IMPORTANT details and i did upload every think in the ZIP file and i need it all correct, i have too get full marks if i don't i will fail . One more think i need it ASAP. thank u