database

Angeline Ortiz de los Santos

4/8/2023

ECPI University

1.10 Project

Part A: Student Description of Final Project (Instructor Approval)

I choose Retail Business – Candle Store

thorough description of the database including its function

For this project I will organize data for an online candle store. The Owner wants to organize data for the ordering process. The data that the owner wants me to store is candles ID, description, and price. Also, client information that includes client ID, name, address, phone number and email address. Finally, the order information that includes order ID, client ID and Candle ID.

Business rules

· Client can have multiple orders. However, orders can have only one client.

· Clients can order one or more candles.

Tables

· CANDLE

· CLIENT

· ORDER

attributes (fields)

· CANDLE

· CANDLE_ID (PK)

· CANDLE_DESCRIPTION

· CANDLE_PRICE

· CLIENT

· CLIENT_ID (PK)

· CLIENT_NAME

· CLIENT_ADDRESS

· CLIENT_PHONE

· CLIENT_EMAILADDRESS

· ORDER

· ORDER_ID (PK)

· CLIENT_ID (FK)

· CANDLE_ID (FK)

primary keys

· CANDLE_ID

· CLIENT_ID

· ORDER_ID