Create table and entity in such a way so that you can apply all the functions and commands such as SELECT, FROM, WHERE, Sum, Avg, Count, Max, Min, IS Null/IS Not Null, Order, AND, OR, conditional (>,<, =, >=, <= etc)

After preparing database in access file, you also need to submit a document (MS Word) file consisting of:

o Description of each table (Within 3-4 sentences)

o Image of ER diagram (from access file) of your database

o List 15 questions/queries, SQL codes of those queries and an image of each output which will be derived after running SQL code , WHERE, Sum, Avg, Count, Max, Min, IS Null/IS Not Null, Order, AND, OR, conditional (>,<, =, >=, <= etc).

A WORD FILE SAMPLE OF THE TASK IS ATTACHED. KINDY GIVE YOUR EMAIL SO THAT I CAN MAIL YOU THE ACCESS FILE.