Question
In: Computer Science
Given the following 7 relations: MIScompany (name, address, phone, email, FedTaxId, StaTaxId) branch (branchId, name, address,...
Given the following 7 relations:
MIScompany (name, address, phone, email, FedTaxId, StaTaxId)
branch (branchId, name, address, phone, email, FedTaxId, StaTaxId)
employee (empId, driverId, ssno, name, branchId)
customer (custId, name, address, driverId, ssno, FedTaxId, StaTaxId)
equipment (equipId, name, type, upc, purchaseDate, year, manufacturId, cost, rentFee, branchId )
manufacturer (manufacturId, name, FedTaxId, StaTaxId, phone, email)
rental (rentalId, equipId, custId, rentDate&time, returnDate&time, empId)
1) Use relational algebra to list every manufacturer that only makes electric cleaning tool (type of equipment). The report should contain manufacturId and manufacturer name.
Solutions
Expert Solution
Given Tables are :
MIScompany (name, address, phone, email, FedTaxId, StaTaxId)
branch (branchId, name, address, phone, email, FedTaxId, StaTaxId)
employee (empId, driverId, ssno, name, branchId)
customer (custId, name, address, driverId, ssno, FedTaxId, StaTaxId)
equipment (equipId, name, type, upc, purchaseDate, year, manufacturId, cost, rentFee, branchId )
manufacturer (manufacturId, name, FedTaxId, StaTaxId, phone, email)
rental (rentalId, equipId, custId, rentDate&time, returnDate&time, empId)
Relational algebra to list every manufacturer that only makes electric cleaning tool (type of equipment). The report should contain manufacturId and manufacturer name.
This requirement needs the join operation of equipment and manufacturer table:
- SELECT(manufacturId ,name) - SELECTS only manufacturId and manufacturer name as required
- JOIN(manufacturer,equipment) - Joins the tables manufacturer & equipment.
- Where(e.manufacturId =m.manufacturId and e.type = 'electric cleaning tool'
venereology answered 3 months agoRelated Solutions
Given the following 7 relations: MIScompany (name, address, phone, email, FedTaxId, StaTaxId) branch (branchId, name, address,...
Given the following 7 relations:
MIScompany (name, address, phone,
email, FedTaxId, StaTaxId)
branch (branchId, name, address,
phone, email, FedTaxId, StaTaxId)
employee (empId, driverId, ssno, name,
branchId)
customer (custId, name, address,
driverId, ssno, FedTaxId, StaTaxId)
equipment (equipId, name, type, upc,
purchaseDate, year, manufacturId, cost, rentFee, branchId )
manufacturer (manufacturId, name,
FedTaxId, StaTaxId, phone, email)
rental (rentalId,
equipId, custId, rentDate&time,
returnDate&time, empId)
Use relational algebra to retrieve every customer that has not
rented any equipment in September 2020. The report should contain...
Using the given file, ask the user for a name, phone number, and email. Display the...
Using the given file, ask the user for a name, phone number, and
email. Display the required information.
These are the Files that I made:
import java.util.Scanner;
public class Demo5
{
public static void main(String args[])
{
Scanner keyboard = new Scanner(System.in);
System.out.println("New number creation tool");
System.out.println("Enter name");
String name = keyboard.nextLine();
System.out.println("Enter phone number");
String phoneNumber = keyboard.nextLine();
System.out.println("Enter email");
String email = keyboard.nextLine();
Phone test1 = new SmartPhone(name, phoneNumber, email);
System.out.print(test1);
System.out.println("Telephone neighbor: " + ((SmartPhone) test1).getTeleponeNeighbor());
}...
create a project charter GENERAL PROJECT INFORMATION Project Name: Project Sponsor: Project Manager: Email Address: Phone...
create a project charter
GENERAL PROJECT INFORMATION
Project Name:
Project Sponsor:
Project Manager:
Email Address:
Phone Number:
Organizational Unit:
Process Impacted:
Expected Start Date:
Expected Completion Date:
Expected Savings:
Estimated Costs:
PROBLEM, ISSUE, GOALS, OBJECTIVES, DELIVERABLES
Problem or Issue:
Purpose of Project:
Business Case:
Goals/Metrics:
Expected Deliverables:
PROJECT SCOPE & SCHEDULE
Within Scope
Outside of Scope
PROJECT RESOURCES & COSTS
Project Team
Support Resources
Special Needs
PROJECT BENEFITS & CUSTOMERS
Process Owner
Key Stakeholders
Final Customers
Expected Benefits
PROJECT RISKS,...
I need to add variables such as name, address and phone into a Jpanel in the...
I need to add variables such as name, address and phone into a
Jpanel in the constructor called AddressBook. I then need to add
that panel into a Jframe and call it in the main method how would i
do that in java.
Write a class named ContactEntry that has fields for a person’s name, phone number and email...
Write a class named ContactEntry that has fields for a person’s
name, phone number and email address. The class should have a
no-arg constructor and a constructor that takes in
all fields, appropriate setter and getter methods. Then write a
program that creates at least five ContactEntry objects and stores
them in an ArrayList. In the program create a method, that will
display each object in the ArrayList. Call the method to
demonstrate that it works. I repeat, NO-ARG
constructors....
Problem: Read the following tables and answer the following questions: Customers Customer ID Name Address Phone...
Problem: Read the following tables and answer the
following questions:
Customers
Customer ID
Name
Address
Phone
Email
9087
John Doe
204 University Ave.
987-098-9087
[email protected]
2098
Bill Lawrence
123 Jones St
717-387-3387
Business
2398
Laura Smith
0900 West Blvd.
901-234-4567
Information
Transactions
Customer ID
Account Number
Date of Last Transaction
9087
375
01/31/98
2098
123
03/09/97
2398
375
09/21/97
2098
375
12/31/97
2398
123
02/01/98
Accounts
Account Number
Balance
Account Type
375
234.45
Checking
123
056.90
Savings
1. Who owns...
Programming C: Write a program for a Rolodex of contact information (e.g., name, phone number, email)...
Programming C: Write a program for a Rolodex of contact
information (e.g., name, phone number, email) implemented as a
linked list. The program will ask the user to enter a new contact
information, retrieve/print a person’s contact information, and to
delete a person. It will maintain the linked list in alphabetical
order by last name. It will also allow the user to search for a
person’s contact information by last name. Assume that all last
names are unique.
First, the Python program prompts user to enter user information (name, email, and phone number). Then...
First, the Python program prompts user to enter user information
(name, email, and phone number). Then it displays a menu called
“Fish Information” that has the following fish type:
1. Cat Fish 2. Red Fish 3. Any other fish
Let user choose the fish type that he/she got and input the
length of the fish. Then the program will determine what should be
done with this particular fish. Based on the following
criteria:
Criteria: Length:
FISHTYPE - Cat Fish <10:...
Create a class called Student. Include the following instance variables: name, address, phone, gpa Create all...
Create a class called Student.
Include the following instance variables: name, address, phone,
gpa
Create all of the methods required for a standard user defined
class: constructors, accessors, mutators, toString, equals
Create the client for testing the Student class
Create another class called CourseSection
Include instance variables for: course name, days and times
course meets (String), description of course, student a, student b,
student c (all of type Student)
Create all of the methods required for a standard user defined...
Employee ID First Name Last Name email Title Address Extension Department Department ID Hiring Date Department...
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
5568
Sales
2102
6/1997
407-366-5500
0005
Robert
Davis
Davis
Manager
713...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Do you agree that Social Loafing is similar to Theory X. Give an example to support...
- Computing Cost of Goods Sold and Ending Inventory. Bartov Corporation reports the following beginning inventory and...
- SQL FORMAT (11-13 are completed and correct) -- 11. what are the names of all students...
- You have been hired as a capital budgeting analyst by Advent Sports, a sporting goods firm...
- DESCRIBE WHAT HAPPENS WHEN WE BECOME CONSCIOUS OF SOMETHING. WHAT HAS TO HAPPEN FOR CONSCIOUS AWARENESS...
- 3) You are rolling a 12 sided die 8 times. a) What is the size for...
- explain the difference between quantitative and qualitative research strategies. Provide an example of a crime based...
ADVERTISEMENT