Question: Consider the example School database shown in class with the Student, Teacher, Class, Contact Info, and Student Class tables. You need to revise the database

Consider the example School database shown in class with the Student, Teacher, Class, Contact Info, and Student Class tables. You need to revise the database because a class can have multiple sections with different teachers 4. [15 points] Use ERDPlus to draw an entity-relationship (ER) diagram for your revised database. Include attributes and cardinalities. a. b. [15 points] Use ERDPlus to draw the relational schema as mapped from your ER diagram. Your revised tables must be in second normal form (2NF) [10 points] Write the SQL for the query, "Who teaches Java programming and in which sections?" c
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
