Slip 2 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Sales_order (ordNo, ordDate) Client (clientNo, ClientName, addr) The relationship between Client & Sales_order is one-to-many. Constraints: - Primary Key, ordDate should not be NULL. Consider the above tables and execute the following queries: 1. Add column amount into Sales_order table with data type int. 2. Delete the details of the clients whose names start with ‘A’ character.

Solution:



Post a Comment

0 Comments