Database Management SystemModel question
Consider a University database with three tables, where the primary keys are underlined as given below: student(SID, SName, SAddress, SEmail) studies(SID, CID) course(CID, CName, Credit hours) Give…
10Consider a University database with three tables, where the primary keys are underlined as given below:
student(SID, SName, SAddress, SEmail) studies(SID, CID) course(CID, CName, Credit_hours)
Give an expression in SQL for each of the following queries:
a. Insert data with values "S101", "Ram", "Lalitpur", and "[email protected]" in the student table. (2) b. Find names of all students whose address is "Kathmandu". (2) c. Find names of all students who study "Database Management System". (2) d. Count number of students who study "Database Management System". (2) e. Find names of all courses with credit hours greater than or equal to 3. (2)
A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.
Discussion
Loading…
More Database Management System questions
Mention any one difference between schemas and instances.TU Board 20251Define attribute inheritance.TU Board 20251List out any two data types used in SQL.TU Board 20251What is the importance of creating role?TU Board 20251Define Transitive dependency.TU Board 20251Write SQL query to remove an attribute named 'email' from Employee table.TU Board 20251