Computer Tutorial

ASSIGNMENT 1 Define the schema for the following databases with specific data type and constraints, the table name and its fields name are to be taken from database description which are given below : A database is being constructed for storing sales information system. A product can be described with a unique product number, product name, selling price, manufacturer name. The product can sale to a particular client and each client have it own unique client number, client name, client addresses, city, pin code, state and total balance to be required to paid. Each client order to buy product from the salesman. In the order, it has unique sales order number, sales order date, client number, salesman number (unique), billed whole payment by the party or not and its delivery date. The salesman have the name, addresses, city, pin code, state, salary of the sales man, delivery date, total quantity ordered, product rate. Q.1.1. Write the SQL queries for the following – (a) Retrieve the