Homework: TWO THINGS: UML diagram and data dictionary Background Paint Brush Party Bus provides mobile art classes to children of all ages. Patty Brown owned an art studio for over 10 years where she taught students – both children and adults – how to paint. Eventually, though, she decided to change her business to a mobile art studio focused on teaching children ages 4-17. She purchased a few old school buses which she gutted and outfitted with easels, benches, and art supplies for students to use when taking PBPB’s classes. She also hired a few more art teachers to help her teach her classes. This case describes the art class jobs (sales) and art supplies purchasing (purchase) processes for Paint Brush Party Bus (PBPB).   Art Class Jobs PBPB performs art class jobs for customers who sign up on their website for open art classes at local parks on specified days and times. PBPB also does art classes for children’s parties at either the customer’s home or a local park. PBPB tracks art class jobs by art class job #. Each job requires at least one employee, many art supplies, and at least one bus. If more than one bus is required for a job, more than one employee is needed to drive the bus and teach the class. Customers must pay a 20% reservation fee when they sign up for the art class which is later applied to the cost of the class when they arrive at the bus to paint. Customer payments are made by cash or credit card and are deposited daily in PBPB’s bank account by the owner. Each payment is made for only one art class job.   PBPB Inventories Buses. PBPB maintains a small inventory of buses to support the mobile art classes (the acquisition of buses is outside the scope of this case). PBPB tracks the buses by vehicle identification numbers (VINs) and keeps meticulous records on each bus. For example, they track the mileage that each bus incurred on each art class job. Additionally, they track the maintenance history for each bus.   Art Supplies. PBPB also maintains an extensive inventory of art supplies, ranging from paints and brushes to palettes and canvases. To manage the art supply inventory, PBPB categorizes all art supplies by supply type.   Art Supply Purchases. PBPB buys its art supplies in bulk to keep its supply inventory well-stocked. When the supplies are delivered and accepted, PBPB assigns a purchase number to each receipt. PBPB pays for art supply purchases within 30 days of the delivery. Occasionally, payments are combined if there are multiple deliveries from the same vendor within a short period of time.   Miscellaneous. PBPB keeps all vendor information together (your model should show one Vendor class). However, they classify the vendors by type. PBPB keeps all employee information together (your model should show one Employee class). You may assume that all agent, resource, and type image information is entered into the database before any process activity takes place.   REQUIRED:  1) use the information above and the list of attributes below to draw a UML class diagram showing the classes, associations, and multiplicities, 2) prepare a listing of the tables necessary to support NGC’s process using all the attributes. Name each table and clearly identify primary keys with PK and foreign keys with FK. List your tables in the following order: RESOURCES, EVENTS, AGENTS, TYPE IMAGES, and LINKING. Use only the following list of attributes (remember that there should be no entities without attributes). You should apply the standard REA patterns wherever the narrative does not clearly specify otherwise, but avoid adding extra relationships that are not discussed. If the narrative is not clear, you should clearly note any assumptions that you make.   Attributes:   Art class job # Art class job date Art class job price Bus mileage to date Bus VIN Cash account # Cash account balance Cash receipt # Cash receipt amount Cash receipt date Check # Check amount Check date Customer # Customer name Customer phone number Employee # Employee address Employee hire date Employee name Number of hours this bus used on this job Number of vendors of this type Price of this supply received on this purchase Price of this supply used on this job Quantity of this supply received on this purchase Quantity of this supply used on this job Quantity on hand of this supply Standard price of supplies in this category Supply # Supply description Supply name Supply purchase # Supply purchase date Supply type Vendor # Vendor account payable amount Vendor name Vendor type Year that this bus was acquired

Homework:

TWO THINGS: UML diagram and data dictionary


Background

Paint Brush Party Bus provides mobile art classes to children of all ages. Patty Brown owned an art studio for over 10 years where she taught students – both children and adults – how to paint. Eventually, though, she decided to change her business to a mobile art studio focused on teaching children ages 4-17. She purchased a few old school buses which she gutted and outfitted with easels, benches, and art supplies for students to use when taking PBPB’s classes. She also hired a few more art teachers to help her teach her classes. This case describes the art class jobs (sales) and art supplies purchasing (purchase) processes for Paint Brush Party Bus (PBPB).

Art Class Jobs

PBPB performs art class jobs for customers who sign up on their website for open art classes at local parks on specified days and times. PBPB also does art classes for children’s parties at either the customer’s home or a local park. PBPB tracks art class jobs by art class job #. Each job requires at least one employee, many art supplies, and at least one bus. If more than one bus is required for a job, more than one employee is needed to drive the bus and teach the class. Customers must pay a 20% reservation fee when they sign up for the art class which is later applied to the cost of the class when they arrive at the bus to paint. Customer payments are made by cash or credit card and are deposited daily in PBPB’s bank account by the owner. Each payment is made for only one art class job.

PBPB Inventories

Buses. PBPB maintains a small inventory of buses to support the mobile art classes (the acquisition of buses is outside the scope of this case). PBPB tracks the buses by vehicle identification numbers (VINs) and keeps meticulous records on each bus. For example, they track the mileage that each bus incurred on each art class job. Additionally, they track the maintenance history for each bus.

Art Supplies. PBPB also maintains an extensive inventory of art supplies, ranging from paints and brushes to palettes and canvases. To manage the art supply inventory, PBPB categorizes all art supplies by supply type.

Art Supply Purchases. PBPB buys its art supplies in bulk to keep its supply inventory well-stocked. When the supplies are delivered and accepted, PBPB assigns a purchase number to each receipt. PBPB pays for art supply purchases within 30 days of the delivery. Occasionally, payments are combined if there are multiple deliveries from the same vendor within a short period of time.

Miscellaneous. PBPB keeps all vendor information together (your model should show one Vendor class). However, they classify the vendors by type. PBPB keeps all employee information together (your model should show one Employee class). You may assume that all agent, resource, and type image information is entered into the database before any process activity takes place.

REQUIRED:  1) use the information above and the list of attributes below to draw a UML class diagram showing the classes, associations, and multiplicities, 2) prepare a listing of the tables necessary to support NGC’s process using all the attributes. Name each table and clearly identify primary keys with PK and foreign keys with FK. List your tables in the following order: RESOURCES, EVENTS, AGENTS, TYPE IMAGES, and LINKING. Use only the following list of attributes (remember that there should be no entities without attributes). You should apply the standard REA patterns wherever the narrative does not clearly specify otherwise, but avoid adding extra relationships that are not discussed. If the narrative is not clear, you should clearly note any assumptions that you make.

Attributes:

Art class job #

Art class job date

Art class job price

Bus mileage to date

Bus VIN

Cash account #

Cash account balance

Cash receipt #

Cash receipt amount

Cash receipt date

Check #

Check amount

Check date

Customer #

Customer name

Customer phone number

Employee #

Employee address

Employee hire date

Employee name

Number of hours this bus used on this job

Number of vendors of this type

Price of this supply received on this purchase

Price of this supply used on this job

Quantity of this supply received on this purchase

Quantity of this supply used on this job

Quantity on hand of this supply

Standard price of supplies in this category

Supply #

Supply description

Supply name

Supply purchase #

Supply purchase date

Supply type

Vendor #

Vendor account payable amount

Vendor name

Vendor type

Year that this bus was acquired