A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies. Because of your reputation as a database designer she has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested. The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (e.g. animal, landscape, seascape, naval, still‐life, etc). Over time a customer may hire the same painting more than once. Each painting is allocated a customer monthly rental price defined by the owner. The owner of the painting is then paid 10% of that customer rental price. Any paintings that are not hired within six months are returned to the owner. However, after three months, an owner may resubmit a returned painting. Each painting can only have one artist associated with it. Several reports are required from the system. A) Create the table of customer, owner and artist. B) Write a query for each customer, a report showing an overview of all the paintings they have hired or are currently hiring C) Write a query for each artist, a report of all paintings submitted for hire.
A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies. Because of your reputation as a
A) Create the table of customer, owner and artist.
B) Write a query for each customer, a report showing an overview of all the paintings they have hired or are currently hiring
C) Write a query for each artist, a report of all paintings submitted for hire.
![Pages to be created
Customer Rental Report
Customer Rental Report
Customer No
Customer Category:
Customer Name
Category Description
Customer Address
Category Discount
Painting No
Painting Title
Painting Theme
Date of Hire Date Due Back
Returned (Y/N)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fa224ae4e-a864-4202-bd30-af3efa07577c%2Ffaeaaac2-810a-4d75-b203-265fc2d19b72%2F9y4kp7e_processed.png&w=3840&q=75)
![Artist Report
Artist Report
Artist No:
Year of Birth
Age:
Artist Name:
Year of Death
(if applicable)
Country of Birth
Painting No
Painting Title
Rental Price
(monthly)
Owner No
No
Theme
Owner
Owner
Nane
Tel](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fa224ae4e-a864-4202-bd30-af3efa07577c%2Ffaeaaac2-810a-4d75-b203-265fc2d19b72%2F32pl3qq_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)