Practical Slip 9 - 2019 Pattern

 C Language:

Q1) Write a C program to accept a character from the user and check whether the character is a vowel or consonant.

Q2) Write a program to accept two numbers as range and display multiplication table of all numbers within that range.

DBMS:

Q3) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints.

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 > 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: 

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.