Order now
     

Database Management Homework 4 Create a database with three tables. Each table should be connected via a foreign key. Each table should have a minimum of six fields (to include text and numerical – integer/decimal). You will then produce a report displaying records that satisfy two separate criteria and you will also create two calculated fields (could be the average of the values or an increase in a value, say 12%). You need to use headings other than the field names for the report. All relevant fields should be on the report. Submission: You need to submit the code to: Create the database (including the field definitions) Insert (minimum of) 6 records into each table. Select the report (with calculated fields). Test your code with any of the online SQL engines. Grading criteria: The database needs to make sense (do not have silly fields) The SQL should run without error and a readable report should be produced.

Database Management Homework 4

Create a database with three tables. Each table should be connected via a foreign key. Each table should have a minimum of six fields (to include text and numerical – integer/decimal). You will then produce a report displaying records that satisfy two separate criteria and you will also create two calculated fields (could be the average of the values or an increase in a value, say 12%). You need to use headings other than the field names for the report. All relevant fields should be on the report.

Submission:

You need to submit the code to:

Create the database (including the field definitions)

Insert (minimum of) 6 records into each table.

Select the report (with calculated fields).

Test your code with any of the online SQL engines.

Grading criteria:

The database needs to make sense (do not have silly fields)

The SQL should run without error and a readable report should be produced.