Course: Database Management System

Please Solve the Question

Q1 (10 marks): Extract and write down the DB Schema for the following E-R Diagram. You need to write the name, attributes, and keys (need to be underlined) for each relation in your schema. code result Exam sin description pfname (D, N) (0, N) Patient Under Takes cost plname (0, N) sex start_date end_date (1, N) (D, N) Hosted By doctorld start_date tel office (1, 1) (1, N) rooms Doctor Worksin Clinic diname cname (1, 1) (1, 1) diname Specialty Manages