Thursday, August 13, 2020

Harry Potter Database

 This database created by me. I hope this database would be interesting for Harry Potter lovers. 


Consider the database of  Hogwarts School of Witchcraft and Wizardy.


                                Student Table

House Student

                           House


House_Head

                          Instructor 


i. Find the Student details whose name ends with “Potter". 

ii. Find out the name of the teacher who teaches "Potions".  

iii. Show the names of the students who belong to the Pure Blood in descending order.   

iv. Find out the name of the head instructor of "Gryffindor” house".  

v. Find out who is the founder of "Slytherin" House?  

vi. Change the name of  “Ginny Wasely” to “Ginny Potter”.  

vii. Show the total scores of each house.  Only include those houses that have total scores of more than 50.





No comments:

Post a Comment

How to Write Summary of a Research Paper

Paper Summary should contain the following points: What problem author’s solved? What are the motivations for that problem? Why is it import...