Databases | SQL | Oracle | MS Access Answers

What is the requirements?

What are the types of requirements?

What is the user requirement?

What is the system requirement?

Polly Pipe is a water sports provider and installer based in Braintree, England. They need you to design and implement a database that meets the data requirements. These necessities are defined in this scenario and below are samples of the paper records that the Polly Pipe preserves.

Polly Pipe is focused in placing aquariums at business customers. Customers can request several installations, but each installation is tailor-made for a specific customer. Facilities are classified by type. One or more employees are assigned to each facility. Because these facilities are often very large, they can include carpenters and masons as well as water installers. The facilities use equipment such as aquariums, air pumps and thermostats. There can be multiple computers in a facility.

Identify the user and system requirements to design a database for the above scenario.

Write a program in PL/SQL to FETCH multiple records and more than one columns from the same table.

Write a program in PL/SQL to show the uses of SQL%FOUND to determine if a DELETE statement affected any rows.

Design and develop an application focusing on career guidance and counseling an individual's competencies in self-knowledge, educational and occupational exploration, and career planning. It is an application designed to assist individuals in making and implementing informed educational and occupational choices. create a prototype

PRACTICAL: Question 6 (Marks: 10)

Create a PL/SQL query to display the customer name and total amount spent by each customer. In your solution determine the customer rating. If the total amount spent is greater than or equal to R 1000, the customer receives a star rating, otherwise no star rating applies.

Sample Output

FIRST NAME: Patrick

SURNAME: Smith

AMOUNT: R 700

----------------------------------------------------

FIRST NAME: Steven

SURNAME: Hewson

AMOUNT: R 570

----------------------------------------------------

FIRST NAME: Barry

SURNAME: Goodwin

AMOUNT: R 2500 (***)

----------------------------------------------------

PRACTICAL: Question 5 (Marks: 10)

Create a view called vwPetSalesDetails that will display the customer id, pet id, pet price and sales date. In your solution only display the sales that occurred between 15 March 2020 and 18 March 2020.

how to code for the sales between that date only. please provide sample code. thank you

PRACTICAL: Question 4 (Marks: 10)

Create a PL/SQL query to display the customer’s name and the pet that was purchased. In your solution only display the pet sale quantity greater than 1.

Sample Output

---------------------------------------------------

CUSTOMER NAME: Barry Goodwin

PET TYPE: Dog - Jack Russel

SALE QUANTITY 2

---------------------------------------------------

CUSTOMER NAME: Steven Hewson

PET TYPE: Bird - Budgie

SALE QUANTITY 3

--------------------------------------------------- 

1)Explain to Top Management the various program categories that will enable you to operate a database in Oracle. Discuss at least three of these program categories. (10 Marks)

2)Identify and briefly explain the five features of PL/SQL that allow the developer to write effective code to manipulate a database. (10 Marks)

Explain to Top Management the various program categories that will enable you to operate a database in Oracle. Discuss at least three of these program categories.