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
|
Find the optimal solution
: Find the optimal solution. Mesa/Bugie manufactures two types of guitar amplifiers: Recto and ElCheap. You are asked to help the company decide
|
|
What benefits does it gain from software
: Since Port Aventura is using an ERP (SAP actually) to coordinate all of its operations, what benefits does it gain from this software?
|
|
Destination development in tourism
: This topic really gets into the process of development. In our discussion, how can destination managers influence the actions that can induce significant change
|
|
What is the impairment loss to be recognized
: The present value of an ordinary annuity of 1 at 5% for nine periods is 7.11. What is the impairment loss to be recognized for the current year
|
|
Provide a list of all invoice and invoice details
: 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
|
|
Aspect of identity impact daily life
: For this activity, upload an image that represents a part of your identity, either an achieved or an ascribed status. Briefly describe how the image represents
|
|
What cost of ending inventory at end of july for reli corp
: Reli Corp. sells designer T-shirts, If Reli Corp. uses specific identification cost method, what is the cost of ending inventory at the end of July?
|
|
Calculate and explain occupancy
: Part of your role as the revenue manager for a hotel company that owns and operates five full-service hotels operating under the Southern Sun Hotel brand is for
|
|
Determine the fair value of plan assets of GE
: Other data related to the benefit plan for the year ended 31 March 2020 are shown below: Service cost $300,000. Determine the fair value of plan assets of GE
|