SUBJECT : DATABSE DESIGN AND DEVELOPMENT

QUESTION 4 Consider the following Entity Relationship Diagram (ERD) that shows a relationship between programmer and Programme. Write SQL statements for the following questions: PROGRAMMER Programmer_ID (PK) Programmer_Name Programmer_Position Programmer_Salary writes 1# PROGRAMME Programme_ID (PK) Programme_Language Programme_StartDate Programme_EndDate Programmer_ID (FK) a) Create PROGRAMMER table. (5 marks) b) List the programmer name, programme language and Programme start date for programmes that use the C++ language. Sequence the results in descending order by programmer name. (3 marks) c) List the different programme languages in descending order. (2 marks) d) Find the total number of programmers who finish writing JAVA programmes in May 2021. (5 marks) e) Add new attributes to the programmer's table: programmer telephone number. (2 marks) f) A programmer with the ID P123 has been promoted to a new position of F48. Update the position of this programmer