Reference no: EM132595295
BuyMe Database Design and Implementation
Queries: 1. Show current price of Apple for all exchanges
2. Show maximum price of a share in USA market
3. Show minimum price for Apple for all data (from all exchanges)
4. Find broker who has maximum number of appointments
5. Find customer which booked the maximum number of appointments
6. Show all UK stocks having price higher than average for Asian market today
7. Show all stocks having price higher than average for USA market today
8. Update the price for all APPLE shares (Assuming there is a price change to 1000$)
9. Show average price of Asian shares which are higher than Average of European shares For Gold brokers
10. Find an Asian stock having price which is higher than average of Asian and European stock but less than average of USA stock
Trigger Create a trigger, which places the customers that have been deleted into a customer table. This allows records to be maintained while improving query times for existing customers.
Attachment:- Database_Task.rar