Practical Slip 26 - 2019 Pattern

 C Language:

Q1) Write a C program to calculate length of string without using standard functions.

Q2) Write a program to display the elements of an array containing n integers in the

Reverse order using a pointer to the array.

DBMS:

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

Gym (Name, city, charges, scheme)

Member (ID, Name, phoneNo, address)

Relation between Gym and member is one to many.

Constraint: Primary Key, charges must be greater than 0.

Consider the above tables and execute the following queries:

1. Display the scheme details of “Gold Gym”.

2. List out all the gym of “Pimpri” city.

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

1. Give the details of scheme to which “Mr. Patil” is admitted.

2. List out gym wise members.

3. List out scheme wise charges.

4. Display all the members from pune city who have paid Gym charges more than

10000.

5. Drop column address from Member table.