based on the following abbreviated description of Avery universitys course scheduling and student advising procedures, prepare an entity-Relationship (E-R) diagram that reflects the key entities and relationships .

Problem (20 points) 1. Based on the following abbreviated description of Avery University's course scheduling and student advising procedures, prepare an Entity-Relationship (E-R) diagram that reflects the key entities and relationships. Course Scheduling In consultation with the vice-president of Academic Affairs and the Registrar's Office. each academic department chair decides which courses will be offered cach semester and how many sections of each course will be scheduled. Courses are scheduled in sections meeting at different times over the course 4. Which of the following commands allow us to join data across information that are of interest? multiple tables to link specific picces of a. select b. project e. join d. display ANSWER 5. In a relational database, the entity is represented as a(n) a. table b. network c. field d. attribute ANSWER 6. Which is not a step in creating a relation using SQL? a. assign the relation a name b. assign cach attribute a name c. specify the constraints on the attributes d. specify the attributes of the constraints ANSWER: 7. Which is not an SQL command in which data can be changed in the database? a. INSERT b. DELETE C. UPDATE d. CREATE