As agreed SQL AND DATABASE

In order to Q#4 , can you please add more details in the answer in which part that each point of the below is mentioned in the answer:

Joins (using two, three or more tables)

 Set operations (UNION, INTERSECT and MINUS)

 Ordering

 Grouping

 Aggregate functions (MIN, MAX, AVG, COUNT, SUM)

 T able aliases

 Renaming columns

 Sub-queries (nested queries)

You should aim to write at least ten sample queries – ranging from basic SELECT...FROM...WHERE queries to more advanced ones using the above techniques.

2.

I went through the material but unfortunately, it has a lot of missing required data. kindly check the below comments

Q1 ==> There is many empty fields (column) !

Q2==> The normalization is stopped at the third level and the question asked to be in BCNF form

Also, in this question, if you compare the table in the first form and second and third they are exactly the same no difference between them !!

Also, for the code in Q3

CREATE TABLE CUSTOMER (

CUSTOMERID INT NOT NULL PRIMARY KEY,

LASTNAME VARCHAR(100) NOT NULL,

LOCATIONID VARCHAR(100),

FNAME VARCHAR(30),

ZIPCODE VARCHAR(200),

ADDRESS VARACHAR(30),

ADDRESS VARCHAR(30), PHONE VARCHAR (200),

PRIMARY KEY (LOCATIONID)

Why is the address repeated?

Q4 and 5 as my previous email has no screenshots with the required output data

Can you please fix this issue and send me the new document

3. Also, in order to the below point

For the SQL work you must supply full code listings of the inputted code and

screenshots of the outputted results – even if no rows were returned. Each screenshot must include some identifying feature – such as a username or user ID – that proves beyond doubt that it is your own work.

There is no screenshot at all for the work, please provide me some screenshot showing the result for Q#4