Practical Slip 18 - 2019 Pattern

 C Language:

Q1) Write a C program to generate following triangle up to n lines.

1

1 2

1 2 3

Q2) Write a program to calculate sum of following series up to n terms.

Sum=X-X

2

/2!+X3

/3!-......

(Note: Write separate user defined function to calculate power and factorial)

DBMS:

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

Game (game_name, no_of_players, coach_name)

Player (pid, pname, address, club_name)

Relation between Game and Player is Many to Many.

Constraint: Primary key, no_of_players should be > 0.

Consider the above tables and execute the following queries:

1. Display the name of club whose coach is “Mr. Sehwag”.

2. Update the game name of player to cricket whose name is “Mr Rahane”.

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

1. Display players from ‘Delhi’.

2. List all games which require more than 4 players.

3. Find the total number of cricket players of 'sports club”.

4. Display games having more number of players than that of football.

5. Display coach wise player details.