Shows An ER Scheme For A Database That May Be Used To Keep Track Of Part Of An University System. Map This Schema Into A Relational Schema, And Specify All Primary Keys And Foreign Keys ODOSIEDOT STATE COURO STUDENTS ADDRESS COURSE STUDENTO (IN M COURSE STUDENT ON) (1. COM ON N) LECTURER SUBJECTS (0.1) Figure 3: University System ER

Question 3 Figure 3 shows an ER schema for a database that may be used to keep track of part of an University system. Map this schema into a relational schema, and specify all primary keys and foreign keys. DOOR STREET CITY STATE COURSE STUDENT NAME ADDRESS COURSE A STUDENTO N Mi STUDENT Attends COURSE (11) HOBBY Teaches HAS DOB (0,M) (LN) LECTURER (0,1) SUBJECTS SULLECTO (1.1) SUBJECT NAME ACTURER I LECTURER NAME) Figure 3: University system ER diagram Solution: