Course Solutions Uncategorized (Solved) : Create Table Studentgrade Following Fields Regno Name Mark1 Mark2 Mark3 Create Primary Key Q31677476 . . . .

(Solved) : Create Table Studentgrade Following Fields Regno Name Mark1 Mark2 Mark3 Create Primary Key Q31677476 . . . .

 

Create a table student_grade having following fields.
regno, name, mark1, mark2, mark3. Create a primary key onregno.
Use appropriate data type to describe each field.
If a student is absent for a subject the corresponding field isnull.
Insert 5 values into the student_grade table.
1. Write a query that will display regno,name, result where eachcolumn value should be displayed of 20 character, if the value isless than of 20 character right pad regno, left pad name with ‘*’and left pad total with ‘#’.
2. Display the details of all students with 5 letter names.
3. Concatenate student name and regno separated by a ‘,’ thestudent name should

OR

PayPal Gateway not configured

OR

PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

(Answered) : Question 3 5 Marks Given Following Costs Monthly Sales Forecasts Snow Boots Lefarge Compan Q28866182(Answered) : Question 3 5 Marks Given Following Costs Monthly Sales Forecasts Snow Boots Lefarge Compan Q28866182

<p dir="ltr"><img src="https://d2vlcm61l7u1fs.cloudfront.net/media%2F93e%2F93ed99ce-2a12-47b0-90f5-1a9fc1ff06fd%2Fimage" alt="Question 3 5 Marks Given the following costs and monthly sales forecasts of snow-boots of Lefarge Company, create an aggregate production plan for this company, using the

(Solved) : 21 Following Implementation Accepted Compiler Class Automobile Public Void Setprice Double Q38187872 . . . .(Solved) : 21 Following Implementation Accepted Compiler Class Automobile Public Void Setprice Double Q38187872 . . . .

<p>21.   The following implementation is accepted bycompiler:</p><p>class Automobile<br/>{<br/>public:<br/>   void SetPrice(double newPrice);<br/>   void SetProfit(double newProfit);<br/>   double GetPrice();<br/>private:<br/>   double price;<br/>   double profit;<br/>   double GetProfit();<br/>};</p><p>int main()<br/>{<br/>   Automobile hyundai;<br/>   hyundai.price={ 4999.99 };<br/>)</p><p>T__ F__<br/>  <br/>22. The