Question

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”.

Answer 1

Answer:

2तोते ने सात दिन का समय लेने के लिए राजा को क्या कारण बताया?