Slip 18 - C) 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”.

Solution:

Post a Comment

0 Comments