Slip 16 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Employee (emp_id, emp_name, address) Investment (inv_no, inv_name, inv_date, inv_amount) Relation between Employee and Investment is One to Many. Constraint: Primary key, inv_amount should be > 0. Consider the above tables and execute the following queries: 1. Display the details of employee who has invested amount in “Mutual Fund”. 2. Add column Phone_No in Employee table.
Solution:
0 Comments