Database: E$-$R Modeling and SQL

Learning Outcome$($s$)$:

This assignment introduces students to basics of MS Access and SQL$.$ Students should be able to;

USE a dataset in Access format

EXPLAIN the relationship between entities

APPLY SQL to retrieve the required information from a database

Background Information and Instructions

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$)$