Slip 5 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Customer (cust_no, cust_name, address, city) Loan (loan_no, loan_amt) The relationship between Customer and Loan is Many to Many Constraint: Primary key, loan_amt should be > 0. Consider the above tables and execute the following queries: 1. Add Phone_No column in customer table with data type int. 2. Delete the details of customer whose loan_amt < 1000

Solution:

Post a Comment

0 Comments