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.
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
1)Write a query to display a list of paintings and artists that are not hired within six months.
2) Create a sequence on customer no.
3) Apply a unique key constraint on painting title.
4) Write a query to display unique records of rental report.
5) Write a query to count the total number of returned paintings dated between 2020 and 2021.
Step by step
Solved in 3 steps with 4 images
