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

  Write a program stars that uses two nested for loops

Write a program Stars that uses two nested for loops to output the pattern of stars shown below (note that there are no spaces in between stars).

  Write statement to assign new value to element of array

Write a single statement that assigns a new value to element of the array indexed by j . This new value should be equal to twice the value stored in the next element of the array.

  Write program which reads data into type integer

Write down the program which reads data into type int. Valid values are from 0 to 10. The program must find out how many values were inputted.

  Create set-list of enumerated constants called week

Create set/list of enumerated constants called week which contains days of week. Have variable called today that is of kind week. Allot a value to today.

  Explain how array simplifies program development

Describe the requirement for complex data structures and how they are utilized. Describe the design and application of arrays and how array simplifies program development.

  What will the permissions string contain

If you execute ls -ld on the project38" directory, what will the permissions string contain? If you execute ls -l on the iapp_v_8 file contained in project38 , what will the permissions string contain

  Write the ruby source code for problem

Write the Ruby source code for Problem - Write a PhoneContact class that gets initialized with a phone number and a label.

  Write potential function to derive valid amortized cost

Consider base 3 counter and de ne actual cost of increment operation to be number of digits which get changed. Provide a potential function which enables you to derive smallest valid amortized cost.

  Use of various bash commands

Assignment On: This work will require scripting the use of various bash commands and / or small programs that involve directory and file structures.

  Create application which permits user to input a price

Create an application which allows a user to input a price until suiatble sentinel value is entered. Output is a price of each item on each day,one through seven.

  Describe benefits of code citations to avoid plagiarism.

Describe some benefits of code citations in addition to avoiding plagiarism.

  Write program to calculate cost of flowers sold at stand

Write down the program in class FlowerCounter which calculates the cost of flowers sold at flower stand. Five types of flowers-petunia, pansy, rose, violet, and camation- are stocked and cost.

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