Provide a list of customer names and the total quantity

Assignment Help Other Subject

Reference no: EM132966985

ITECH2004 Data Modelling

Requirements

Process to follow:
It is a requirement of this assessment that students use Postgres.

Students are required to consider and describe the provided ER diagram from Appendix A.

They should then create a database in Postgres. The created database should be name RetailSales_studentID where studentID is the Federation University student id of the submitting student.

They should run the accompanying script file - Assessable_Practical_Exercise_RetailSales_Postgres.sql - to create the tables and insert the data in that database.

They should then write queries to correctly answer the query questions below.

They should then submit a report in the format of a business/professional report that contains a Title Page, Table of Contents and References (if cited). This report should also contain the following content:.

1. A full description of the ER model in Appendix A of this document. Students should include references to entities, attributes and relationships. Students should identify weak and strong entities and relationships and describe connectivity, cardinality and participation of the relationships.

2. A screen shot of their Postgres created database. The screen shot should be from the pgAdmin 4 gui.

3. The SQL and a screen shot of the successful running of that SQL (from the pgAdmin 4 gui software). The screen shot should include the left hand browser tree control (showing the database) and the query pane with the SQL and output as well as the computer monitor date and time. An example is given in Appendix B of this document. Please provide the correct details for the following queries:

a. Provide the name, contact and phone number of all customers. The data output should look like:

b. Provide a list of all invoice and invoice details. Provide the invoice number, invoice date, the invoice line item number, the product code and description, the quantity purchased and purchase price.

c. List the customer name, customer contact and customer phone for all customers with more than one address. The data output should look like:

d. Provide a list of customer names and the total quantity of items purchased by that customer, in descending total quantity order.

Attachment:- Data Modelling.rar

Reference no: EM132966985

Questions Cloud

Should investment undertaken if cost of capital ten percent : A firm is considering a project that requires an initial investment. If the cost of capital is 10%, should the investment be undertaken?

Develop data collection tools in electronic health : Why is it important to properly develop data collection tools in electronic health records?

Does brexit protect national interests and economic : Does BREXIT protect national interests and economic stability?

Is an opportunity cost involved for producing custom pipe : The tax rate for the corporation is 40% and the discount rate is 10%. Is there an opportunity cost involved for producing the custom pipe?

Provide a list of customer names and the total quantity : Provide a list of customer names and the total quantity of items purchased by that customer, in descending total quantity order

Make the journal entry on december to record : Prepare the journal entry/entries on December 31, 2017 to record only the loss carryback and/or loss carryforward for the loss in 2017.

What amount of deferred income tax liability stone report : Stone's Year 3 tax depreciation exceeded its book depreciation by $25,000. What amount of deferred income tax liability Stone report

Make the related journal entry required to be made : For the loss of 2017 that is carried forward, prepare the related journal entry/entries required to be made in 2018, 2019 and 2020.

Prepare the journal entry required to be made on december : Prepare the journal entry required to be made on December 31, 2017 to record this situation. Now assume that it was expected in 2017 that only 60%.

User Account

All Pages