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

F.Y.B.B.A.(C.A.)/B.C.A. SEMESTER I - SOLVED PRACTICAL SLIP 9(C-PROGRAMMING AND DBMS)@aishashaikh2717
Q1. Write a C program to accept a character from the user and check whether the character is a vowel or consonant. [15 Marks]
Q2. Write a program to accept two numbers as range and display multiplication table of all numbers within that range. [25 Marks]
Q3. Consider the following entities and their relationships. Create a RDB in 3 NF with
appropriate data types and Constraints. [15 Marks]
Property (pno, desc, area, rate)
Owner (owner_name, addr, phno)
The relationship between owner and Property is One to Many.
Constraint: Primary key, rate should be greater than 0
Consider the above tables and execute the following queries:
1. Display area of property whose rate is less than 100000.
2. Give the details of owner whose property is at “Pune” .
Q4. Consider the above tables and execute the following queries: [25 Marks]
1. Display area wise property details.
2. Display property owned by 'Mr.Patil' having minimum rate.
3. Delete all properties from “pune” owned by “Mr. Joshi”.
4. Update the phone Number of “Mr. Joshi” to 9922112233 who is having
property at “Uruli Kanchan”.
5. Delete column address from Owner table.

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