Show current price of apple for all exchanges

Assignment Help Database Management System

Reference no: EM132446204 , Length: word count:1500

BuyMe Database Design and Implementation

Each office got a CTO, who keep an eye over the total stock sold and loss/gain. Customer cannot directly interact with CTO. Henry, the company CEO, resides in London office and manages the overall profit of the company.

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.

Integrity Constraints

1. Only Numeric data in price

2. Appointment cannot be booked in past

3. No numeric numbers in Names

4. Email should have @ symbol for brokers and customers

5. If the customer email is not given, it should be ‘[email protected]'

Attachment:- Database Design and Implementation.rar

Reference no: EM132446204

Questions Cloud

Elements of a valid contract to the chosen agreement : Discuss and apply FIVE of the elements of a valid contract to the chosen agreement. Attach the chosen agreement to your assignment.

Research about military family stress : Research an incidence or situation in the United States. Clearly explain the incident, the issues involved, and the stress impact on children and family.

Perfect the interest in the kitchen equipment : Industrial Kitchen Supplies, Inc. never did perfect the interest in the kitchen equipment.

Define managed care impacts on healthcare finance : Some possible course project topics for your consideration are listed below: Managed care impacts on healthcare finance. Financial management of clinics.

Show current price of apple for all exchanges : Show current price of Apple for all exchanges - Find broker who has maximum number of appointments and Find customer which booked the maximum number

Write summary about the harm principle : Write Summaryof Mill's On Liberty which contains an articulation about The Harm Principle and Precis on Deontology (of Immanuel Kant's Groundwork)

Negotiate a pay raise : Imagine that you have been working as a consultant for two years and have not received a pay raise despite being one of your work group's best performers

Describe the artistic and inartistic proofs on the website : Describe the artistic and inartistic proofs on the website. Identify any logical fallacies. Does the use of these fallacies strengthen or weaken the argument?

Evaluate the performance measures in place : Evaluate the performance measures in place at the Squire Hotel Group (SHG). Provide suggestions for improving SHG's existing market position.

User Account

All Pages