Question 3

1. Write the DML codes to create each of the tables shown above [4 Marks]
2. Write the DDL codes to insert the data into the tables as shown above. [4 Marks]
3. Identify the Superkeys for staff relation. [5 Marks]

d) Based on the tables of the above given schema, write SQL integrity enhancement features for the following constraints:

1. bookID in Borrow must be the one that exist as code in Book .
2. Salary must be an integer value above 0.
3. joinedDate is not present or future dates.

i want code in the sql magement to run get output .

RENCES MAILINGS REVIEW VIEW FORMAT FORMAT Book thor publishes praby AK. Allen McGraw Hill 2001 ianNo 74895841 2003 5 8663571 1999 851447356 00001 An Introduction to Database Systems 0000s Introduction to Relational Database 00025 Programming with Visual Bassic 00107 Mathematics for Engineering 03567 Fundamental of Programming 00267 Engineering Mathematics 00251 Engineering Mathematics R. Torlone Addison Wesley N.B. Grag Prentice Hall T. Date Addison Wesley W. Loute Prentice 2000 956482550 2004 1551648 WC Evans Oxford 2005 4478568 D. Woods Prentice 2003 29212655 Selangor 26612500 15-Jan 05 SE Lecturer M Lang Chong Duta Pipa Vitage N5740 W 1712. Penang 120322100 1 Country 05 Secretary F 510010 Chan W 56A Jalan 2/14. K O -3256700F wa Taman Midah Lumpur 1510020 Nichole12-31 Porsang 016-6752850 F nicholotane Tan a n Mewah malcom Taman Merdeka 510121 Mohd. 34 san KL Melaka M Azman Kampungan hotmail.com 1510200 Vis Lot Lebuh Penang 017-2545695M holloVijay Timur, Katamas gmail.com 511090 Fong 31, Black Pinang 013574105F strong Slow Ting Jalan Pro/ yahoo.com Sapura Height Predana Penang 2000 20 Sun 05 ADM Secretary 300 M O SC Lecturer M bookID o 2000 ng Maro F AS4700 Yong H Ver SSC 00025 00107 00005 1800 May SE student ID 10010 11094 11094 10121 10020 10020 Mad 24 00107 00001 1000 od 15 w Los 00005 RENCES MAILINGS REVIEW VIEW FORMAT FORMAT Book thor publishes praby AK. Allen McGraw Hill 2001 ianNo 74895841 2003 5 8663571 1999 851447356 00001 An Introduction to Database Systems 0000s Introduction to Relational Database 00025 Programming with Visual Bassic 00107 Mathematics for Engineering 03567 Fundamental of Programming 00267 Engineering Mathematics 00251 Engineering Mathematics R. Torlone Addison Wesley N.B. Grag Prentice Hall T. Date Addison Wesley W. Loute Prentice 2000 956482550 2004 1551648 WC Evans Oxford 2005 4478568 D. Woods Prentice 2003 29212655 Selangor 26612500 15-Jan 05 SE Lecturer M Lang Chong Duta Pipa Vitage N5740 W 1712. Penang 120322100 1 Country 05 Secretary F 510010 Chan W 56A Jalan 2/14. K O -3256700F wa Taman Midah Lumpur 1510020 Nichole12-31 Porsang 016-6752850 F nicholotane Tan a n Mewah malcom Taman Merdeka 510121 Mohd. 34 san KL Melaka M Azman Kampungan hotmail.com 1510200 Vis Lot Lebuh Penang 017-2545695M holloVijay Timur, Katamas gmail.com 511090 Fong 31, Black Pinang 013574105F strong Slow Ting Jalan Pro/ yahoo.com Sapura Height Predana Penang 2000 20 Sun 05 ADM Secretary 300 M O SC Lecturer M bookID o 2000 ng Maro F AS4700 Yong H Ver SSC 00025 00107 00005 1800 May SE student ID 10010 11094 11094 10121 10020 10020 Mad 24 00107 00001 1000 od 15 w Los 00005