Slip 25 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. College (code, college_name, address) Teacher (teacher_id, teacher_name, Qualification, specialization, salary, Desg) Relation between Teacher and College is Many to One. Constraint: Primary Key, qualification should not be null. Consider the above tables and execute the following queries: 1. List the name of staff having qualification is “SET-NET”. 2. Update the salary of teacher to 50000 whose qualification is “PhD”.

Solution:

Post a Comment

0 Comments