Table of Contents
Topic Page
Purpose….………………………………………………………………………………………...2
Narrative….………………………………………………………………………………………2
Requirements (Actors/Roles) ….………………………………………………………..………4
Entities….………………………………………………………………………………………...4
Entities (w/Nested Attributes) ….……………………………………………………………….5
Business Rules….…………………………………………………………………………...……7
ERD….……………………………………………………………………………………….…...8
EERD….……………………………………………………………………………………….....9
1
This study source was downloaded by 100000860007226 from CourseHero.com on 01-29-2023 12:57:26 GMT -06:00
https://www.coursehero.com/file/65616667/1Dog-Salon-ERD-and-EERDpdf/
, Purpose
The purpose of this Database Design Documentation (DBDD) is to keep Dapper Dog
Salon business processes described below.
Narrative
Dapper Dog Salon is a pet salon located in the Tampa Bay area that serves many
customers every day. They pride themselves on ensuring that every dog that visits their shop
leaves looking better and smelling cleaner, with a wagging tail of satisfaction.
The dog salon register each customer to keep their information up to date and to have the
ability to contact customers. The Salon tracks each customer’s name, address, phone number,
email.
The Salon also tracks each dog’s name, breed, temperament, date of birth, and age. Dogs
are owed by customers. A customer can have more than one dog. A dog can be picked up by a
customer or an authorized family member. Family members are registered to a customer for
pickup permission which allows them to access their family’s dog(s) at the salon.
The Salon purchases products from wholesale groomer supply stores. The product
information is tracked by product number and the product description such as shampoo, styling
tools, bows, nail clippers, combs, and other similar items.
The Salon has a list of wholesale groomer supply stores that they purchase from. The
orders come directly from the supplier. They track the name, address, and phone number of the
supplier. Some suppliers offer more than one item and some items come from more than one
supplier.
2
This study source was downloaded by 100000860007226 from CourseHero.com on 01-29-2023 12:57:26 GMT -06:00
https://www.coursehero.com/file/65616667/1Dog-Salon-ERD-and-EERDpdf/
Topic Page
Purpose….………………………………………………………………………………………...2
Narrative….………………………………………………………………………………………2
Requirements (Actors/Roles) ….………………………………………………………..………4
Entities….………………………………………………………………………………………...4
Entities (w/Nested Attributes) ….……………………………………………………………….5
Business Rules….…………………………………………………………………………...……7
ERD….……………………………………………………………………………………….…...8
EERD….……………………………………………………………………………………….....9
1
This study source was downloaded by 100000860007226 from CourseHero.com on 01-29-2023 12:57:26 GMT -06:00
https://www.coursehero.com/file/65616667/1Dog-Salon-ERD-and-EERDpdf/
, Purpose
The purpose of this Database Design Documentation (DBDD) is to keep Dapper Dog
Salon business processes described below.
Narrative
Dapper Dog Salon is a pet salon located in the Tampa Bay area that serves many
customers every day. They pride themselves on ensuring that every dog that visits their shop
leaves looking better and smelling cleaner, with a wagging tail of satisfaction.
The dog salon register each customer to keep their information up to date and to have the
ability to contact customers. The Salon tracks each customer’s name, address, phone number,
email.
The Salon also tracks each dog’s name, breed, temperament, date of birth, and age. Dogs
are owed by customers. A customer can have more than one dog. A dog can be picked up by a
customer or an authorized family member. Family members are registered to a customer for
pickup permission which allows them to access their family’s dog(s) at the salon.
The Salon purchases products from wholesale groomer supply stores. The product
information is tracked by product number and the product description such as shampoo, styling
tools, bows, nail clippers, combs, and other similar items.
The Salon has a list of wholesale groomer supply stores that they purchase from. The
orders come directly from the supplier. They track the name, address, and phone number of the
supplier. Some suppliers offer more than one item and some items come from more than one
supplier.
2
This study source was downloaded by 100000860007226 from CourseHero.com on 01-29-2023 12:57:26 GMT -06:00
https://www.coursehero.com/file/65616667/1Dog-Salon-ERD-and-EERDpdf/
