Use $$Kickstarter$.$accdb$$ Access file to answer the questions.

Database Information:

Kickstarter.accdb contain two tables:

Creator Table contains creator information; $($Fields: creator$\_$id$,$ creatorname, is$\_$superback $($i$.$e$.,$ whether the creator is also a super backer in Kickstarter$)),$

Project Table contains project information; $($Fields: project$\_$id$,$ project$\_$name, goal, pledged, state, country, currency, currency$\_$symbol, deadline, created$\_$at$,$ launched$\_$at$,$ staff$\_$pick, backers$\_$count, static$\_$usd$\_$rate, creator$\_$id$,$ category, spotlight$)$

Submit your SQL statements ONLY in the space provided below.

Test SQL statements before submission.

Partial marks are only provided for $2\mathrm{.}7$ and $2\mathrm{.}8$;

For all other questions no partial marks $($incorrect SQL statements will be marked as ZERO$).$

In each question, your query can only display the required data. More or less are marked as wrong.

Q$1$: Data Type and Entity$-$Relationship

$1$ Mark

What is the data type for project$\_$name?

$0\mathrm{.}25$ Marks

Describe how data in tables are related. Justify your answer using an example from the data provided in the tables. $($Hint: use connectivity and cardinality to explain your answer$)$

$0\mathrm{.}75$ Marks $(0\mathrm{.}50$ Describe; $0\mathrm{.}25$ Example$)$

Q$2$: SQL

$4$ Marks

Write a SQL statement to display project names, state and category of all the projects.

$0\mathrm{.}30$ Marks

In the previous question, state is repeatedly shown. Write a SQL statement to display the distinct states of all the projects.

$0\mathrm{.}20$ Marks

Write a SQL statement to display the name, goal, pledged, and deadline for live projects.

$0\mathrm{.}5$ Marks

Write a SQL statement to display the name, goal, pledged, and category for successful, cancelled, and suspended projects.

$0\mathrm{.}5$ Marks

Write a SQL statement to display the name, goal, pledged, and deadline for the projects with a backers count between $500$ and $1000.$

$0\mathrm{.}5$ Marks

Write a SQL statement to display the name and id of projects with $$smart$$ anywhere in the name field.

Marks

Write a SQL statement to display the unique creator names who have live projects.

$0\mathrm{.}5$ Marks

Write a SQL statement to display category and number of projects for each category to show the category popularity based on the number of projects? Rename the frequency column as $$Popularity$$ in the above SQL$.$

$($Hint: Use COUNT, GROUP BY$,$ and AS$.$ Use the $$COUNT$$ function to get the project count.$)$