Booking(agent: String, traveler_ssn: integer, trip_id: integer) TravelAgent(name: String, years_experience: integer, phone: String) Traveler(name, ssn, dob) Trip(id,...
Booking(agent: String, traveler_ssn: integer, trip_id: integer)
TravelAgent(name: String, years_experience: integer, phone: String)
Traveler(name, ssn, dob)
Trip(id, start_location, end_location, start_date, end_date)
1. Create the TravelAgent relation.
Homework Answers
Add Answer to:
Booking(agent: String, traveler_ssn: integer,
trip_id: integer)
TravelAgent(name: String, years_experience: integer,
phone: String)
Traveler(name, ssn, dob)
Trip(id,...
List all functional dependencies. (a) A travel agency keeps track of each traveler's name (TNAME), traveler...
List all functional dependencies.
(a) A travel agency keeps track of each traveler's name (TNAME), traveler number (TNUM), ssn (SSN) birthdate (BDATE), sex (SEX), address (TADDR) and phone (TPHONE) and alternative phone (APHONE), club (CLUB) (can be travelclub, costco travel, vacations_line, xtrem_trips...), preferred airline(AIRLINE), second preferred airline (SECOND_AIRLINE) (if any), and rewards level (REWARDS) (Diamond, Gold, Silver, Bronze). Both ssn and traveler number have unique values for each traveler (b) Each vacation plan has a destination name (VPNAME), description (VPDESC),...
14. Write a query that lists the trip id, trip name and state for all trips...
14. Write a query that lists the trip id, trip name and state
for all trips in New Hampshire. Run "Explain" against this query.
Now create an index on the state. Re-run your query and the
"Explain" Are there differences in the Explain results? Why or why
not?
Customer Customer Num LastName FirstName Address City State PostalCode Phone Reservation ReservationID TripID Trip Date Num Persons Trip Price Other Fees Customer Num Trip Guide TripID Guide Num LastName Trip Name Start...
The object class should be a Student with the following attributes: id: integer first name: String...
The object class should be a Student with the following attributes: id: integer first name: String last name: String write the accessors, mutators, constructor, and toString(). In your main test class you will write your main method and do the following things: Create an array of Student objects with at least 5 students in your array. Write a sort method that must be your original work and included in the main class. The sort method will sort based on student...
1) (10 points) Create a new Java project, name it "Quiz02". Create a java class Traveler...
1) (10 points) Create a new Java project, name it "Quiz02". Create a java class Traveler that has four data members, String name, Date bDate, int id and int noOfDependens. Generate the following: 1- Getters and Setters. 2- Four parametrize constructor to initialize the four data members above. 3- toString() method. Create a java class Flight that has four data members, String number, String destination, int capacity, and ArrayList<Traveler> travelers. • Notel - travelers will be used to track the...
Consider the following relations: Patient (pid: integer, lname: string, fname: string, primary_did: integer, age: integer) Doctor...
Consider the following relations: Patient (pid: integer, lname: string, fname: string, primary_did: integer, age: integer) Doctor (did: integer, lname: string, fname: string, deptid: integer, age: integer, salary: integer) Nurse (nid: integer, lname: string, fname: string, deptid: integer, rank: string, age: integer) Department (deptid: integer, name: string, budget: integer) Menu (menuid: integer, pid: integer, caloriecount: integer, saltlevel: integer, vegetarian: bit, diabetic: bit, nauseaSafe: bit, notes: string) Vaccination (vaccinationid: integer, pid: integer, vaccinationname: string, dategiven: date, dateexpires: date) Prescription (presid: integer, pid:integer,...
Please help me answer the following questions regarding data relationship tables. Employee ID First Name Last...
Please help me answer the following questions regarding data relationship tables. Employee ID First Name Last Name email Title Address Extension Department Department ID Hiring Date Department Phone # 0001 John Smith jsmith Accountant 1300 West st 5775 Accounting 2100 8/1998 407-366-5700 0002 Brian Miller badams Admin Assistant 1552 Palm dr 5367 Human resource 2300 4/1995 407-366-5300 0003 James Miller miller Inventory Manager 2713 Buck rd 5432 Production 2520 8/1998 407-366-5400 0004 John Jackson jackson_sam Sales Person 433 tree dr...
Write a program that defines a Print Job structure as follows: 1) An integer job Id...
Write a program that defines a Print Job structure as follows: 1) An integer job Id 2) A string user name (maximum 25 characters) 3) An integer tray (tray will hold the tray number 1 for 8 1/2 by 11 paper, number 2 for 8 1/2 by 11 paper, and number 3 for 8 1/2 by 14 paper) 4) An integer for paper size (this will hold a percentage: 100% is normal, 150% is 1.5 times the size) 5) A...
employee.h ---------- #include <stdio.h> #include <iostream> #include <fstream> class Employee { private: int employeeNum; std::string name;...
employee.h
----------
#include <stdio.h>
#include <iostream>
#include <fstream>
class Employee {
private:
int employeeNum;
std::string name;
std::string address;
std::string phoneNum;
double hrWage, hrWorked;
public:
Employee(int en, std::string n, std::string a, std::string pn,
double hw, double hwo);
std::string getName();
void setName(std::string n);
int getENum();
std::string getAdd();
void setAdd(std::string a);
std::string getPhone();
void setPhone(std::string p);
double getWage();
void setWage(double w);
double getHours();
void setHours(double h);
double calcPay(double a, double b);
static Employee read(std::ifstream& in);
void write(std::ofstream& out);
};
employee.cpp
----------
//employee.cpp
#include...
PREVIOUS ANSWERS ON THIS SITE ARE WRONG PLEASE DONT JUST REPOST THE ANSWERS (1) Create a Student class containing an ID, a last name, and a list of course names such as "COP2210" or "COP22...
PREVIOUS ANSWERS ON THIS SITE ARE WRONG PLEASE DONT JUST
REPOST THE ANSWERS
(1) Create a Student class containing an ID, a last name, and a
list of course names such as "COP2210" or "COP2250". This should
not be a string of multiple courses. The ID should be an integer
which is printed with leading zeros.
(2) Create a class named StudentTest that contains a List of
students. Do not use the list provided here. In the class
constructor, create...
List all functional dependencies.
(a) A travel agency keeps track of each traveler's name (TNAME), traveler number (TNUM), ssn (SSN) birthdate (BDATE), sex (SEX), address (TADDR) and phone (TPHONE) and alternative phone (APHONE), club (CLUB) (can be travelclub, costco travel, vacations_line, xtrem_trips...), preferred airline(AIRLINE), second preferred airline (SECOND_AIRLINE) (if any), and rewards level (REWARDS) (Diamond, Gold, Silver, Bronze). Both ssn and traveler number have unique values for each traveler (b) Each vacation plan has a destination name (VPNAME), description (VPDESC),...
14. Write a query that lists the trip id, trip name and state
for all trips in New Hampshire. Run "Explain" against this query.
Now create an index on the state. Re-run your query and the
"Explain" Are there differences in the Explain results? Why or why
not?
Customer Customer Num LastName FirstName Address City State PostalCode Phone Reservation ReservationID TripID Trip Date Num Persons Trip Price Other Fees Customer Num Trip Guide TripID Guide Num LastName Trip Name Start...
1) (10 points) Create a new Java project, name it "Quiz02". Create a java class Traveler that has four data members, String name, Date bDate, int id and int noOfDependens. Generate the following: 1- Getters and Setters. 2- Four parametrize constructor to initialize the four data members above. 3- toString() method. Create a java class Flight that has four data members, String number, String destination, int capacity, and ArrayList<Traveler> travelers. • Notel - travelers will be used to track the...
Write a program that defines a Print Job structure as follows: 1) An integer job Id 2) A string user name (maximum 25 characters) 3) An integer tray (tray will hold the tray number 1 for 8 1/2 by 11 paper, number 2 for 8 1/2 by 11 paper, and number 3 for 8 1/2 by 14 paper) 4) An integer for paper size (this will hold a percentage: 100% is normal, 150% is 1.5 times the size) 5) A...
employee.h
----------
#include <stdio.h>
#include <iostream>
#include <fstream>
class Employee {
private:
int employeeNum;
std::string name;
std::string address;
std::string phoneNum;
double hrWage, hrWorked;
public:
Employee(int en, std::string n, std::string a, std::string pn,
double hw, double hwo);
std::string getName();
void setName(std::string n);
int getENum();
std::string getAdd();
void setAdd(std::string a);
std::string getPhone();
void setPhone(std::string p);
double getWage();
void setWage(double w);
double getHours();
void setHours(double h);
double calcPay(double a, double b);
static Employee read(std::ifstream& in);
void write(std::ofstream& out);
};
employee.cpp
----------
//employee.cpp
#include...
PREVIOUS ANSWERS ON THIS SITE ARE WRONG PLEASE DONT JUST
REPOST THE ANSWERS
(1) Create a Student class containing an ID, a last name, and a
list of course names such as "COP2210" or "COP2250". This should
not be a string of multiple courses. The ID should be an integer
which is printed with leading zeros.
(2) Create a class named StudentTest that contains a List of
students. Do not use the list provided here. In the class
constructor, create...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago