In one planet every human has been treated equally, they were getting their sala

Question

In one planet every human has been treated equally, they were getting their salary based on their skills, A human can perform man tasks based on his skills. More skills humans get more salary then less ones with respect to formula.

Humans(did,name,skill,salary,task)

Salary of human calculated as: salary=skill#+1

a) Does the relational schema contain anomalies? Specify the anomalies if they exist and propose a way to solve them. b) Are there any redundancies in this schema? Give clear examples of such redundancies by drawing a table view of the entries inside this table.

Explanation / Answer

a) Yes. the database does contain anomalies. Considering that the name is a unique attribute one human can have multiple skills or one human can have single skill and perform multiple tasks. Hence causing multiple data redundancy.

Normalizing it to 3NF will resolve this redundancy

eg:

  Did  

  Name  

  Skill  

  Salary  

  task  

  101  

  abcd  

  java  

  30000  

  Database management  

  C++  

  python  

  102  

  Pqrs  

  Matlab  

  10000  

  Calculate execution time of bubble sort  

  103  

  xyz  

  Asp.net  

  10000  

  Shopping website  

  College website  

  Traffic controller software  

  Security system  

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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