Slip 26 - C) 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.
0 Comments