Write a c api program under mysql to solve database query

Assignment Help Programming Languages
Reference no: EM131156810

In earlier assignment, we created a database with the following three relation schemes, where the data type for the attributes s and p is Varchar(10) under the SQL-standard, the data type of the attribute c is Char(6) and the attribute sec is of type int. For testing purposes, some sample tables for these schemes were given before in Assign(3).

-     Enrolls(s, c, sec)

-     Teaches(p, c, sec)

-     Likes (s, c)

-     Prereqs(c,Pre)

Write a (C-API) program under mySQL to solve the query: "Find all courses liked by a given student".

Include the following items in your solution submission:

-     a listing of your source program,

-     the result of compilation of the source program, and

-     the result of testing your program. Perform at least two tests; where in the first use Chris for the student, and in the second use Jack.

In this question, you can use the tables under my own database (named farrag), if you did not create your own. Notice the marker may check your source program to make sure it compiles and runs on our server.

134_1.png

Reference no: EM131156810

Questions Cloud

Explain whether we should have international code of ethics : Explain whether we should we have an international code of ethics by evaluating the various issues presented by the existence of such a code, and be sure to examine the connections between business, law, politics, and ethics.
Detailed description of the option chosen : Using a property valued at $998,000 Financing option: 15 year ARM *provide a detailed description of the option chosen Determine a down payment
Getting started discussion of a math course : Think back to the Getting Started discussion of a math course which is Math Proof/ Problem solving you were asked your thoughts on proof and problem solving. After completing this course
How the organization can capitalize on the two opportunities : Discussion as to how the organization can capitalize on the two opportunities that are occurring from the forces from within the external environment.
Write a c api program under mysql to solve database query : In earlier assignment, we created a database with the following three relation schemes, where the data type for the attributes s and p is Varchar(10) under the SQL-standard, the data type of the attribute c is Char(6) and the attribute sec is of type..
Five initiatives to provide excellent customer service : List and describe any five initiatives to provide excellent customer service. Discuss the customer's perception of quality. Discuss any five tips that would help employers/employees to provide quality customer service.
How would you implement these ideas within your organization : Discuss a time when you have been a member of a team that has not performed well. Why was the team not effective? What role did the leader play in the team's inability to perform? What steps should have been taken to address the issues?
Factored form and then multiply itout : Find a polynomial of degree four with these given zeros. Write in factored form and then multiply itout. -1,2, and2-?
Improve process efficiency : One of Bob's objectives is to improve process efficiency by improving the activities that define the processes.- The actual prices paid for materials and engineering hours are identical to the standard or budgeted prices.

Reviews

Write a Review

Programming Languages Questions & Answers

  What is code reuse

What is code reuse. How does inheritance help achieve code reuse

  Create program to produce a summary of amounts due

Create a program that will produce a summary of the amounts due for Pat's Auto Repair Shop. Display a splash screen first, then display the Job Information Form.

  Write a program that inputs number of hours worked

Write a program that inputs the number of hours worked and hoursly pay rat for employesand outputs their total pay.

  Create a class named rectangle with length and width

To cover that floor with carpet that costs $8 per square foot would cost $960. (12 x 10 x8 = 960.). You should create a class named Rectangle with the following properties:

  Define a class called revenue that has 2 private members

Use public functions of the class in a program that computes RevenueValue and displays RevenueValue when demand is 2000 and price is 2.

  Write one instruction to reverse the lsb

write ONE instruction to reverse the LSB of the 2nd and 3rd elements of arr - Write code to determine if a data value is a power of 2,

  Assess the key practices and improvement activities from

suppose you are working as a senior software development manager in a software house. the company develops custom

  Give the code for rectangular

Give the code for rectangular, triangular, hamming, blackman and hanning windowing for a LPF and use sine waves to show its working.

  What will happen if the order of thenbspcatchnbspblocks is

q1. what runtimeexception if any will the following program throw?class exception1 public static void mainstring

  How recursion terminate in array

Continue in this fashion until entire array is read. Then recursively determine a candidate for B; this is  candidate for A (why?). How does the recursion terminate?

  Deisgn class contains data fields for height and surfacearea

Deisgn a class named Rectangle that contains data fields for height width and surfaceArea and a method named computeSurfaceArea?

  Design application that reads arbitary number of integers

Design and implement an application that reads an arbitary number of integers that are in the range of 0 to 50 inclusive and counts how many occurences of each are entered.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd