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

I want to confirm that I did this correctly.

I need the following or steps to go about doing them correctly

 

1. the data type for project_name?

2. Describe how data in tables are related. Justify your answer using an example from the data provided in the tables. use connectivity and cardinality to explain your answe

 

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

 

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

 

 

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

 

 

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

 

 

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

 

 

 8. SQL statement to display the name and id of projects with "smart" anywhere in the name field. 

 

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

 

 

10. 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.