3.2 Consider the following ER diagram and answer the questions that follow Depar

Question

3.2 Consider the following ER diagram and answer the questions that follow Department id (PK) id (PK) Has 1.1 name nam Manages fname phone 1..0 1.1 Iname phone address Use the reduction techniques you leaned in Chapter 12 to map the diagram to relational schemas. (2 points) 3.2.1 Fill in the table below to indicate the foreign keys in the schemas you obtained in the previous step and the primary key that corresponds to each foreign key: (I point) 3.2.2 Schema Schema Corresponding Primary Key Foreign Key

Explanation / Answer

3.2.1 Relational schema

Department(id, name, phone)

Employee(id, name(fname, lname), phone, address)

3.2.2

Foreign key Schema Corresponding Primary Key Schema name Employee id Department

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.