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

  Determine recursive procedure and iterative procedure

Determine the example or recursive procedure and represent it as iterative procedure. Also, select the iterative procedure which you would re-write as recursive.

  Do comments explain processing that is not obvious

When reviewing a program, these are the four criteria for style: Do identifiers logically describe use? Is indentation used correctly to illustrate the structure of the program?

  What is the height of the retinal image

Create a binary image at least 64x64 in dimensions. Using Octave's existing functions, perform Average, Gaussian and Laplacian filters on the image. Display the original image and each of the filtered images in Octave plots. Discuss and compare your..

  Write program which asks user for number of bolts

Write C++ program which asks user for number of bolts and number of nuts in their purchase and then computes and prints out total cost.

  Traditional versus object-oriented design

Compare the object-oriented approach to design to the traditional approach. Give your opinion on whether or not you believe there are certain projects where one design approach might be better that the other. If so, provide an example of one (1) s..

  Explain a work place program designed to help participants

Write down four one-sentence goals for program. Each of the four goals shold associate to successful program completion and must promote one specific health behavior.

  Definition of function quadratic receives double parameters

Write down definition of function named quadratic which receives 3 double parameters a , b , c . If value of a is 0 then function prints the message "no solution for a=0"

  Create a windows form application in c#

The total price will be the number of computed rental days times the cost for the model of car selected ($19.95/day for Compact, $24.95/day for Standard and $39/day for Luxury).

  Write program which inputs the string from user

Write a program which inputs the string from a user. Then it will take character as input and prints string onwards from that character.

  Compute average of values contained in integer

Compute the average (as a double) of values contained in integer variables num1, num2, num3 and allot that average to double variable avg.

  Write a program learn multiplication

Write a program which will help the elementary school student learn multiplication. Use Random object to produce two positive one-digit integers.

  Write program that compute the amount person earn

Write a program which computes the amount a person would earn over period of time if his or her salary is one penny the first day, two pennies second day.

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