Explain what you have learned in this assignment

Assignment Help Computer Engineering

Reference no: EM1333253

In this case assignment, you will write the SQL statement to work on the community library database. Following are the tasks you are required to perform:

1. Populate data to the tables in your database
2. Retrieve the contact details of library customers
3. Retrieve the contact details of library customers who live in certain city
4. Update the residence information of a certain customer
5. Retrieve names and phone number of customers who have overdue books as of a certain date
6. Describe what you have learned in this assignment.
Write a paper (2-5 pages) that includes your SQL statements and screenshots of the queries in OpenOffice.

Reference no: EM1333253

Questions Cloud

Find the expected time : A time was set at 0.20 hour per unit based on the fifty unit produced. Find the expected time for the 100th, 200th, and 400th units?

Joining marketsplace or developing countries across world : Joining marketsplace or developing countries across the world has presented attractive opportunities to global companies and thus, boosted FDI.

Significance of low value of r-square in regression : Capital Asset Pricing Model (CAPM) is used to calculate the required return from a stock. To calculate the required return from ABC stock, a regression was run between the S&P Index daily retun over risk free rate.

Computing costs pertinent economic decision making : Which costs are pertinent to economic decision making? Which costs are not relevant?

Explain what you have learned in this assignment : In this case assignment, you will write the SQL statement to work on the community library database. Following are the tasks you are necessary to perform.

Any comapny in an industry to earn a profit : Describe the factors in Michael Porter's "Five Forces Model" that affect the ability of any comapny in an industry to earn a profit.

Calculating theoretical stock price of ibm : Recalculate IBM's stock using the P/E ratio model and the needed info found in the IBM pdf file. Explain why the present stock price is different from the price arrived at using CGM (Constant Growth Model).

Explain e-business mini project : Explain E-business mini project and Presently company has a static webpage

Elucidate the macroeconomic and microeconomic concepts : Elucidate the macroeconomic and microeconomic concepts and how they relate to the management of a global organization.

User Account

All Pages