Salesman and Customer tables Programming Questions-SEU .

Assignment 2 Question One Pg. 01 Learning Outcome(s): Question One 1.5 Marks From the Salesman and Customer tables below, write SQL statements to do the following: a) List the salesman id, rating and names of those salesmen who get rating from 3 to 5, sorted DESCENDING by rating. LO3 Create EntityRelationship model, Relational b) List all the customers’ information whose name starts with ‘F’ and the fourth character is ‘I’, rests may be any character. c) List the name and country of those customers and salesmen who belongs to the same country. model, and write SQL queries Salesman table: Customer table: Question Two Pg. 02 Learning Outcome(s): Question Two 1.5 Marks Write SQL statements to do the following on the database schema shown below. LO3 Create EntityRelationship model, Relational model, and write SQL queries. a) Insert a new record in the course table with the following data values course number = ‘COSC4390’ course name = ‘Knowledge Engineering’ course credit hours= ‘3’ department = ’COSC’>. b) Change the class of student ‘Ahmed’ to 4. c) Delete the record of the student whose name is ‘Ahmed’ and his number is 22. Question Three Pg. 03 Learning Outcome(s): LO3 Create EntityRelationship model, Relational model, and write SQL queries. Question Three 2 Marks Map the database schema shown in the following figure into a relational database schema.