This is the Indian premier league ER diagram Using the steps translate the Given

Question

This is the Indian premier league ER diagram

Using the steps translate the Given ER diagram to a set of relations. Please be sure to underline primary kets. Normalize relations to Highest possible form.. For each opportunity to combine or decompose relations, decide whether or not to do so and explain your reasoning briefly..

batsman ER Diagram O Nama alrounder Captan Ranking B.ld M Date Match Captain Play Nationalty Team City for CtWame DESCAIPTION OF THE INDIAN PREMMER LEAGUE DATABASE DESIGN Our team is designing a database structure for Indian Premier League. Indian Premier league (PL) was created in 2008. t is a professional league for Twenty20 cricket chamcionship plaved in India It was started by the Board of Control for Cricket in Idia

Explanation / Answer

The given ER diagram when converted to relational schema, gives 10 tables. This includes entities and relationship converted to tables. Below is the list of tables with attributes. Primary key is mentioned as underlined attribute and foreign key as bold.

Team (TName, cups, City)

Sponser (S_Id, SName)

Owner (O_Id, OName)

Coach (C_Id, CName, TName)

Match (M_Id, M_Date, M_Location)

Team_Match (TName, M_Id)

Player (P_Id, Name, Ranking, Nationality, Vice_Captain, bowler, batsman, allrounder)

Team_Player (TName, P_Id)

Team_Sponser (TName, S_Id)

Team_Owns_by (O_Id, TName)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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