#WA Postcode Address Data
Explore tagged Tumblr posts
Visit Tumblr Blog
Explore Tumblr blogs with no restrictions, modern design and the best experience.
Last Seen Tumblr Blogs
Fun Fact
Tumblr was acquired by Yahoo for $1.1B in 2013.
Text
TAS Postcode Data - DataTools Verified Address Lists
Access TAS postcode address data with verified residential, unit, and street-level details. Instantly download accurate Australian address lists for reliable marketing, business analysis, and location targeting.
#Tasmania Address Data#NSW Postcode Address Data#WA Postcode Address Data#Australian Capital Territory Address Data
0 notes
Text
COVID-19 update: 29 June 2022
WA Health is reporting a total of 5,921 new cases to 6pm last night. There are currently 27,132 active cases in Western Australia.
To 6pm last night, there were 229 people with COVID-19 in hospital, 14 in ICU.
Sadly, today’s report includes four deaths, dating back to 21 June, which were reported to WA Health yesterday.
This includes a man in his 80s and three men in their 60s.
Due to confidentiality requirements, no further information on these cases will be released by the Department.
Total case breakdown:
Region Active (new to 6pm last night)Metropolitan 22,114 (4,645) Goldfields 410 (96) Great Southern 525 (115) Kimberley 196 (31) Midwest 725 (161) Pilbara 436 (119) South West 1,479 (301) Wheatbelt 576 (131)
Notes
This data is based on the residential postcode of each case. The case may have an isolation address in another region.
The remainder of daily cases reported (72) are yet to have a region assigned. Data will continue to be reconfigured as this information is verified.
Of the 5,921 cases, 2,254 were confirmed via PCR test, the remaining 3,667 were self-reported positive rapid antigen tests. updatemoi
A total of 7,342 PCR tests were conducted at either state-run or private pathology clinics yesterday.
WA has recorded 898,402 cases since the COVID-19 pandemic began.
0 notes
Text
COVID-19 update: 27 June 2022
WA Health is reporting a total of 3,434 new cases to 6pm last night. There are currently 27,167 active cases in Western Australia.
To 6pm last night, there were 234 people with COVID-19 in hospital, 8 in ICU.
Sadly, today’s report includes five deaths, dating back to 17 June, which were reported to WA Health yesterday.
This includes a man and woman in their 90s, two women in their 80s and a man in his 60s.
Due to confidentiality requirements, no further information on these cases will be released by the Department.
Total case breakdown:
Region Active (new to 6pm last night) Metropolitan 22,326 (2,842) Goldfields 406 (62) Great Southern 533 (68) Kimberley 175 (26) Midwest 781 (82) Pilbara 395 (47) South West 1,564 (186) Wheatbelt 575 (78)
Notes
This data is based on the residential postcode of each case. The case may have an isolation address in another region.
The remainder of daily cases reported (43) are yet to have a region assigned. Data will continue to be reconfigured as this information is verified.
Of the 3,434 cases, 957 were confirmed via PCR test, the remaining 2,477 were self-reported positive rapid antigen tests.
A total of 4,647 PCR tests were conducted at either state-run or private pathology clinics yesterday.
WA has recorded 887,743 cases since the COVID-19 pandemic began.
0 notes
Photo
New Post has been published on https://punjabassignmenthelp.com/ict701-relational-database-systems-assignment/
ICT701 | RELATIONAL DATABASE SYSTEMS ASSIGNMENT
ICT701 | RELATIONAL DATABASE SYSTEMS ASSIGNMENT | DATABASE
IT Assignment Help
Part A (40 marks)
Requirements
Based on the 2 tables given in the spreadsheet provided, students are to create a database design specification (entity relationship diagram (ERD) and relational data model (RDM)) from a given business description below. Students are to present this in a report (as specified in the submission format) which also includes a short discussion of the approach for the solution. This assignment is to be carried out and reported individually.
The following defines the minimum information that should be reported:
A brief discussion of your solution, i.e. how you approached the modelling problem and any issues you may have encountered. This includes any assumptions and suggestions for the new design (maximum of ½ page).
The Entity Relationship Diagram (ERD) (produced using a drawing tool such as those found in MS Word or PowerPoint, or a chosen CASE tool) for the system. Your ERD must use the ER notation that was taught in ICT701. Any assumptions made in creating the ERD must be explicitly stated in your report.
The Relational Data Model (RDM) which corresponds to the ERD. That is, the set of tables in 3rd normal form that could be used to represent the whole of this data model. Your RDM should identify primary, alternate and foreign keys.
Business Description
Technical Texts is an online reseller of textbooks to colleges and TAFEs. They deal with a number of publishers and sell a range of books in the Computers, Business, Medical and Sports category. They started off as a relatively small business only selling to a local TAFE. However, they quickly grew and now have a range of customers from all over Australia. When they started the business, they used a spreadsheet to manage the orders. However, as they grew, they realized that the spreadsheet was no longer able to meet their needs. They needed a better way to manage their orders. In the Excel spreadsheet books.xls you will see a sample of their orders table. They also have another table where they started storing the customer details. They hope to get a complete database up and running soon.
Part B (Total 45 Marks)
Complete the following SQL tasks using MySQL. The marks available for each SQL statement are indicated.
Write the SQL code that will create the table structure for the CUSTOMER Table. The basic CUSTOMER table structure is summarized in the table below. (1 mark)
ATTRIBUTE (FIELD) NAME DATA DECLARATION CUST_ID CHAR(6) CUST_LNAME VARCHAR(15) CUST_FNAME VARCHAR(15) CUST_ADD VARCHAR(25) CUST_CITY VARCHAR(15) CUST_STATE CHAR(3) CUST_PCODE CHAR(4)
Having created the table structure in Part B1 (1) above, write the SQL code to enter all the data in the table below into your EMPLOYEE table. (2 marks)
Customer
CustomerID FirstName Surname Address City State Postcode AA0621 Aaron Adamson 23 Chardonnay Crt Wilson WA 6107 GY0001 Gareth Yardley 88 Graham Rd Launceston TAS 7250 HA8870 Harriet Annerley 6 First Ave Belmont QLD 4153 JB0012 Jordan Black 12 Blackbird Lne Vermont VIC 3133 JB1165 John Brown 54 Georgette St Battery Point TAS 7004 JB1302 Jonathon Brown 45 Quail Crt Buderim QLD 4556 JB6544 Juliet Bardensley 7 Jamieson Circ Belmont NSW 2280 SA0010 Sally Adams 187 Main Rd Broadbeach QLD 4218
Assuming the data shown in the CUSTOMER table has been entered; write the SQL code that will list all attributes for a Postcode of 4556. (2marks)
Write the SQL code that will save the changes made to the EMPLOYEE table. (1 mark)
Write the SQL code to change the postcode to 6501 for the person whose Customer ID is AA0621. After you have completed the task, examine the results, and then reset the postcode to its original value. All SQL code to complete this full task must be shown in your submission. (3 marks)
Write the SQL code to create a copy of CUSTOMER, naming the copy CUST_2. Then write the SQL code that will add the attributes CUST_LEVEL and CUST_DISCOUNT to its structure. (4 marks)
Write the SQL command sequences to change the CUST_LEVEL and CUST_DISCOUNT values as shown in the table below for each of the following customers. (2 marks)
Customer
CustomerID Cust_Level Cust_Discount AA0621 1 0.05 GY0001 1 0.05 JB0012 3 0.15 JB6544 2 0.10
Write the SQL command sequences that will display first and last names of customers who haven’t ordered any books. (4 marks)
Write the SQL command sequences that lists all customers who have ordered books. The statement should return the Customer ID, Customer Name (Surname and First Name combined), Order Number, Order Date and Delivery Date. (4 marks)
Write the SQL command sequences that will increase the retail of all books by $20 if they are computer books or they have a cost of more than $40. (4 marks)
Write the SQL command sequences that lists the ISBN and Book Title for the most expensive book in the Technical Books database. (5 marks)
Write the SQL command sequences that determines the profit for each book (display ISBN, Title and Profit) (4 marks)
Write the SQL code required to list all customers whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in the listing. Assume case sensitivity. (4 marks)
Write the two SQL command sequences required to:
Create a temporary table named TEMP_1 whose structure is composed of the CUSTOMER attributes CUST_ID and CUST_LEVEL.
Copy the matching CUSTOMER values into the TEMP_1 table. (4 marks)
Write the SQL command that will delete the newly created TEMP_1 table from the database. (1 mark)
Appendix A
Items Maximum Marks Marks Obtained PART A: DESIGN (40 marks made up of) 40 – ER Diagram (20 marks) Completeness (participation & cardinality constraints & all relevant data represented) Accuracy – Relational Schema & normalisation (15 marks) – Assumptions/Additional Information (5 marks) PART B: SQL STATEMENTS: Marks as per assignment 45 documentation for Part B. Marks will be allocated on correctness and completeness of SQL statements. Total = 85
Punjab Assignment Help
Buy Online Assignment Help services for IT Assignments with Punjab Assignment Help at [email protected]
0 notes
Text
ICT701 | RELATIONAL DATABASE SYSTEMS ASSIGNMENT
New Post has been published on https://punjabassignmenthelp.com/ict701-relational-database-systems-assignment/
ICT701 | RELATIONAL DATABASE SYSTEMS ASSIGNMENT
ICT701 | RELATIONAL DATABASE SYSTEMS ASSIGNMENT | DATABASE
IT Assignment Help
Part A (40 marks)
Requirements
Based on the 2 tables given in the spreadsheet provided, students are to create a database design specification (entity relationship diagram (ERD) and relational data model (RDM)) from a given business description below. Students are to present this in a report (as specified in the submission format) which also includes a short discussion of the approach for the solution. This assignment is to be carried out and reported individually.
The following defines the minimum information that should be reported:
A brief discussion of your solution, i.e. how you approached the modelling problem and any issues you may have encountered. This includes any assumptions and suggestions for the new design (maximum of ½ page).
The Entity Relationship Diagram (ERD) (produced using a drawing tool such as those found in MS Word or PowerPoint, or a chosen CASE tool) for the system. Your ERD must use the ER notation that was taught in ICT701. Any assumptions made in creating the ERD must be explicitly stated in your report.
The Relational Data Model (RDM) which corresponds to the ERD. That is, the set of tables in 3rd normal form that could be used to represent the whole of this data model. Your RDM should identify primary, alternate and foreign keys.
Business Description
Technical Texts is an online reseller of textbooks to colleges and TAFEs. They deal with a number of publishers and sell a range of books in the Computers, Business, Medical and Sports category. They started off as a relatively small business only selling to a local TAFE. However, they quickly grew and now have a range of customers from all over Australia. When they started the business, they used a spreadsheet to manage the orders. However, as they grew, they realized that the spreadsheet was no longer able to meet their needs. They needed a better way to manage their orders. In the Excel spreadsheet books.xls you will see a sample of their orders table. They also have another table where they started storing the customer details. They hope to get a complete database up and running soon.
Part B (Total 45 Marks)
Complete the following SQL tasks using MySQL. The marks available for each SQL statement are indicated.
Write the SQL code that will create the table structure for the CUSTOMER Table. The basic CUSTOMER table structure is summarized in the table below. (1 mark)
ATTRIBUTE (FIELD) NAME DATA DECLARATION CUST_ID CHAR(6) CUST_LNAME VARCHAR(15) CUST_FNAME VARCHAR(15) CUST_ADD VARCHAR(25) CUST_CITY VARCHAR(15) CUST_STATE CHAR(3) CUST_PCODE CHAR(4)
Having created the table structure in Part B1 (1) above, write the SQL code to enter all the data in the table below into your EMPLOYEE table. (2 marks)
Customer
CustomerID FirstName Surname Address City State Postcode AA0621 Aaron Adamson 23 Chardonnay Crt Wilson WA 6107 GY0001 Gareth Yardley 88 Graham Rd Launceston TAS 7250 HA8870 Harriet Annerley 6 First Ave Belmont QLD 4153 JB0012 Jordan Black 12 Blackbird Lne Vermont VIC 3133 JB1165 John Brown 54 Georgette St Battery Point TAS 7004 JB1302 Jonathon Brown 45 Quail Crt Buderim QLD 4556 JB6544 Juliet Bardensley 7 Jamieson Circ Belmont NSW 2280 SA0010 Sally Adams 187 Main Rd Broadbeach QLD 4218
Assuming the data shown in the CUSTOMER table has been entered; write the SQL code that will list all attributes for a Postcode of 4556. (2marks)
Write the SQL code that will save the changes made to the EMPLOYEE table. (1 mark)
Write the SQL code to change the postcode to 6501 for the person whose Customer ID is AA0621. After you have completed the task, examine the results, and then reset the postcode to its original value. All SQL code to complete this full task must be shown in your submission. (3 marks)
Write the SQL code to create a copy of CUSTOMER, naming the copy CUST_2. Then write the SQL code that will add the attributes CUST_LEVEL and CUST_DISCOUNT to its structure. (4 marks)
Write the SQL command sequences to change the CUST_LEVEL and CUST_DISCOUNT values as shown in the table below for each of the following customers. (2 marks)
Customer
CustomerID Cust_Level Cust_Discount AA0621 1 0.05 GY0001 1 0.05 JB0012 3 0.15 JB6544 2 0.10
Write the SQL command sequences that will display first and last names of customers who haven’t ordered any books. (4 marks)
Write the SQL command sequences that lists all customers who have ordered books. The statement should return the Customer ID, Customer Name (Surname and First Name combined), Order Number, Order Date and Delivery Date. (4 marks)
Write the SQL command sequences that will increase the retail of all books by $20 if they are computer books or they have a cost of more than $40. (4 marks)
Write the SQL command sequences that lists the ISBN and Book Title for the most expensive book in the Technical Books database. (5 marks)
Write the SQL command sequences that determines the profit for each book (display ISBN, Title and Profit) (4 marks)
Write the SQL code required to list all customers whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in the listing. Assume case sensitivity. (4 marks)
Write the two SQL command sequences required to:
Create a temporary table named TEMP_1 whose structure is composed of the CUSTOMER attributes CUST_ID and CUST_LEVEL.
Copy the matching CUSTOMER values into the TEMP_1 table. (4 marks)
Write the SQL command that will delete the newly created TEMP_1 table from the database. (1 mark)
Appendix A
Items Maximum Marks Marks Obtained PART A: DESIGN (40 marks made up of) 40 – ER Diagram (20 marks) Completeness (participation & cardinality constraints & all relevant data represented) Accuracy – Relational Schema & normalisation (15 marks) – Assumptions/Additional Information (5 marks) PART B: SQL STATEMENTS: Marks as per assignment 45 documentation for Part B. Marks will be allocated on correctness and completeness of SQL statements. Total = 85
Punjab Assignment Help
Buy Online Assignment Help services for IT Assignments with Punjab Assignment Help at [email protected]
0 notes
Photo
New Post has been published on https://punjabassignmenthelp.com/ict701-relational-database-systems-assignment/
ICT701 | RELATIONAL DATABASE SYSTEMS ASSIGNMENT
ICT701 | RELATIONAL DATABASE SYSTEMS ASSIGNMENT | DATABASE
IT Assignment Help
Part A (40 marks)
Requirements
Based on the 2 tables given in the spreadsheet provided, students are to create a database design specification (entity relationship diagram (ERD) and relational data model (RDM)) from a given business description below. Students are to present this in a report (as specified in the submission format) which also includes a short discussion of the approach for the solution. This assignment is to be carried out and reported individually.
The following defines the minimum information that should be reported:
A brief discussion of your solution, i.e. how you approached the modelling problem and any issues you may have encountered. This includes any assumptions and suggestions for the new design (maximum of ½ page).
The Entity Relationship Diagram (ERD) (produced using a drawing tool such as those found in MS Word or PowerPoint, or a chosen CASE tool) for the system. Your ERD must use the ER notation that was taught in ICT701. Any assumptions made in creating the ERD must be explicitly stated in your report.
The Relational Data Model (RDM) which corresponds to the ERD. That is, the set of tables in 3rd normal form that could be used to represent the whole of this data model. Your RDM should identify primary, alternate and foreign keys.
Business Description
Technical Texts is an online reseller of textbooks to colleges and TAFEs. They deal with a number of publishers and sell a range of books in the Computers, Business, Medical and Sports category. They started off as a relatively small business only selling to a local TAFE. However, they quickly grew and now have a range of customers from all over Australia. When they started the business, they used a spreadsheet to manage the orders. However, as they grew, they realized that the spreadsheet was no longer able to meet their needs. They needed a better way to manage their orders. In the Excel spreadsheet books.xls you will see a sample of their orders table. They also have another table where they started storing the customer details. They hope to get a complete database up and running soon.
Part B (Total 45 Marks)
Complete the following SQL tasks using MySQL. The marks available for each SQL statement are indicated.
Write the SQL code that will create the table structure for the CUSTOMER Table. The basic CUSTOMER table structure is summarized in the table below. (1 mark)
ATTRIBUTE (FIELD) NAME DATA DECLARATION CUST_ID CHAR(6) CUST_LNAME VARCHAR(15) CUST_FNAME VARCHAR(15) CUST_ADD VARCHAR(25) CUST_CITY VARCHAR(15) CUST_STATE CHAR(3) CUST_PCODE CHAR(4)
Having created the table structure in Part B1 (1) above, write the SQL code to enter all the data in the table below into your EMPLOYEE table. (2 marks)
Customer
CustomerID FirstName Surname Address City State Postcode AA0621 Aaron Adamson 23 Chardonnay Crt Wilson WA 6107 GY0001 Gareth Yardley 88 Graham Rd Launceston TAS 7250 HA8870 Harriet Annerley 6 First Ave Belmont QLD 4153 JB0012 Jordan Black 12 Blackbird Lne Vermont VIC 3133 JB1165 John Brown 54 Georgette St Battery Point TAS 7004 JB1302 Jonathon Brown 45 Quail Crt Buderim QLD 4556 JB6544 Juliet Bardensley 7 Jamieson Circ Belmont NSW 2280 SA0010 Sally Adams 187 Main Rd Broadbeach QLD 4218
Assuming the data shown in the CUSTOMER table has been entered; write the SQL code that will list all attributes for a Postcode of 4556. (2marks)
Write the SQL code that will save the changes made to the EMPLOYEE table. (1 mark)
Write the SQL code to change the postcode to 6501 for the person whose Customer ID is AA0621. After you have completed the task, examine the results, and then reset the postcode to its original value. All SQL code to complete this full task must be shown in your submission. (3 marks)
Write the SQL code to create a copy of CUSTOMER, naming the copy CUST_2. Then write the SQL code that will add the attributes CUST_LEVEL and CUST_DISCOUNT to its structure. (4 marks)
Write the SQL command sequences to change the CUST_LEVEL and CUST_DISCOUNT values as shown in the table below for each of the following customers. (2 marks)
Customer
CustomerID Cust_Level Cust_Discount AA0621 1 0.05 GY0001 1 0.05 JB0012 3 0.15 JB6544 2 0.10
Write the SQL command sequences that will display first and last names of customers who haven’t ordered any books. (4 marks)
Write the SQL command sequences that lists all customers who have ordered books. The statement should return the Customer ID, Customer Name (Surname and First Name combined), Order Number, Order Date and Delivery Date. (4 marks)
Write the SQL command sequences that will increase the retail of all books by $20 if they are computer books or they have a cost of more than $40. (4 marks)
Write the SQL command sequences that lists the ISBN and Book Title for the most expensive book in the Technical Books database. (5 marks)
Write the SQL command sequences that determines the profit for each book (display ISBN, Title and Profit) (4 marks)
Write the SQL code required to list all customers whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in the listing. Assume case sensitivity. (4 marks)
Write the two SQL command sequences required to:
Create a temporary table named TEMP_1 whose structure is composed of the CUSTOMER attributes CUST_ID and CUST_LEVEL.
Copy the matching CUSTOMER values into the TEMP_1 table. (4 marks)
Write the SQL command that will delete the newly created TEMP_1 table from the database. (1 mark)
Appendix A
Items Maximum Marks Marks Obtained PART A: DESIGN (40 marks made up of) 40 – ER Diagram (20 marks) Completeness (participation & cardinality constraints & all relevant data represented) Accuracy – Relational Schema & normalisation (15 marks) – Assumptions/Additional Information (5 marks) PART B: SQL STATEMENTS: Marks as per assignment 45 documentation for Part B. Marks will be allocated on correctness and completeness of SQL statements. Total = 85
Punjab Assignment Help
Buy Online Assignment Help services for IT Assignments with Punjab Assignment Help at [email protected]
0 notes
Text
ICT701 | RELATIONAL DATABASE SYSTEMS ASSIGNMENT
New Post has been published on https://punjabassignmenthelp.com/ict701-relational-database-systems-assignment/
ICT701 | RELATIONAL DATABASE SYSTEMS ASSIGNMENT
ICT701 | RELATIONAL DATABASE SYSTEMS ASSIGNMENT | DATABASE
IT Assignment Help
Part A (40 marks)
Requirements
Based on the 2 tables given in the spreadsheet provided, students are to create a database design specification (entity relationship diagram (ERD) and relational data model (RDM)) from a given business description below. Students are to present this in a report (as specified in the submission format) which also includes a short discussion of the approach for the solution. This assignment is to be carried out and reported individually.
The following defines the minimum information that should be reported:
A brief discussion of your solution, i.e. how you approached the modelling problem and any issues you may have encountered. This includes any assumptions and suggestions for the new design (maximum of ½ page).
The Entity Relationship Diagram (ERD) (produced using a drawing tool such as those found in MS Word or PowerPoint, or a chosen CASE tool) for the system. Your ERD must use the ER notation that was taught in ICT701. Any assumptions made in creating the ERD must be explicitly stated in your report.
The Relational Data Model (RDM) which corresponds to the ERD. That is, the set of tables in 3rd normal form that could be used to represent the whole of this data model. Your RDM should identify primary, alternate and foreign keys.
Business Description
Technical Texts is an online reseller of textbooks to colleges and TAFEs. They deal with a number of publishers and sell a range of books in the Computers, Business, Medical and Sports category. They started off as a relatively small business only selling to a local TAFE. However, they quickly grew and now have a range of customers from all over Australia. When they started the business, they used a spreadsheet to manage the orders. However, as they grew, they realized that the spreadsheet was no longer able to meet their needs. They needed a better way to manage their orders. In the Excel spreadsheet books.xls you will see a sample of their orders table. They also have another table where they started storing the customer details. They hope to get a complete database up and running soon.
Part B (Total 45 Marks)
Complete the following SQL tasks using MySQL. The marks available for each SQL statement are indicated.
Write the SQL code that will create the table structure for the CUSTOMER Table. The basic CUSTOMER table structure is summarized in the table below. (1 mark)
ATTRIBUTE (FIELD) NAME DATA DECLARATION CUST_ID CHAR(6) CUST_LNAME VARCHAR(15) CUST_FNAME VARCHAR(15) CUST_ADD VARCHAR(25) CUST_CITY VARCHAR(15) CUST_STATE CHAR(3) CUST_PCODE CHAR(4)
Having created the table structure in Part B1 (1) above, write the SQL code to enter all the data in the table below into your EMPLOYEE table. (2 marks)
Customer
CustomerID FirstName Surname Address City State Postcode AA0621 Aaron Adamson 23 Chardonnay Crt Wilson WA 6107 GY0001 Gareth Yardley 88 Graham Rd Launceston TAS 7250 HA8870 Harriet Annerley 6 First Ave Belmont QLD 4153 JB0012 Jordan Black 12 Blackbird Lne Vermont VIC 3133 JB1165 John Brown 54 Georgette St Battery Point TAS 7004 JB1302 Jonathon Brown 45 Quail Crt Buderim QLD 4556 JB6544 Juliet Bardensley 7 Jamieson Circ Belmont NSW 2280 SA0010 Sally Adams 187 Main Rd Broadbeach QLD 4218
Assuming the data shown in the CUSTOMER table has been entered; write the SQL code that will list all attributes for a Postcode of 4556. (2marks)
Write the SQL code that will save the changes made to the EMPLOYEE table. (1 mark)
Write the SQL code to change the postcode to 6501 for the person whose Customer ID is AA0621. After you have completed the task, examine the results, and then reset the postcode to its original value. All SQL code to complete this full task must be shown in your submission. (3 marks)
Write the SQL code to create a copy of CUSTOMER, naming the copy CUST_2. Then write the SQL code that will add the attributes CUST_LEVEL and CUST_DISCOUNT to its structure. (4 marks)
Write the SQL command sequences to change the CUST_LEVEL and CUST_DISCOUNT values as shown in the table below for each of the following customers. (2 marks)
Customer
CustomerID Cust_Level Cust_Discount AA0621 1 0.05 GY0001 1 0.05 JB0012 3 0.15 JB6544 2 0.10
Write the SQL command sequences that will display first and last names of customers who haven’t ordered any books. (4 marks)
Write the SQL command sequences that lists all customers who have ordered books. The statement should return the Customer ID, Customer Name (Surname and First Name combined), Order Number, Order Date and Delivery Date. (4 marks)
Write the SQL command sequences that will increase the retail of all books by $20 if they are computer books or they have a cost of more than $40. (4 marks)
Write the SQL command sequences that lists the ISBN and Book Title for the most expensive book in the Technical Books database. (5 marks)
Write the SQL command sequences that determines the profit for each book (display ISBN, Title and Profit) (4 marks)
Write the SQL code required to list all customers whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in the listing. Assume case sensitivity. (4 marks)
Write the two SQL command sequences required to:
Create a temporary table named TEMP_1 whose structure is composed of the CUSTOMER attributes CUST_ID and CUST_LEVEL.
Copy the matching CUSTOMER values into the TEMP_1 table. (4 marks)
Write the SQL command that will delete the newly created TEMP_1 table from the database. (1 mark)
Appendix A
Items Maximum Marks Marks Obtained PART A: DESIGN (40 marks made up of) 40 – ER Diagram (20 marks) Completeness (participation & cardinality constraints & all relevant data represented) Accuracy – Relational Schema & normalisation (15 marks) – Assumptions/Additional Information (5 marks) PART B: SQL STATEMENTS: Marks as per assignment 45 documentation for Part B. Marks will be allocated on correctness and completeness of SQL statements. Total = 85
Punjab Assignment Help
Buy Online Assignment Help services for IT Assignments with Punjab Assignment Help at [email protected]
0 notes
Text
Western Australia Postcode Data - DataTools Verified Address Lists
Get reliable WA postcode address data with verified residential, unit, and geographic info. Ideal for sales, research, logistics, and data-driven strategies. Download Western Australia address lists instantly for accurate results.
#Western Australia Address Lists#Australian Address Database#Targeted Address Lists#Residential And Business Address Lists
0 notes
Text
COVID-19 update 21 June 2022
WA Health is reporting a total of 4,885 new cases to 6pm last night. There are currently 29,277 active cases in Western Australia.
To 6pm last night, there were 259 people with COVID-19 in hospital, 8 in ICU.
Sadly, today’s report includes six deaths, dating back to 11 June, which were reported to WA Health yesterday.
This includes a woman and man in their 90s, two women in their 80s, a man in his 70s and a woman in her 60s.
Due to confidentiality requirements, no further information on these cases will be released by the Department.
Total case breakdown:
Region Active (new to 6pm last night) Metropolitan 23,745 (3,938) Goldfields 473 (78) Great Southern 605 (125) Kimberley 196 (40) Midwest 867 (163) Pilbara 376 (63) South West 1,897 (296) Wheatbelt 661 (119)
Notes
This data is based on the residential postcode of each case. The case may have an isolation address in another region.
The remainder of daily cases reported (63) are yet to have a region assigned. Data will continue to be reconfigured as this information is verified.
Of the 4,885 cases, 1,245 were confirmed via PCR test, the remaining 3,640 were self-reported positive rapid antigen tests.
A total of 8,283 PCR tests were conducted at either state-run or private pathology clinics yesterday.
WA has recorded 860,720 cases since the COVID-19 pandemic began.
0 notes
Text
COVID-19 update 12 June 2022
WA Health is reporting a total of 4,900 new cases to 8pm last night. There are currently 39,051 active cases in Western Australia.
To 8pm last night, there were 261 people with COVID-19 in hospital, 7 in ICU.
Sadly, today’s report includes two new deaths dating back to 3 June which were reported to WA Health yesterday; a woman in her 80s and a woman in her 60s.
Due to confidentiality requirements, no further information on these cases will be released by the Department.
Total case breakdown:
Region Active (new to 8pm last night) Metropolitan 31,658 (3,995) Goldfields 572 (81) Great Southern 822 (104) Kimberley 288 (19) Midwest 1,191 (149) Pilbara 670 (61) South West 2,550 (332) Wheatbelt 831 (95)
Notes
This data is based on the residential postcode of each case. The case may have an isolation address in another region.
The remainder of daily cases reported (64) are yet to have a region assigned. Data will continue to be reconfigured as this information is verified.
Of the 4,900 cases, 1,733 were confirmed via PCR test, the remaining 3,167 were self-reported positive rapid antigen tests.
A total of 4,995 PCR tests were conducted at either state-run or private pathology clinics yesterday.
WA has recorded 815,084 cases since the COVID-19 pandemic began.
0 notes
Text
COVID-19 update 7 June 2022
WA Health is reporting a total of 5,787 new cases to 8pm last night. There are currently 38,598 active cases in Western Australia.
To 8pm last night, there were 290 people with COVID-19 in hospital, 15 in ICU.
Sadly, today’s report includes two new deaths dating back to 3 May which was reported to WA Health yesterday; a man in his 90s and a man in his 70s.
Due to confidentiality requirements, no further information on these cases will be released by the Department.
Total case breakdown:
Region Active (new to 8pm last night) Metropolitan 31,194 (4,623) Goldfields 591 (89) Great Southern 813 (135) Kimberley 380 (51) Midwest 988 (177) Pilbara 712 (129) South West 2,910 (382) Wheatbelt 815 (125)
Notes
This data is based on the residential postcode of each case. The case may have an isolation address in another region.
The remainder of daily cases reported (76) are yet to have a region assigned. Data will continue to be reconfigured as this information is verified.
Of the 5,787 cases, 1,319 were confirmed via PCR test, the remaining 4,468 were self-reported positive rapid antigen tests.
A total of 7,885 PCR tests were conducted at either state-run or private pathology clinics yesterday.
WA has recorded 781,496 cases since the COVID-19 pandemic began.
0 notes
Text
COVID-19 update 6 June 2022
WA Health is reporting a total of 4,849 new cases to 8pm last night. There are currently 41,244 active cases in Western Australia.
To 8pm last night, there were 279 people with COVID-19 in hospital, 16 in ICU.
Sadly, today’s report includes one new death dating back to 30 May which was reported to WA Health yesterday; a man in his 80s.
Due to confidentiality requirements, no further information on these cases will be released by the Department.
Total case breakdown:
Region Active (new to 8pm last night) Metropolitan 33,265 (3,958) Goldfields 674 (52) Great Southern 877 (110) Kimberley 414 (53) Midwest 1,010 (114) Pilbara 767 (89) South West 2,910 (327) Wheatbelt 877 (93)
Notes
This data is based on the residential postcode of each case. The case may have an isolation address in another region.
The remainder of daily cases reported (53) are yet to have a region assigned. Data will continue to be reconfigured as this information is verified.
Of the 4,849 cases, 1,399 were confirmed via PCR test, the remaining 3,450 were self-reported positive rapid antigen tests.
A total of 5,806 PCR tests were conducted at either state-run or private pathology clinics yesterday.
WA has recorded 775,741cases since the COVID-19 pandemic began.
Anyone experiencing symptoms should get tested immediately and isolate until they receive a negative result. Visit the HealthyWA website for a full list of testing clinics and opening hours (external site).
COVID-19 vaccinations
Vaccination information is available on the WA COVID-19 dashboard (external site).*
People are encouraged to make a booking via Vaccinate WA.
0 notes