****** * Name: YourNameGoesHere * Class: CST 235 * Date: * I have not received or given help on this assignment: YourName ********** ******* DROP DATABASE IF EXISTS Lab3 Your LastName; CREATE DATABASE Lab3YourLastName; USE Lab3 Your LastName; /***** Task 1: create tables ******* CREATE TABLE /***** Task 2: uncaptured constraints put your response here ****** */ /***** Task 3: Add records ******* */ INSERT INTO ... ****** * * * * ***** a) Write SQL statements to create the corresponding relations and capture as many of the participation and cardinality constraints as possible. Make sure that the data type and size for each attribute are appropriate. b) If some constraints in the diagram cannot be captured, explain why. c) Write SQL statements to insert at least two tuples for each table ReceivingDate shippingDate payAmount IName ordDate fName password payMethod custID OID Phones N Orders Places 1 Customers N Contains M price qty iID Items qtyInStock name price

Convert this ER model to a list of tablesProvide the queries that implement the database

Prepare a MySQL script that creates your database, tables, and inserts a small sampling of madeupdata. Test it out in MySQL before submission For the below diagram write the SQL queries

The DBA denormalized certain data in the TAL Distributors database to improve speed, and one of the resultant tables looks like this: It has been determined that the Customer table is not in third normal form due to one or more of the following fields: CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum, or RepName. In this scenario, what is the normal form of the denormalized table?