Question: e registration system ame, lastName, streeetAddr ipcode) courseNumber, section Number, year, semester,course ile,os, instructor) RegisteringForCourse( Number, soureld) ess, city, tate, a).In the relation(table) Course, do
e registration system ame, lastName, streeetAddr ipcode) courseNumber, section Number, year, semester,course ile,os, instructor) RegisteringForCourse( Number, soureld) ess, city, tate, a).In the relation(table) Course, do you find another key among, the anritest W ys do i attributes of the key you found.(7 pts) ioor b).Do you see any table that implements a relationship? If you do, describe how table(representing a relationship) relates other tables/entities)? (7ps) ie c).Writ on that will return all the courses that all the stuent The result set should have the attributes: jNumber, firstName, lastName, courseNumber, pts) sectionN umber, year, and semester. Also write a relational algebra expression to dotum e a relational algebra expressi d). Write a relational algebra expression that will etm Namber, fist students who take Ann Smith's courses. (9 pts)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
