Project part 1

Introduction to Database Applications

Spring 2022 – Project

Part 1

Jonas Spacely owns a comic book and collectables shop in Denton. He approaches you to design a

database for his business to help him track purchases for his new loyalty program. Specifically, Jonas

wants to be able to track the purchases a customer makes and the points they earn on each purchase.

The way the points system is configured, customers get an identification number they give the cashier

when they check out. They then earn 10 points for each pre-tax dollar they spend in his store. Jonas

also wants to track the points that customers redeem as well as what they redeem the points for.

Below is an example of a sales receipt from the store:

Spacely Comics

Customer No:

SKU Description Qty Price Total

000000001 Amazing Spider Man No.73 1 $10.00 $10.00

222222222 Cayde-6 Bobble Head 1 $19.99 $19.99

Total: $29.99

Here are the items the customers can redeem points for and the number of points required for each:

Award Points

$5 Store Credit 1000

$10 Store Credit 1500

$20 Store Credit 2500

Jonas also wants to be able to gather customer information for marketing. Specifically, he wants their

address, phone, and email. He also wants to know their birthday to send special promotions out (if they

want to share).

Based on the information given here, start the design of a database for Jonas by constructing a Crow’s

Foot ERD. There are a few ways you can do this. That is by design. You will need to learn to start make

some design choices for yourself (I am taking the training wheels off!). Make sure that all attributes are

broken down to the appropriate level of atomicity and that your design is in at least 3rd NF.

I want you to be as detailed as possible with your design, but I don’t want you to stress about missing

some small items. This is all part of the learning experience!