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”.
Answers
Answered by
2
Answer:
2तोते ने सात दिन का समय लेने के लिए राजा को क्या कारण बताया?
Similar questions