F.Y.B.B.A.(C.A.)/B.C.A.SEMESTER I - SOLVED PRACTICAL SLIP 10(C-PROGRAMMING AND DBMS)@aishashaikh2717

F.Y.B.B.A.(C.A.)/B.C.A. SEMESTER I - SOLVED PRACTICAL SLIP 10(C-PROGRAMMING AND DBMS)@aishashaikh2717
Q1. Write a C program to accept the x and y coordinate of a point and find the quadrant in
which the point lies. [15 Marks]
Q2. Write a program, which accepts a number n and displays each digit in words.
Example: 6702 Output = Six-Seven-Zero-Two [25 Marks]
Q3. Consider the following entities and their relationships. Create a RDB in 3 NF with
appropriate data types and Constraints. [15 Marks]
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 greater than 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: [25 Marks]
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.

Видео F.Y.B.B.A.(C.A.)/B.C.A.SEMESTER I - SOLVED PRACTICAL SLIP 10(C-PROGRAMMING AND DBMS)@aishashaikh2717 канала Aisha Shaikh