1- List all the users and their card name using union2- List all the users and their card name using Intersection3- List all the card numbers with owner names and scheduled transactions, in case the user hasnever used scheduled transaction show null or zero in the transaction column. (Hint use ISNULLfunction) UserUserCard* USER_ID* UserlD* CardNumNameUserTypeTransaction* Trans_IDphone_NumCityTransDateCardNumAmountCardTrans type* CardNumCardTypelDPINUserType* UserTypelDExpireDatebalanceNameTransactionType8 Trans_Type IDTypeNameCardType8 CardTypelDDescriptionNameDescription user TypelDname1Silver2Gold3Bronze44Commonuserlduser Type phoneNumcitynameAli203036067000 Narowal22Ahmed103036047000 Lahore3Аgeel303036063000 Karachi44Usman 403036062000 Sialkot55Hafeez 203036061000 LahoreuserlDcardNum11324327436569123432432534362232432542333623432432534363232432543656662324325423336cardNumcard TypelD PINexpire Date balance11324327436569 31770 2022-07-01 43025.312232432542333630234 2020-03-02 14425.623232432543656611234 2019-02-06 34325.5242324325666456 21200 2021-02-05 24325.32343243253436 20034 2020-09-02 34025.12card TypelDname description11Debit Spend Now, Pay NowCredit Spend Now, Pay later3GiftEnjoytransld transDatecardNumamount trans Type112017-02-02 1324327436569500122018-02-03 234324325343630003332017-05-06 2324325436566 25002442016-09-09 2324325436566 2000152015-02-10 2324325423336 60004trans TypelD typeName description11Withdraw NULL2DepositNULL3Schedul. NULL4FailedNULL234N3

Answer1 : We will need to join the multiple sets to get the required details So, we will join the…

1- List all the users and their card name using union 2- List all the users and their card name using Intersection 3- List all the card numbers with owner names and scheduled transactions, in case the user has never used scheduled transaction show null or zero in the transaction column. (Hint use ISNULL function)

1- List all the users and their card name using union 2- List all the users and their card name using Intersection 3- List all the card numbers with owner names and scheduled transactions, in case the user has never used scheduled transaction show null or zero in the transaction column. (Hint use ISNULL function)

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter10: Classes And Objects

Section: Chapter Questions

Problem 8E

See similar textbooks

Similar questions

Using C++ create a class Parent with Name & CNIC number as a private data members. Create a getinput & showinput functions & set values through getter & setters. Create another class Student with section as private data member & examscore as a protected data members. Class Student is a relationship with class Parent. Create a getdata & displaydata functions & set values through getter & setters. Create a third class Resultcard with remarksbyteacher as a private data members. Create a function getgrade which calculate the grade of students according to their marks and then display the report card of student. Class Resultcard is a relation with class Student.
Create a basic grading system app using Java Programming language The program should include the ff. topics: Operators Control Structures and Array OOP Encapsulation and Inheritance Polymorphism and Abstraction Exception Collections Input and Output Stream
body { } .cb-title { } .bb-title { } .cb-btm { } .bb-btm { }
Task Class Requirements The task object shall have a required unique task ID String that cannot be longer than 10 characters. The task ID shall not be null and shall not be updatable. The task object shall have a required name String field that cannot be longer than 20 characters. The name field shall not be null. The task object shall have a required description String field that cannot be longer than 50 characters. The description field shall not be null. Verify with Juint testing as well
c++ language Create Class Student▪ Data Members: Name , ID and GPA.▪ Make the data members visibility to be private.▪ Use setter and getter method for each attribute.▪ In the main, set values for the student details using setter function, then retrieve the value using the getter function.▪ Print what you retrieve
Create a Windows Forms application. Use the following names for the project andsolution, respectively: Adaline Project and Adaline Solution. Save the application inthe VB2017\Chap08 folder. Create the interface shown in Figure 8-54. The figure alsocontains the major tasks that the application needs to perform. Code the application.Save the solution and then start and test the application.Tasks1). Declare a class-level Integer array to store the sales amounts for the following salespeople.You can create either a two-row, six-column array or a six-row, two-colurnn array.
Alias is also known as a data type. True False We can use Hierarchy to combine two values of a dimension into a single category. True False ........... Which of the following can include multiple version of the same worksheet? * 0/2 Dashboard and stories Stories but not dashboards Dashboards but not stories Neither dashboards nor stories ......... A color gradient is used for which of the following * 0/2 Discrete measure Continuous measure Both continuous and discrete N/A
Serialization and Deserialization using Json and XML The Atom class This is the front end of the application. There are 12 members. Atom Class Fields Properties + «c# property, set» Name : string + «c# property, set» Symbol : string + «c# property, set» Proton : int + «c# property, set» Neutron : int + «c# property, set» Weight : double Methods + «c# constructor» Atom() + «c# constructor» Atom( string name, int proton, int neutron, double weight, string symbol) $+ Parse(string objectData) : Atom $+ GetAtoms() : List<Atom> + ToString() : double Description of class members Fields: There are no fields in this class. Properties: All the properties have public get and set Name – this is a string representing the name of this atom. Both the getter and setter are public. Symbol – this is a two-letter string representing the…
Square Me Up Code in C language point.h code// WARNING: Do not change this file.// Doing so will nullify your score for the activity.typedef struct { int x; int y;} Point; rectangle.h code // WARNING: Do not change this file.// Doing so will nullify your score for the activity.#include "point.h" typedef struct { Point upp_rig; Point low_lef;} Rectangle;
hi i need solution for this Each account should have a constant, unique id. Id numbers should start from 1000 and increment by 5. The ACCOUNT_ID attribute should be initialised when the account object is created. The id should be generated internally within the class, it should not be passed in as an argument
Pointer variable stores the address where another object resides and system will automatically do garbage collection. Group of answer choices True False
void HandleStuff( CORP_DATA & inputRec, int crntQtr, EMP_DATA empRec, double & estimRevenue, double ytdRevenue, int screenX, int screenY, COLOR_TYPE & newColor, COLOR_TYPE & prevColor, statusType & status, int expenseType ) int i; for(i { = 0; i<100 ;i++) inputRec.revenue[i] inputRec.expense[i] = 0; = corpExpense[ crntQtr ][i]; } UpdateCorpDatabase(empRec); estimRevenue = YtdRevenue *4.0 / (double) crntQtr; newColor = prevColor; status = SUCCESS; if(expenseType == 1){ for(i = 0;i<12;i++){ profit[i] = revenue[i] } } else if(expenseType == 2) expense.type1[i]; { profit[i] = revenue[i] } expense.type2[i]; else if(expenseType == 3){ profit[i] = revenue[i] - expense.tyре3[i]; }