Reference no: EM13929627

write SQL statements for the given tasks. Once complete, copy the SQL statements from Microsoft Access and paste them in a

Microsoft Word document that will be submitted along with part II of the assignment.

Write an SQL statement:

• To display all the information from the Customer table

• To display each shipping date for customer 1 from the Invoice table

Note: Display both the customer number and the shipping date.

• To display the names of all the trees that cost at least $200.00

• To display all the information for invoice number 2

• To list the phone and last name of all customers

• To list the phone, first name, and last name of all customers whose last name starts with "J"

• To return the number of customers

• To determine the average total invoice amount

• To show all the items ordered from invoice number 3

• To show the first and last names along with the invoice number of all customers with an invoice of at least $250.00

Part II-Course Project

This part of the assignment is a detailed project designed to help you learn the modeling of business requirements and

understand the physical implementation of logical business models through the use of E-R models.

Through each week's project, you will be adding to the course project. You will be assigned tasks each week, which you will

complete and submit as directed.

Course Project Part 1-Database Planning

For this week, imagine that you have been hired by a company to build a database for it and complete the following tasks:

• Describe your idea of the database.

o This can be a business problem or a hobby you are interested in-for example, an airline reservation system.

• Outline the database you would like to create.

• Outline the SDLC. Include the following subcategories:

o Strategy and analysis for a business or an idea you plan to develop

o Analysis of the current system:

What does the company have?

What business projections does it have?

o Integration with other systems-plan how the current system can be integrated with other systems

o Documentation and communication-describe how this vital part will be accomplished

o Design for changes-prepare a plan for the future

o Reusable resources-do not redo work; identify what the company has in place that you can use

Attachment:- Teresa's Trees.rar