Reference no: EM132966906 , Length: word count:2000

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