Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question

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

 

 

 

 

 

Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education