Create given tables with your roster last name followed by your college ID (for example, I would create REP table as REP SHAH 0111111, where SHAH is my last name and 0 is my college ID) with provided column names. Fail to do so will result in 0 points for the assignment. Use most appropriate data types for each column based on data in it. Use DEFAULT value 0 for Balance column in CUSTOMER table. Identify PRIMARY KEY for each table, name and define it at the time of table creation. Copy your CREATE statements in a file as you will submit them. Add a new table: CATEGORY (CatId, CatDesc) with Catld with same data type as Category field in the ITEM table. Add a PaymentStatus column to ORDER table to store 'P' or 'U' (paid or unpaid) data in the future. - Use created tables to add FOREIGN KEY, NOT NULL, UNIQUE and CHECK constraints with the ALTER statement, as appropriate INSERT given records in to the tables. For CATEGORY table, use CatID from ITEM table's Category column and use appropriate CatDesc. Add a record for yourself in the CUSTOMER table and create appropriate record in ORDERS and ORDERLINE table for you as a customer ordering items