Search & Filtering
Databases | SQL | Oracle | MS Access
Write a query to list all Torontonian (Place name contains ‘Toronto’) students (name,
number, Hall-name) enrolled in the B.S. in Computer Science (program code ‘BSC2’)
Student table containing L/FName(s), Number, Hall-name, program_number and postal code (used to identify place_name which is toronto)
Address table containing postal code, place name and province.
program table containing program_number and program_name.
number, Hall-name) enrolled in the B.S. in Computer Science (program code ‘BSC2’)
Student table containing L/FName(s), Number, Hall-name, program_number and postal code (used to identify place_name which is toronto)
Address table containing postal code, place name and province.
program table containing program_number and program_name.
Databases | SQL | Oracle | MS Access
Give one example where consumer information is collected for marketing databases, but consumers receive some form of payment for the information.
Computer Ethics
Computer Ethics
Databases | SQL | Oracle | MS Access
A trigger which automatically raises an error whenever a client with Aqua phobia selects
Rafting as a preferred outdoor activity.
Rafting as a preferred outdoor activity.
Databases | SQL | Oracle | MS Access
A trigger that automatically calculates and stores in a separate table called
“Reservation_room_expense” the reservation number and the due amount for
accommodations for each record number. (Consider the 5% discount on room prices if the
trip consists of more than 5 days).
“Reservation_room_expense” the reservation number and the due amount for
accommodations for each record number. (Consider the 5% discount on room prices if the
trip consists of more than 5 days).
Databases | SQL | Oracle | MS Access
Write a stored function that uses the activity ID and date as input and returns the Name of
the supervisor assigned for that day.
the supervisor assigned for that day.
Databases | SQL | Oracle | MS Access
Write a stored procedure that displays the contact details of clients who does not have any
heart conditions or Acrophobia. The resort wants to promote a new outdoor activity to them.
heart conditions or Acrophobia. The resort wants to promote a new outdoor activity to them.
Databases | SQL | Oracle | MS Access
• Find the student names for all students who are in the BSIT program
• Find the faculty names for all faculty whose rank is associate professor
• Find the faculty names for all faculty who have taught CS251
•
• Assume that we have the followingER Model:
• Student takesCourse; Faculty teachesCourse; Studentis_inProgram
• We can transform all the Entities and Relationships into the following database tables:
• (1) Tables for Entities:
• Student ( Student_idAutoNumber, FNameShortText, LNameShortText)
• Course (Course_idAutoNumber, CNameShortText)
• Faculty(Faculty_idAutoNumber, FNameShortText, LNameShortText, Rank ShortText)
• Program (Program_idAutoNumber,PNameShortText)
• (2) Tables for Relationships:
• teaches(TeachesR_idAutoNumber, Faculty_idNumber, Course_idNumber)
• takes(TakesR_idAutoNumber, Student_idNumber, Course_idNumber)
• is_in(Is_InR_idAutoNumber, Student_idNumber, Program_idNumber)
• Find the faculty names for all faculty whose rank is associate professor
• Find the faculty names for all faculty who have taught CS251
•
• Assume that we have the followingER Model:
• Student takesCourse; Faculty teachesCourse; Studentis_inProgram
• We can transform all the Entities and Relationships into the following database tables:
• (1) Tables for Entities:
• Student ( Student_idAutoNumber, FNameShortText, LNameShortText)
• Course (Course_idAutoNumber, CNameShortText)
• Faculty(Faculty_idAutoNumber, FNameShortText, LNameShortText, Rank ShortText)
• Program (Program_idAutoNumber,PNameShortText)
• (2) Tables for Relationships:
• teaches(TeachesR_idAutoNumber, Faculty_idNumber, Course_idNumber)
• takes(TakesR_idAutoNumber, Student_idNumber, Course_idNumber)
• is_in(Is_InR_idAutoNumber, Student_idNumber, Program_idNumber)
Databases | SQL | Oracle | MS Access
Query 1: For each Symbol starting with the letter "A" compute the lowest and highest trade price every minute for all trades between 9:30am and 4:00pm
Here is my code so far, just need to know how to do the "every minute" part.
SELECT MAX(trade_price) AS HighestPrice, MIN(trade_price) AS LowestPrice
FROM trades_full
WHERE symbol LIKE 'A%'
AND HOUR(trading_date_time) BETWEEN 9.30 AND 16;
Here is my code so far, just need to know how to do the "every minute" part.
SELECT MAX(trade_price) AS HighestPrice, MIN(trade_price) AS LowestPrice
FROM trades_full
WHERE symbol LIKE 'A%'
AND HOUR(trading_date_time) BETWEEN 9.30 AND 16;
Databases | SQL | Oracle | MS Access
an error is coming up for these line
staffGender ENUM('M', 'F') NOT NULL,
and
staffShift ENUM('A', 'B', 'C') NOT NULL,
how can I fix these to stop the errors on for my script?
staffGender ENUM('M', 'F') NOT NULL,
and
staffShift ENUM('A', 'B', 'C') NOT NULL,
how can I fix these to stop the errors on for my script?
Databases | SQL | Oracle | MS Access
Find and describe an ethical failure in Business Analytics that occurred in the news. Who were the stakeholders, who was harmed, and who got an advantage? What were the facts? What set of ethical values were violated? What were alternative courses of action? Which course of action would have avoided or mitigated the ethical failure?
