4G: : D SQL_Mini Project... px se ji zkusis > Choose any database of your choice except the one used in the course. If you choose any of these, you will get zero marks. Consider the following parameters while creating the database and its tables 1. Minimum 4 (four) tables must be specified and normaliza 2. Each table must consist of 6 attributes (columns) 3. Primary key (for all tables). Foreign Key, Unique Key. Check and Not Null constraints must be applied on columns in each table wherever required 4. At least one date column and one number column should be there in at least two tables Based on the above information, write SQL statements to: Create tables and set relationships among them. Define the referential integrity constraints at the table level and all other constraints at the column level (1 mark) at records cach table (1 mark) Son the rows/records of any table using multiple columns in which one column must be with number datatype and other one must be with non-numeric datatype. (0.5mark) Use any two (2) case manipulation functions on any of the above tables (0.5 mark) Use any two (2) character manipulation functions on any of the above tables. (0.5 mark) 2 Insert least * Use any two (2) number manipulation functions on any of the above tables. (0.5 mark) Use any two (2) date manipulation functions on any of the above tables (0.5 mark) Use any two (2) logical operations in a single query according to the precedence on any of the above tables. (0.5 mark) Apply NVL and NULLIF functions on any of the above tables. (0.5 mark) to Use any two (2) nested functions in the query on any of the above tables (0.5 mark) Add a new colunt of timestamp data type to any of the tables created above and insert value in at least on row in that column. (0.5 mark) in Make comments for all the above created tables and display all comments from the data dictionary 4G+: : SQL_Mini Project... pus Jl clases > column (0.5 mark) 13 Make comments for all the above created tables and display all comments from the data dictionary (0.5 mark) Write a single row subquery using my two (2) tables. (0.75 mark) * Write a single row subquery using the same table in inner and outer queries (0.75 mark) ts. Write a multiple row subquery with group by clause on any two (2) tables (1 mark) Write multiple-column subquery using any two (2) tables. (1 mark) Write an Inner join query using any two (2) tables (0.75 mark) Write a join query with ON clause using any two (2) tables (1 mark) Write a cross join query using any two tables for all possible combination TOWS both tables (0.75 mark) > Write a full outer join query using any two tables (1 mark) from Create at least one simple and one complex view using any of the above tables. Choose attributes and condition of your choice. (1 mark) Note: Kindly refer to the Evaluation criteria for more information and clarity Evaluation Credivalide for atar! Then we Amidale formatie Loco Parys Excel The Tube vais Lise vahel het Cards Gole des conditions for differy Scaching Topic Query please be from.com Sources of Information/ProQuest References: 1. Oracle SQL: A Beginner's Tutorial 2. SQL practical Guide for developers 3. Beginning SQL Other instruction