university would like to keep track of its students' transcripts (1) The university keeps track of each student's name, student number, social security number, current address and phone, permanent address and phone, birthdate, sex, class (such as freshman, sophomore, ..., graduate), major department, minor department (if any), and degree program (such as, B.A., B.S.,, Ph D.). Some user applications need to refer to the city, state, and zip code of the student's permanent security number and student number have unique values for each student. address and to the student's last name. Both social (2) Each department is described by a name, department code, office number, office phone, and (3) Each course has a course name, description, course number, number of semester hours, level, (4) Each section has an instructor, semester, year, course, and section number. The section number college. Both name and code have unique values for each department. and offering department. The value of course number is unique for each course distinguishes sections of the same course that are taught during the same semester/year, its values are 1,2,3,..., up to the number of sections taught during each semester (5) A grade report has a student, section, and letter grade (A, B', 'C, 'D', or 'F) An ER model to represent the data requirements is shown in Figure 7 Artwork Artist ItemTitle 0..1'ArtistName Ga s loanedItemType DOB DeathDate develops ItemSize GalleryName GalleryCit Height Width Weight ItemMuseumLocation participates Show ItemLoanDate ItemReturnDate .showCity ShowStartDate ShowEndDate Figure 1. ER model for the art museum database