in SQL programming and i need it in zip to sending please in my email Task 1

Question No. 1 [O5] [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.

CREATION OF TABLES FOR CUSTOMER, ITEM AND ORDER is done below CONSTRAINTS ARE APPLIED: 1. CID of CUSTOMER table should start with the letter C 2. INO of ITEM table should start with the letter I RELATIONSHIP AMONG TABLES: 1. Primary key on CID and INO 2. Foreign key CID of ORDER table by referencing to CID of CUSTOMER table 3. Foreign key INO of ORDER table by referencing to INO of ITEM table ////////////////////////////////////////////////

Task 2

Question No. 2 [O4] [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 [O3] [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 required Column-Breaks

Task 4

Question No. 4 [O6] [6 Marks]

• Format the reports with appropriate Header, Footer, etc.
• Print all the required SQL commands used during the project.
• Submit/present your software application with its proper documentation along with the software.

subject:computer

Question No. 4 [O6] [6 Marks] Format the reports with appropriate Header, Footer, etc. Print all the required SQL commands used during the project. Submit/present your software application with its proper documentation along with the software.