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:

 write database query and report in the following: Task 1 Question

No. 1 [05) [8 Marks] Create different database tables based on a

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!