Question: write database query and report in the following: Task 1 Question No. 1 [05) [8 Marks] Create different database tables based on a real-life scenario.
write database query and report in the following:

![No. 1 [05) [8 Marks] Create different database tables based on a](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f324060bd07_50166f3240594aa2.jpg)
Task 1 Question No. 1 [05) [8 Marks] Create different database tables based on a real-life scenario. Apply all the different table constraints on those tables created. Demonstrate appropriate relationships among those tables created. Task 2 Question No. 2 [04] [8 Marks] Design appropriate data entry forms for all the tables. Enter records into those tables and save the data. Task 3 Question No. 3 [03] [8 Marks] Create different types of reports. Define various formula column values related with the tables and use them in the reports. Display various Grand totals and subtotals after grouping the records and applying applying required Column- Breaks
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
