[Solved] Following Relations Ii Iii Iv V Vi Indicate Least One Key B Normal Form Relation C Find Bc Q37224781

Could I please get help on this?

For each of the following relations (i)(ii) (iii)(iv) (v) and (vi) a) Indicate at least one key. b) Which is the normal form of the relation? c) Find a BCNF decomposition if possible or present a 3NF decomposition otherwise. Show your work in all cases (a, b, c). I.е., don’t just show the result. R (course, instructor, schedule, classroom, student, grade) course -instructor; Fschedule, room) -» course; {course, student) -> grade R (supplierName, item, supplierAddress, itemPrice) supplierName -supplierAddress; {supplierName, item)-itemPrice R (branch, active, city, loanNo, customer, loanAmount) branch -» {active, city]; loanNo -» {branch, customer, loanAmount) (iv) R (licensePlate, year, model, driverLic,name, address, policyExpiration, policyType, deductible, coverage) licensePlate -» [year, model); driver-Lic → {name, address); licens ePlate, policyExpiration, driverLic, policy:Type) → deductible; policyType -» coverage R (propertyld, county, lot, area, price, tax) propertyld – scounty, lot, area, price, tax); county, lot -» propertyld; area -» price; county- tax (vi) R (course, department, creditHours, level, instructor, semester, year, schedule, classroom,section) course department, creditHours, level); Fcourse, semester,year,section) -> {schedule, classroom, instructor]; classroom, schedule,semester, year) -[instructor, course, section)) Show transcribed image text For each of the following relations (i)(ii) (iii)(iv) (v) and (vi) a) Indicate at least one key. b) Which is the normal form of the relation? c) Find a BCNF decomposition if possible or present a 3NF decomposition otherwise. Show your work in all cases (a, b, c). I.е., don’t just show the result. R (course, instructor, schedule, classroom, student, grade) course -instructor; Fschedule, room) -» course; {course, student) -> grade R (supplierName, item, supplierAddress, itemPrice) supplierName -supplierAddress; {supplierName, item)-itemPrice R (branch, active, city, loanNo, customer, loanAmount) branch -» {active, city]; loanNo -» {branch, customer, loanAmount) (iv) R (licensePlate, year, model, driverLic,name, address, policyExpiration, policyType, deductible, coverage) licensePlate -» [year, model); driver-Lic → {name, address); licens ePlate, policyExpiration, driverLic, policy:Type) → deductible; policyType -» coverage
R (propertyld, county, lot, area, price, tax) propertyld – scounty, lot, area, price, tax); county, lot -» propertyld; area -» price; county- tax (vi) R (course, department, creditHours, level, instructor, semester, year, schedule, classroom,section) course department, creditHours, level); Fcourse, semester,year,section) -> {schedule, classroom, instructor]; classroom, schedule,semester, year) -[instructor, course, section))

Expert Answer

---

Answer to For each of the following relations (i)(ii) (iii)(iv) (v) and (vi) a) Indicate at least one key. b) Which is the normal … . . .