Wrong querry thumbs down posting TICKET_IDOBUS NOSCHEDULESCHEDULE_IDTRAVEL DATESOURCEDESTINATIONDURATIONOPTICKET_IDOBD_IDTICKETSTICKET ID varchar2(3) SCHEDULE_IDOSCHEDULE_ID varchar2(3) OFAREOUSER_IDNO_SEATSnumber(11)# USER_IDnumber(11) Onumber(11) #CANCELLATIONvarchar2(3)date dvarchar2(20) tvarchar2(20) tnumber(11) NOnumber(11) #CANCELLATION_ID varchar2(3) tvarchar2(3) BDnumber(11)IDTICKET_IDBD ID-OBD_IDPAYMENTS.PAYMENT_ID varchar2(3) tTICKET_IDUSERSUSER_ID number(11)NAMEvarchar2(20) tADDRESS varchar2(100) tBUS NOBUS_NAMETYPEODISCOUNT_ID varchar2(3)PHNOnumber(11) #EMAILID varchar2(30) tBUSESvarchar2(20) tTOTAL_SEATS number(11) #AVAIL SEATS number(11) #number(11)varchar2(20) tvarchar2(3)number(11) DISCOUNT_IDBOOKINGDETAILSPBD_ID number(11)ACC_NO number (11) #NAME varchar2(10) tUSER_ID number(11) USER_IDDISCOUNTSPDISCOUNT_IDvarchar2(3)DISCOUNT AMOUNT number(11) #primary key not null.foreign key#data type numberddata type- datet data type - varchar2

here,Given in the above question:Develop a SQL query to display schedule_id, source, destination,…

Answered: erry thumbs down posting

Engineering

Computer Science

erry thumbs down posting

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter11: Sql Server Databases

Section: Chapter Questions

Problem 4E

See similar textbooks

Similar questions

struct DateTag{ int nMonth; int nDay; int nYear; }; struct NameTag{ char strFirst[ 31 ]; char strLast[ 21 ]; }; struct EmployeeTag{ int nId; struct NameTag sName; struct DateTag sBirth; }; struct DepartmentTag{ char strName[ 21 ]; char strDescription[ 51 ]; struct EmployeeTag sManager; struct EmployeeTag arrEmployees[ 15 ]; }; struct CompanyTag{ char strName[ 31 ]; struct DepartmentTag arrDepartments[ 10 ]; }; struct CompanyTag c1, c2; struct DepartmentTag d1, d2; struct EmployeeTag e1, e2; struct EmployeeTag *pEmp; 1. Which statement(s) is/are syntactically correct? a) e1 = d1.sManager; b) e1 = d1.arrEmployees; 2. Which statement(s) is/are syntactically correct? a) d1.arrEmployees[ 0 ] = pEmp; b) pEmp = d1.arrEmployees; 3. Which statement(s) is/are syntactically correct? a) c1.d1 = d2; b) c2.arrDepartments[1] = d2;
What function does this Syntax perform? function myMap() {var map Canvas = document.getElementById("map");var mapOptions = {center: new google.maps.LatLng(51.5, -0.2),zoom: 10};var map = new google.maps.Map(mapCanvas, mapOptions);}
Here are what to display on your Pokémon's show page: The pokemon's name The image of the pokemon An unordered list of the Pokemon's types (eg. water, poison, etc). The pokemon's stats for HP, ATTACK, and DEFENSE. Routes Your app should use RESTful routes: Index GET /pokemon Show GET /pokemon/:id New GET /pokemon/new Edit GET /pokemon/:id/edit Create POST /pokemon Update PUT /pokemon/:id Destroy DELETE /pokemon/:id This is the module.js file module.exports = [ { id: "001", name: "Bulbasaur", img: "http://img.pokemondb.net/artwork/bulbasaur.jpg", type: [ "Grass", "Poison" ], stats: { hp: "45", attack: "49", defense: "49", spattack: "65", spdefense: "65", speed: "45" }, moves: { level: [{ learnedat: "", name: "tackle", gen: "V" }, { learnedat: "3", name: "growl", gen: "V" }, { learnedat: "7", name: "leech seed", gen: "V" }, {…
Using SuiteScript JavaScript. I have a dropdown box that displays supplier data that is sourced from a custom table in Netsuite. The goal here is to reorder the way the supplier data is viewed. For example, currently the supplier data is displayed: SupplierNumber SupplierName (1230 - APEX). UI Screenshot The desired view for the supplier dropdown is the reverse of that: SupplierName SupplierNumber (APEX - 1230). The variable highlighted is the internal ID of the table sourcing the Supplier dropdown field supplierField variable: var supplierField = form.addField('custpage_supplier', 'select', 'Supplier', 'customrecord_reorder_suppliers').setLayoutType('startrow'); Any guidance will be greatly appreciated. I have tried using different methods such as split(' ').reverse().join(' ') on that table object but it did not work.
Fix any error in this code import org.jfree.chart.ChartFactory;import org.jfree.chart.ChartPanel;import org.jfree.chart.JFreeChart;import org.jfree.data.category.DefaultCategoryDataset;import org.jfree.ui.ApplicationFrame;import org.jfree.ui.RefineryUtilities;public class BarChartExample extends ApplicationFrame {public BarChartExample(String title) {super(title);Object ChartFactory;JFreeChart barChart = ChartFactory.createBarChart("Referral Sources Count","Referral Source","Count",createDataset(),org.jfree.chart.plot.PlotOrientation.VERTICAL,true, true, false);ChartPanel chartPanel = new ChartPanel(barChart);chartPanel.setPreferredSize(new java.awt.Dimension(560, 367));setContentPane(chartPanel);}private DefaultCategoryDataset createDataset() {DefaultCategoryDataset dataset = new DefaultCategoryDataset();String series1 = "Referral Sources";dataset.addValue(250, series1, "Website");dataset.addValue(400, series1, "Word of Mouth");dataset.addValue(300, series1,…
The following schema is given (primary keys are bold): ARTWORK (ArtworkCode. Title, Author, BasicAuction Price, FinalSalePrice". NumParticipantingBuyers", FinalBuyerID") OFFER (ArtworkCode, BuyerID, Date, Amount) REQUEST AUCTION ENDING (ArtworkCode. Auction EndingDate, Description) Write the trigger to manage the following activities related to an online auction of artworks. The ARTWORK table contains the list of artworks sold at the auction. The OFFER table contains, for each artwork, a list of the amounts that have been offered by buyers interested in purchasing the artwork. The same buyer can make multiple offers for the same artwork on different dates. A request to end the auction for an artwork is generated (inserting a record into the table REQUEST AUCTION ENDING), If there was no offer for the artwork, the trigger ends with an error. Otherwise, you have to calculate the following information. (1) The final sale price of the artwork, corresponding to the highest amount offered…
Please allow the buttons to sort properly the sortByname, sortbywaittime and capacity to all sort please // Constructor that takes a Driver object as input public EntryScreen(Driver reservationlist1) { this.reservationlist1 = reservationlist1; // Initialize the necessary components txttableNumber = new JTextField(20); setTitle("Make a Reservation"); pnlCommand = new JPanel(); pnlDisplay = new JPanel(); String[] columnNames = {"ID", "Name", "Capacity", "Date", "Time"}; tableModel = new DefaultTableModel(columnNames, 0); table = new JTable(tableModel); JScrollPane scrollPane = new JScrollPane(table); add(scrollPane, BorderLayout.NORTH); // create the table and set the model // add the table to a scroll pane and add it to the GUI // add labels and text fields to the display panel pnlDisplay.add(new JLabel("Name:")); txtName = new JTextField(20);…
Favorite Color Rank the following colors according to your preference with 1 being the most preferred and 5 the least preferred color. Survey Result: (50 respondents) Favorite Color Ranking 1st 2nd 3rd 4th 5th Blue 8 7 9 15 11 Red 16 9 7 9 9 Yellow 11 14 11 5 9 Violet 4 11 17 10 8 Green 11 9 6 11 13 Instructions: Create a preference schedule for the rankings cast by your respondents.
Create an application for Paula’s Portraits, a photography studio. The application allows users to compute the price of a photography session. Paula’s base price is $40 for an in-studio photo session with one person. The in-studio fee is $75 for a session with two or more subjects, and $95 for a session with a pet. A $90 fee is added to take photos on location instead of in the studio. Include a set of mutually exclusive check boxes to select the portrait subject and another set for the session location. Include labels as appropriate to explain the application’s functionality. Save the file as JPhotoFrame.java.
Following is an explanation of the key differences between MonthCalendar and DateTimerPicker.
Please explain how to get the genre list to filter and how to associate the i to the title of the movie and display it on the finish screen. You can press to view code on the top right of the screen and you can edit it by creating a remix. Thank you for you help it is due today at 12. var nameList = getColumn("Netflix Content", "Title");var typeList = getColumn("Netflix Content", "Type");var typeSelection;onEvent("typeDropdown", "click", function( ) {typeSelection = getText("typeDropdown");});onEvent("startButton", "click", function( ) {setScreen("typeScreen");console.log("in STARTBUTTON typeSelection = "+typeSelection);});onEvent("toRatingButton", "click", function( ) {setScreen("finishScreen");console.log("typeSelection = "+typeSelection);// for (var i = 0; i < nameList.length; i++) {for (var i = 0; i < 25; i++) {console.log(((" i="+i)+" "+typeSelection)+" "+ratingSelection+" "+genreSelection+"--"+typeList[i]+" "+ratingList[i]+" "+genreList[i]);// if ((typeList[i] ==…
public void onClick(View view) {//declare variablesdouble a,b,c;//text values from x and yString S1= inputXEdit_Text.getText().toString();String S2 = inputYEdit_Text.getText().toString();a= Double.parseDouble(S1);b= Double.parseDouble(S2);//adding operation with variablesc=a+b;//c=a-b;// convert the answer to a numberString s=Double.toString(c);//display result it textViewtextView.setText(s); Please help to add math operations(-, * , / ) on Java