ar Roy CSE 3104: DATABASE LAB GROUP: C2 || ONLINE: 02 DATE: 29/12/21 Mr. Peter has recently been appointed as a database design specialist at Meena Bazar, one of the biggest supermarkets. His responsibility is to design a database for maintaining information about their customers, products, and daily transactions, were During registration customers asked about their names, addresses(street information, area code, country), and phone numbers. The length of a phone number must be 11 in the case of Bangladesh, but the length may vary for other countries. Though each customer has a unique customer ID, their phone aber is usually to identify customers. They maintain a separate table to track the quantity, per unit prices of products. Each product has a unique name and ID. The amounts and prices are always non-negative. The default value should always be zero if the quantity is not given while inserting product information Furthermore, each transaction record contains information regarding who the buyer is, which products are, and when the order is placed. All buyers and products should be valid. Can you help Mr. Peter to design the database? You have to define the primary key for each table. And use constraints properly where they are needed. Write SQL statements regarding 1. How to define each constraint while creating tables, 2. How to drop constraints from the table, and 3. How to define them on an existing table again