[Solved]-Qatar University Dept Computer Science Engineering Fundamental Database Systems Cmps351 Sp Q37248511
Qatar University Dept. of Computer Science & Engineering Fundamental of Database Systems (CMPS351) Spring 2019 QATAR UNIVERSITY HW3 Q1) Given the following extension (state) TUPLE# 10 10 c2 12 13 14 which of the following dependencies may hold in the above relation? If the dependency cannot hold explain why by specifying the tuples that cause the violation Q2) Check if the following schema in 3NF or not, if it is not, then convert it, showing steps for INF and 2NF LiberaryBranch (B#, Address, (ISBN, Title, Author, Publisher, publisher-Adderss, Num_copies) Supervisor (ID name. P Car a) b) project Title. (st,name)) Sale(cart.date sold.(salePerson#.name). Commission) Q3) Design Database schema to trach project’s data according to the following form, ensuring that your design is in 3NF Project Management Report Project Code: Project Title: PCO10 Pensions System Project Budget: Project Manager:MPhillips 624.500 Employe Employee Department No. Department Name Name No. Rate S10001 S10030 S21010 £22.00 £18.50 £21.00 £26.00 A Smith L Jones P Lewis R Smith L023 L004 L003 Pensions IT Programming Show transcribed image text Qatar University Dept. of Computer Science & Engineering Fundamental of Database Systems (CMPS351) Spring 2019 QATAR UNIVERSITY HW3 Q1) Given the following extension (state) TUPLE# 10 10 c2 12 13 14 which of the following dependencies may hold in the above relation? If the dependency cannot hold explain why by specifying the tuples that cause the violation Q2) Check if the following schema in 3NF or not, if it is not, then convert it, showing steps for INF and 2NF LiberaryBranch (B#, Address, (ISBN, Title, Author, Publisher, publisher-Adderss, Num_copies) Supervisor (ID name. P Car a) b) project Title. (st,name)) Sale(cart.date sold.(salePerson#.name). Commission) Q3) Design Database schema to trach project’s data according to the following form, ensuring that your design is in 3NF Project Management Report Project Code: Project Title: PCO10 Pensions System Project Budget: Project Manager:MPhillips 624.500 Employe Employee Department No. Department Name Name No. Rate S10001 S10030 S21010 £22.00 £18.50 £21.00 £26.00 A Smith L Jones P Lewis R Smith L023 L004 L003 Pensions IT Programming
Expert Answer
Answer to Qatar University Dept. of Computer Science & Engineering Fundamental of Database Systems (CMPS351) Spring 2019 QATAR UNI… . . .
OR
