SEU Salesman and Customer tables Programming Questions

Assignment 2Question 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.