Case Study Mr.Steve, a local businessman and real estate owner, has decided to expand business into paintings. He decides to register it as an Internet business, called Masterpieces Limited. It aims to lease the paintings to private individuals and commercial companies owned by masterpieces, as well as different painters or artists. He has been looking for consulting and designing companies. As a database designer, you need to help him for his services to design and implement a database to flourish his new business. In the initial phase, the following user requirements were discussed. 1. 1. The system must be able to manage the details of staff, customers, paintings and paintings available on hire. 2. 2. Customers are categorized as Regular (R), Loyal(L), privileged(P) and VIP(V) and charged accordingly. If customers ask for a discount, they are entitled to a discount of 15%, 10 %, 5% and 0%. 3. 3. As masterpieces allow you to buy or lease paintings, Customers can request painting by artist or theme like (landscape, persons or animals). A customer can lease the same painting more than once and even lease their own painting. Each painting has a certain cost as a monthly rental price offered by the owner (painter or artist). The owner is then paid 20% off the allocated rental price. 4. 4. Any paintings that are not leased within four months are returned to the owner. However, after return, an owner may resubmit a returned painting after one month. Each painting can only have one artist associated with it.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

What would be the normalization to the case study?

UNF, 1NF, 2NF & 3NF

Case Study
Mr.Steve, a local businessman and real estate owner, has decided to expand business into
paintings. He decides to register it as an Internet business, called Masterpieces Limited. It aims
to lease the paintings to private individuals and commercial companies owned by masterpieces, as
well as different painters or artists. He has been looking for consulting and designing companies.
As a database designer, you need to help him for his services to design and implement a database
to flourish his new business.
In the initial phase, the following user requirements were discussed.
1. 1. The system must be able to manage the details of staff, customers, paintings and
paintings available on hire.
2. 2. Customers are categorized as Regular (R), Loyal(L), privileged(P) and VIP(V) and
charged accordingly. If customers ask for a discount, they are entitled to a discount of 15%,
10 %, 5% and 0%.
3. 3. As masterpieces allow you to buy or lease paintings, Customers can request painting by
artist or theme like (landscape, persons or animals). A customer can lease the same painting
more than once and even lease their own painting. Each painting has a certain cost as a
monthly rental price offered by the owner (painter or artist). The owner is then paid 20%
off the allocated rental price.
4. 4. Any paintings that are not leased within four months are returned to the owner. However,
after return, an owner may resubmit a returned painting after one month. Each painting can
only have one artist associated with it.
Transcribed Image Text:Case Study Mr.Steve, a local businessman and real estate owner, has decided to expand business into paintings. He decides to register it as an Internet business, called Masterpieces Limited. It aims to lease the paintings to private individuals and commercial companies owned by masterpieces, as well as different painters or artists. He has been looking for consulting and designing companies. As a database designer, you need to help him for his services to design and implement a database to flourish his new business. In the initial phase, the following user requirements were discussed. 1. 1. The system must be able to manage the details of staff, customers, paintings and paintings available on hire. 2. 2. Customers are categorized as Regular (R), Loyal(L), privileged(P) and VIP(V) and charged accordingly. If customers ask for a discount, they are entitled to a discount of 15%, 10 %, 5% and 0%. 3. 3. As masterpieces allow you to buy or lease paintings, Customers can request painting by artist or theme like (landscape, persons or animals). A customer can lease the same painting more than once and even lease their own painting. Each painting has a certain cost as a monthly rental price offered by the owner (painter or artist). The owner is then paid 20% off the allocated rental price. 4. 4. Any paintings that are not leased within four months are returned to the owner. However, after return, an owner may resubmit a returned painting after one month. Each painting can only have one artist associated with it.
Expert Solution
steps

Step by step

Solved in 7 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY