Database Management SystemTU Board 2083
Consider the following simple database schema and write SQL statements for each of the following: Student(SID, SName, City, Faculty) Course(CID, CName, Credits) Enrollment(SID, CID, Grade) a. Use…
10Consider the following simple database schema and write SQL statements for each of the following:
Student(SID, SName, City, Faculty) Course(CID, CName, Credits) Enrollment(SID, CID, Grade)
a. Use CREATE TABLE statement to create Student, Course and Enrollment table assuming appropriate data types for attributes. b. Insert a new student: SID=10, SName='Aarav', City='Pokhara', Faculty='BIT'. c. List the names of all students who are from 'Kathmandu'. d. Find the names of all students enrolled in the course named 'Database'. e. Update address of student to Kathmandu having SID = 10.
A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.
Discussion
Loading…
More Database Management System questions
Define entity, attribute and relationship with suitable example. Design a complete ER diagram for the following scenario: Scenario: A school has teachers and…TU Board 208310Explain transaction and ACID properties of a transaction in brief. What are different states of a transaction? What is a 'serial schedule' and why it is…TU Board 208310What is a Database Management System? List any 5 advantages of using a DBMS over a traditional file based system. Give one real life example of a DBMS…TU Board 20835Explain the Three Schema Architecture of a DBMS with diagram. Differentiate between logical data independence and physical data independence with one example…TU Board 20835What is a weak entity type? Give one suitable example of a weak entity with a diagram showing the weak entity, its owner entity, the identifying relationship,…TU Board 20835Define Domain Constraint and Referential Integrity Constraint. What happens when a DELETE operation violates referential integrity?TU Board 20835