Part I: Setting Up the PostgreSQL Database Go to https://www.enterprisedb.com/downloads/postgres-postgresql-downloads?quicktabs_postgres_plus_dwnlds=1#quicktabs-postgres_plus_dwnlds From the Select your version drop down menu, select at least a version that is above 9.6. If you install a version before PostgreSQL 9.6, then you may not be able to complete some of the data warehousing assignments. At time of writing, we recommend version 9.6.6. From the Select your operating system drop down menu, select the correct operating system for your computer. If you’re a windows user and unsure if you want the 32 bit, or 64 bit operating syste


Part I: Setting Up the PostgreSQL Database

  1. Go to https://www.enterprisedb.com/downloads/postgres-postgresql-downloads?quicktabs_postgres_plus_dwnlds=1#quicktabs-postgres_plus_dwnlds
  1. From the Select your version drop down menu, select at least a version that is above 9.6. If you install a version before PostgreSQL 9.6, then you may not be able to complete some of the data warehousing assignments. At time of writing, we recommend version 9.6.6.
  1. From the Select your operating system drop down menu, select the correct operating system for your computer. If you’re a windows user and unsure if you want the 32 bit, or 64 bit operating system, follow the instructions from our 24/7 technical support site, by clicking this link: How do I Match Software to my Windows Operating System?
  1. Click on or tab to the Download Now button and press Enter.

Caption: Download PostgreSQL download screen. The Select your version and Select your operating system drop-down menus are displayed as well as the Download Now button.

  1. The Windows PostgreSQL installer file is downloaded. Double-click on or tab to the installer file and press Enter to begin the installation.
  1. The install process starts and the setup screen is displayed. Click or tab to the Next button and press Enter.

Caption: Setup – PostgreSQL setup wizard screen. Next and Cancel buttons are available.

  1. You do not need to install the StackBuilder (unless you want to). Stackbuilder will take a long time to run and installs many programs that you may not be familiar with.

Caption: Setup – Select components screen is displayed showing that all components are selected except Stack Builder

  1. On the Installation Directory screen, the default location is already displayed in the Installation Directory field. Accept the default and then click on or tab to the Next button and press Enter.

Caption: Setup – Installation Directory screen. The Installation Directory field is displayed where the default can be selected or a new one chosen. Back, Next and Cancel buttons are available.

  1. On the Data Directory screen, the default location is already displayed in the Data Directory field. Accept the default and then click on or tab to the Next button and press Enter.

Caption: Setup – Installation Directory screen. The Installation Directory field is displayed where the default location can be selected or a new one selected. Back, Next and Cancel buttons are available.

  1. On the Password screen, you are prompted to enter a password for the administrative account named “posgres.” Enter the password you would like to use for this account twice, and then click on or tab to the Next button and press Enter.

IMPORTANT: DO NOT forget this database logon ID and password.

Caption: Setup – Password screen. The Password and Retype password fields are displayed. Back, Next and Cancel buttons are available.

  1. On the Port screen, by default, PostgreSQL services communicate on Port 5432. Accept the default and then click on or tab to the Next button and press Enter.

Caption: Setup – Port screen. The Port field is displayed. Back, Next and Cancel buttons are available.

  1. On the Advanced Options screen, accept the default locale in the Locale field and then click on or tab to the Next button and press Enter.

Caption: Setup – Advanced Options screen. The Locale field is displayed. Back, Next and Cancel buttons are available.

On the Ready to Install screen, click on or tab to the Next button and press Enter to begin the installation process.

Caption: Setup – Ready to Install screen. The confirmation message that setup is ready to begin installing the PostgreSQL software is displayed. Back, Next and Cancel buttons are available.

The installation process is started.

Caption: Setup – Installing screen. The installation progress bar is displayed. The Cancel button is available.

Once you have completed this step, then you are finished.

Creating the Database

Once you have installed PostgreSQL, you will need to create a database and seed your database with data. For this assignment, you will use the Northwind database from Microsoft. To create the database, you will use the pgAdmin4 utility, which was installed in your PostgreSQL installation. If you are familiar with Microsoft SQL Server, then pgAdmin4 is similar to Microsoft SQL Server Studio Express.

  • Click on or tab to the pgAdmin4 icon and press Enter to launch the application.
    (Note the screen shot below shows how to start pgAdmin4 in Windows 10. You may have an icon on your desktop in other versions of Windows.)

Caption: Start menu of Windows 10 displaying pgAdmin 4 icon.

The interactive development environment should appear after a few moments.

Seeding the Database with Data

You will need to seed your database with data. You might use Microsoft’s Northwind database for the exercises in this class. PostgreSQL database administrative tool is named PgAdmin and if you are familiar with Microsoft’s SQL Server Studio Express, then PgAdmin works similarly. PgAdmin is found in the PostgreSQL bin folder.

  1. In Windows, the folder is C:\Program Files\PostgreSQL\***version of PostgreSQL****\pgAdmin 4\bin. The executable name is pgAdmin4.exe and has the “elephant” icon. You may want to create a desktop shortcut for this program.

Caption: pgAdmin Management Tools for PostgreSQL home screen. On the right, the database tree is displayed. On the left, quick links for Add New Server, Configure pgAdmin, PostgreSQL Documentation, pgAdmin Website, Planet PostgreSQL and Community Support are available.

  1. Next, you will create the database you will be using for this class. Click on or tab to the “+” next to Servers (1) and press Enter to expand the database tree. Then click on or tab to the “X” beside PostgreSQL and press Enter.

Caption: pgAdmin 4 Dashbord screen. On the left, the database tree is displayed. On the right, the boxes for monitoring Server sessions, Transactions per second, Tuples in, Tuples out, Block I/O and Server Activity (Sessions, Locks, Prepared Transactions, Configuration) are displayed.

The Postgres database tree is expanded. The version may vary after the PostgreSQL depending on the version downloaded.

Caption: pgAdmin 4 database tree. PostgreSQL is expanded to display Databases, Login/Group Roles and Tablespaces

  1. Expand the database tree in order to create your database. Right-click on Databases (1) and select Create > Database from the menu.

Caption: pgAdmin 4 database tree. PostgreSQL 9.6 is expanded to display Databases. Databases is expanded displaying the Create menu option.

  1. Enter Northwind as the name of your database in the Database field. Select the Save Button.

Caption: Create – Database window, General tab displayed in forefront. Fields include Database, Owner, Comment

  1. Select Northwind under Databases. Under Tools in the main menu, select the Query Tool and press Enter. The query editor tool displays. In the query editor, copy and paste the contents of the file northwind.postgre.sql.

Caption: pgAdmin 4 screen displays Northwind SQL statements. An arrow points to the lightning bolt in the menu bar.

  1. Execute the SQL statements by clicking on or tabbing to the lightning bolt in the menu bar and pressing Enter. This will create and seed your tables with data.

Caption: pgAdmin 4 screen displays Northwind SQL statements. An arrow points to the lightning bolt in the menu bar.

  1. Expand the Tables tree under the Schemas tree. You should see the tables of the Northwind dataset. Take a screenshot of the table structure and submit it as part of your critical thinking assignment (CTA) for Module 1. Our 24/7 technical support site has a set of instructions for best practices when taking a screenshot, accessed by clicking this link: How to Take a Screenshot

Your screenshot should look similar to the following:

Caption: pgAdmin 4 screen with Tables tree expanded displaying NorthWinds tables. These tables include categories, customercustomerdemo, customerdemographics, customers, employees, employeeterritories, order_details, orders, products, region, shippers, shippers_tmp, suppliers, territories, usstates.

A Critical Literature Review & Presentation

ASSESSMENT 2 – Essay – A Critical Literature Review & Presentation

Task description: This is an individual assessment task which requires students to further explore the topic and area of research identified in the paper chosen for the Critical Analysis Test (Assessment 1), and will be completed in two parts. Part 1 is the Critical Literature Review and Part 2 is the Oral Presentation.
Weight: Part 1 (20%) + Part 2 (20%) = 40% of total course marks

Part 1: The Critical Literature Review

Weight: 20%
Marked out of: Total 100
Word limit: 1000 words (10% variation allowed)
Submission: Submit via the link in the Assessment folder on the course website at Learning@Griffith.

Task description:

Students are required to develop a problem statement using a minimum of six (6) research based journal articles, including the selected paper from the Critical Analysis Test. This task requires you to demonstrate your understanding of the literature on the particular topic you choose to analyse for Assessment 1. You show your understanding by analysing and then synthesising the information to:
Determine what has already been written on a topic Establish the significance of the topic Identify the central issue in the field Integrate what previous researchers have found Evaluate likely solutions that researchers have recommended Identify important issues still unresolved
This written communication assessment should have an essay structure that includes: (1) Introduction, (2) Body, (3) Conclusion, and (4) Reference List. These headings are only guidelines as to how to structure the content of your essay. No table of contents is required.
Critical analysis: Students are required to clearly articulate and critically evaluate the key features of their chosen literature sources. Students should be aware that using websites, magazines, or other non-academic sources is unsuitable and will negatively influence marks. Students should note that a good critical literature review would aim to cover important, relevant, and up-to-date literature. You will provide an insightful analysis of the ideas and conclusions presented in the literature that points out similarities and differences, and identified gaps in the literature for future research.
Referencing: Please use APA6 style for your referencing list and intext referencing. Please take care with your referencing and paraphrasing of the literature as you will be penalised for incorrect referencing or the omission of the correct reference.
PLEASE NOTE: Assignments not submitted to the online submission link will not be marked. Assignments that have zero percent (0%) text matching will not be marked. Assignments are to be written using Times New Roman 12 font with 1.5 line spacing. Penalty applies if written using other fonts such as Arial, Calibri, etc.

Part 2: The Critical Literature Review Presentation

Due date: Presentations will be held in Weeks 3-5
Marks: 20%
Marked out of: 20
Word limit: 20 slides/20 seconds each (6 minutes and 40 seconds in total)
Submission: Presented in class, slides submitted onlinevia Learning@Griffithto tutor prior to presentation.Please also bring your presentation on a USB to class, and print a copy of your slides to give to your tutor at the beginning of the class on the day of your presentation.

Task description:

On the basis of your problem statement (which you have developed in Part 1), you will deliver an oral presentation explaining the industry implications of this problem. This could include the importance of, factors that have contributed to, and lessons to be learnt from this problem. Students will deliver the presentation in a Pecha Kucha style, in which 20 slides are shown for 20 seconds each (6 minutes and 40 seconds in total). You will deliver a short and concise presentation that communicates key messages.
PLEASE NOTE: Presentation slides not submitted online will not be marked. The order for presentations will be decided in class and posted on the course site. Late penalties for submission or non-appearance at your presentation time will be delivered where appropriate. If you have any issues around your presentation time you should communicate with your tutor as soon as you are able.

Note:Please refer to Learning@Griffith course website for the marking rubrics. All assignments must be submitted via SafeAssign. Further information will be provided in the lectures and workshops.

Have any Question or Comment?

Leave a Reply

Have a similar question?

This essay has been answered by:

Martins writer

Finished papers: 455

Proficient in:

English, History, Business and Entrepreneurship, Nursing, Psychology, Management

You can get writing help to write an essay on these topics
100% plagiarism-free

Enjoy Our Unique Features!

INDIVIDUAL APPROACH:
Chat with every writer who applies to your request, and view their skills and portfolio. Make the choice that’s right for you.
MANAGE YOUR ORDER:
Monitor progress and see any changes made. Have full control over every phase of the process.
COMMUNICATE:
Ask your writer questions and provide your ideas about your paper. Produce the exact result that you want.
ENJOY THE OUTCOME:
Get everything done on time with high quality. Writing papers is much simpler with us.

Submit Your Instructions to Writers for FREE!!

Ask your homework question

 

© 2017 theacademicessays. All Rights Reserved. Design & Developed by theacademicessays.

POST YOUR QUESTION FOR FREE

Click Here to get instant solution!
X myStickymenu
Loading...