3. Create a new database for your selected topic. 4. Create two tables related your topic. Each…
3. Create a new database for your selected topic.
4. Create two tables related your topic. Each table (A-B) should have a primary key column
and connects each other with a foreign key (Table A has a foreign key which reference to Table
B).
5. Insert at least five records to Table A and three records to Table B using SQL statement.
6. Write a C++ application using either procedural program style or OOP. Your application should
be able to perform following actions:
4. Create two tables related your topic. Each table (A-B) should have a primary key column
and connects each other with a foreign key (Table A has a foreign key which reference to Table
B).
5. Insert at least five records to Table A and three records to Table B using SQL statement.
6. Write a C++ application using either procedural program style or OOP. Your application should
be able to perform following actions:
List of functions:
1. Add a record: The values of each column of the record should be entered by the user. You
will complete this procedure for your only one table
i. If you choose Table A which has a foreign key, your implementation should force
to user to enter the foreign key value among the primary key values in Table B.
ii. Adding a record to Table B
1. Add a record: The values of each column of the record should be entered by the user. You
will complete this procedure for your only one table
i. If you choose Table A which has a foreign key, your implementation should force
to user to enter the foreign key value among the primary key values in Table B.
ii. Adding a record to Table B
2. Prints all records of Table B to the console
3. Prints all records of Table A and Table B as a join table to the console
4. Prints some records of Table A depends of the value entered by the user.
5. Prints some sql function results (MAX,SUM,COUNT etc.) of the Table (A or B)
3. Prints all records of Table A and Table B as a join table to the console
4. Prints some records of Table A depends of the value entered by the user.
5. Prints some sql function results (MAX,SUM,COUNT etc.) of the Table (A or B)
Main function : You will call these actions from the main. You have two options
1. Design a main as a test application to show all your functions run correctly
2. Design a main as a database application, shows each function as an option in the
option list and request a number from the user to run the functions. The program continues
to show the option list until user enters exit option.
1. Design a main as a test application to show all your functions run correctly
2. Design a main as a database application, shows each function as an option in the
option list and request a number from the user to run the functions. The program continues
to show the option list until user enters exit option.
