Answer to Question #303510 in Databases | SQL | Oracle | MS Access for Mujeeb

Question

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

Below are examples of paper records that Polly Pipe currently maintains.

 

Staff Management Record

Staff Number 

Name 

Type 

SHA1 

Dave Clark 

Plumber 

SHA8 

John Smith 

Installation Manager 

SHA2 

Freddy Davies 

Aquatics installer 

SHA11 

McCloud 

Aquatics installer 

SHA23 

Satpal Singh 

Plumber 

SHA66 

Winstn Kodogo

Aquatics installer 

SHA55 

Alison Smith 

Brick Layer 

 

Equipment Type Table

Type 

Equipment 

Tanks 

20 gallon tank, 50 gallon tank, 100 gallon tank, 200 gallon tank 

Thermostats 

Standard, Super 

Air Pumps 

Standard, Super 

Filters 

Air driven, Undergravelb

please help

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order