Final Exam You were hired as a Database administrator by a university. The establishment has campuses in 4 different cities: Rabat, Casablanca, Fes and Marrakech. The idea behind this database is to...

Answer the 7 questions and show database creation


Final Exam You were hired as a Database administrator by a university. The establishment has campuses in 4 different cities: Rabat, Casablanca, Fes and Marrakech. The idea behind this database is to be able to keep track of students records, contact information, courses taken and grades. After thoughtful consideration below are some of the entities/relations and their attributes: Student(Student ID, First name, last name, CIN, Address, Phone Number) Course (Course ID, Course Name, Campus ID, Number Of Hours) Campus (Campus ID, Campus name, Campus Phone, Campus address) Course Grades (Student ID, Course ID, Course Grade) Semester Grade (Student ID, Final Grade) 1- Which of the above items are entities, and which ones are relations 2- Which of the Attributes for student would you use as component, multivalued or derived. 3- What are the candidate keys for student and Course 4- What is the Primary Key Student and Course? Justify your choice 5- Draw the ER model for the database 6- Using Relation algebra, answer the following questions Show the names of the students who received more than 90 in the course code ISD100. 7- Answer the same above question using SQL.