Using absolute cell references as necessary, in cell C23, construct a formula to calculate the projected expenses for 2020 after the Forecasted increase in cell B21 is applied. Fill the formula through cell F23.

Question 7 A video store stocks movie DVDs. Consider the ERD below. Assume COPY 187654 is a valid copy. What can you determine about the statement "COPY 187654 contains the first three Star Wars movies". MOVIE Has Contains COPY This statement could be true based on the ERD. This statement could NOT be true based on the ERD.

4. Find all instructors in Finance department who have taught some course in 2008. 5. Find all students from Physics department who took course 'CS-319'.

Technology College Muscat hired you as a programmer to automate their manual Student Registration System. The college requires you to develop a C++ program to manage their Students' personal and academic record. You are required to develop a C++ program using C++ structures, arrays, and user defined functions. The college stores each student's full name, a maximum of 30 character long, student's age, numeric student's ID number of 8 digits long, student's modules enrolled and student's module result. You are required to implement 3 different functions, a function to get/input all the data of a student from a user. A function to get/input student's modules and result against each module and to calculate average marks of each students, and a function to display all students' personal and academic data. You are required to demonstrate storing of 5 students and displaying their stored data with average marks. You are also required to calculate and display the overall result analysis for 5…