Practical Slip 10 - 2019 Pattern

 C Language:

Q1) Write a C program to accept the x and y coordinate of a point and find the quadrant in which the point lies.

Q2) Write a program, which accepts a number n and displays each digit in words.

Example: 6702 Output = Six-Seven-Zero-Two

DBMS:

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

Q4) Consider the above tables and execute the following queries: 

1. Find the names and rate of pay of all employees who has allocated a duty.

2. Give employee number who is working at posting_no. 201, but don’t have the

skill of waiter.

3. Display a list of names of employees who have skill of chef and who has assigned a duty.

4. Display shift wise employee details.

5. Update payrate of employees to 20000 whose skill is waiter.