QUESTION 3 Copy of citv state street address phones name bDate name sDate ID len

Question

QUESTION 3 Copy of citv state street address phones name bDate name sDate ID lengthEmp Dependents Coverage Employees Convert the above ER diagram to relations in the normal manner to capture as many constraints as possible and then identify which of the following is a relation schema. O a Employees(ID, name, address, street, city, state, sDate, lengthEmp) O b Employees(ID, name, street, city, state, sDate, lengthEmp) Employees(ID, name, street, city, state, phones, sDate, lengthEmp Employees(ID, name, street, city, state, sDate) O d

Explanation / Answer

Here (C) Employee(ID,name,street,city,state,phones,sDate,lengthEmp) is Right Ans Because,

Address have three entity (street,city,state) you can take entity insted of Address, To represent such relationship the name as the Parent node must be placed within the Child table as a foreign key.

Address(city,street,state) here you consider frist tabel

Employee(id,name,sdate,lengthemp,phones) take second table

Dependent(name,bdate) another table

here name column is commen field that can you consider primary key

in employee table name is primary key and in dependent table name is forigen key.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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