Slip 10 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Employee (emp_no, name, skill, payrate) Position (posting_no, skill) The relationship between Employee and Position is Many to Many with day and shift as descriptive attribute. Constraint: Primary key, payrate should be > 0. Consider the above tables and execute the following queries: 1. Display skill of employees name wise. 2. Update the posting of employee to 220 whose skill is “Manager”.

Solution:

Post a Comment

0 Comments