Given scenario: From given scenario, the “Foremost Composite Materials Company” planning for a two-day sales conference is as follows: Conference date – October 19-20 Number of employees – 120 sales representatives and 16 managers Number of Rooms – 138 (136 – for employees and 2 – for meeting room) Meeting room requirements: The sales force needs two meeting rooms. One to hold the 200 person and another to hold half the force. Attendee’s cities with their count: Los Angeles (53) San Francisco (31) Seattle (21) Chicago (18) Pittsburgh (13) Cost of food per day for an attendee is $70. Total budget of the management is $175000.

Question

Want to see the full answer?

Answer 1

Question

Chapter 5, Problem 11HMP

Program Plan Intro

Given scenario:

From given scenario, the “Foremost Composite Materials Company” planning for a two-day sales conference is as follows:

Conference date – October 19-20

Number of employees – 120 sales representatives and 16 managers

Number of Rooms – 138 (136 – for employees and 2 – for meeting room)

Meeting room requirements:

The sales force needs two meeting rooms. One to hold the 200 person and another to hold half the force.

Attendee’s cities with their count:

Los Angeles (53)

San Francisco (31)

Seattle (21)

Chicago (18)

Pittsburgh (13)

Cost of food per day for an attendee is $70.

Total budget of the management is $175000.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Q4: Consider the following MAILORDER relational schema describing the data for a mail order company. (Choose five only). PARTS(Pno, Pname, Qoh, Price, Olevel) CUSTOMERS(Cno, Cname, Street, Zip, Phone) EMPLOYEES(Eno, Ename, Zip, Hdate) ZIP CODES(Zip, City) ORDERS(Ono, Cno, Eno, Received, Shipped) ODETAILS(Ono, Pno, Qty) (10 Marks) I want a detailed explanation to understand the mechanism how it is Qoh stands for quantity on hand: the other attribute names are self-explanatory. Specify and execute the following queries using the RA interpreter on the MAILORDER database schema. a. Retrieve the names of parts that cost less than $20.00. b. Retrieve the names and cities of employees who have taken orders for parts costing more than $50.00. c. Retrieve the pairs of customer number values of customers who live in the same ZIP Code. d. Retrieve the names of customers who have ordered parts from employees living in Wichita. e. Retrieve the names of customers who have ordered parts costing less…

Q4: Consider the following MAILORDER relational schema describing the data for a mail order company. (Choose five only). (10 Marks) PARTS(Pno, Pname, Qoh, Price, Olevel) CUSTOMERS(Cno, Cname, Street, Zip, Phone) EMPLOYEES(Eno, Ename, Zip, Hdate) ZIP CODES(Zip, City) ORDERS(Ono, Cno, Eno, Received, Shipped) ODETAILS(Ono, Pno, Qty) Qoh stands for quantity on hand: the other attribute names are self-explanatory. Specify and execute the following queries using the RA interpreter on the MAILORDER database schema. a. Retrieve the names of parts that cost less than $20.00. b. Retrieve the names and cities of employees who have taken orders for parts costing more than $50.00. c. Retrieve the pairs of customer number values of customers who live in the same ZIP Code. d. Retrieve the names of customers who have ordered parts from employees living in Wichita. e. Retrieve the names of customers who have ordered parts costing less than$20.00. f. Retrieve the names of customers who have not placed…

ut da Q4: Consider the LIBRARY relational database schema shown in Figure below a. Edit Author_name to new variable name where previous surname was 'Al - Wazny'. Update book_Authors set Author_name = 'alsaadi' where Author_name = 'Al - Wazny' b. Change data type of Phone to string instead of numbers. عرفنه شنو الحل BOOK Book id Title Publisher_name BOOK AUTHORS Book id Author_name PUBLISHER Name Address Phone e u al b are rage c. Add two Publishers Company existed in UK. insert into publisher(name, address, phone) value('ali','uk',78547889), ('karrar', 'uk', 78547889) d. Remove all books author when author name contains second character 'D' and ending by character 'i'. es inf rmar nce 1 tic عرفته شنو الحل e. Add one book as variables data? عرفته شنو الحل