Databases | SQL | Oracle | MS Access

1. In the Sales Orders database, make a mailing list of customers who ordered bikes in March 2018. Include a Type column that says Customer. Make sure each distinct customer only appears once. (9 rows)

Databases | SQL | Oracle | MS Access

Assume that two students are trying to register for a course in which there is only one open seat. What component of a database system prevents both students from being given that last seat?

Databases | SQL | Oracle | MS Access

Obtain and classify the relative extrema values of the function
F(x,y)=x³+y³-63(x+y)+12xy

Databases | SQL | Oracle | MS Access

73,15,44,37,30,59,49,99
Table size 9
Show those figures using Binary Tree insertion

Databases | SQL | Oracle | MS Access

Suppose Y=Wx²/6Ei(3a-x) for x<=a
Y=Wx²/6Ei(3x-a) for x>a
Use the if function to compute the value of deflection if W is in cell A4,E in A5,I in A6,a in B6 And x in B8

Databases | SQL | Oracle | MS Access

16. (4 pts) Display the different seasons in which trips are offered. List each season only once.

Databases | SQL | Oracle | MS Access

1.Ginny downloads and modifies an open source software program, then uploads the program with a different name. which type of software license is she most likely to be working under?
2. which of the following is an example of financial management software?
3. image-editing software allows you to?
4. digital audio software can be used to?
5. when you subscribe to software, no license is necessary. true or false.

Databases | SQL | Oracle | MS Access

Write a query to list of the names of all programs that do not include the course code ‘EN101’
Write a query to list all program-names and related course-names
Assuming that the program code for Bachelor of Science in Mathematics is ‘BSC4’,
construct a second logical view for Mathematics majors only. Your view must include all
attributes of the student record, the full descriptive name of the Bachelor of Science in
Mathematics program, and the descriptive name of the hall dormitory that the students
reside in.

Databases | SQL | Oracle | MS Access

For the relations s and r in your study manual of our chapter 2 (i.e., joining two relations),
suppose we type a collection of relational algebra queries, and get the following results.
A B C D E
A 2 a 10 B
b 2 a 10 b
Please explain how this happened? If you think this result could happen in practice, please write the
corresponding relational algebra queries; otherwise, please explain why.

Databases | SQL | Oracle | MS Access

QUESTION 2 40 MARKS
2.1 For the relations s and r in your study manual of our chapter 2 (i.e., joining two relations),
suppose we type a collection of relational algebra queries, and get the following results.
A B C D E
A 2 a 10 B
b 2 a 10 b
Please explain how this happened? If you think this result could happen in practice, please write the
corresponding relational algebra queries; otherwise, please explain why. (4