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,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!