Databases | SQL | Oracle | MS Access Answers

Please research the encryption capabilities for the latest version of Oracle, Microsoft SQL Server, and MySQL.
Indicate the granularity level (What is encrypted? individual rows, tables, or the whole database?) and how keys are managed.
Then discuss what type of protection can be achieved using these capabilities. For example, are data-in-motion, data at rest, or data in use protected? Can bilateral security be achieved using these encryption capabilities?

Customers have Catogory: 1, 2 and 3 and a unique number.
Each transport operation is a job, which involves picking loads of products from a start location and delivers it to an end location. number is given for each job and for each load when they are created.
A Load is transported using a specific transport unit, which consists of lorry, driver, assistant, and a container. A container is fixed to a trailer so it needs to be coupled to a lorry at the start of a Job. (Single container can transport only one chemical product due to safety requirements).
Payments for a job depends on customer type, product type (No Risk, High risk) and the load type (small, medium and large).
Transport operations are run from 9 regional depots. Jobs are allocated to individual depots to service. Depots hold, manage and maintain transport units which allocated to them to service Jobs. transport units are held at the base Depot they belong to.
Identify user and system requirements

Customers have Catogory: 1, 2 and 3 and a unique number.
Each transport operation is a job, which involves picking loads of products from a start location and delivers it to an end location. number is given for each job and for each load when they are created.
A Load is transported using a specific transport unit, which consists of lorry, driver, assistant, and a container. A container is fixed to a trailer so it needs to be coupled to a lorry at the start of a Job. (Single container can transport only one chemical product due to safety requirements).
Payments for a job depends on customer type, product type (No Risk, High risk) and the load type (small, medium and large).
Transport operations are run from 9 regional depots. Jobs are allocated to individual depots to service. Depots hold, manage and maintain transport units which allocated to them to service Jobs. transport units are held at the base Depot they belong to.

Identify user and system requirements

Given that f(a,b,c,d,e) 
m(6,7,9,11,12,13,16,17,18,20,21,23,25,28),using a Karnaugh map, (a) Find the essential prime implicants (three). (b) Find the minimum sum of products (7 terms). (c) Find all of the prime implicants (twelve).

GivenF1 M(0,4,5,6) and F2 M(0,4,7),find the maxterm expansion for F1F2. State a general rule for finding the maxterm expansion of F1F2 given the maxterm expansions of F1 and F2. Prove your answer by using the general form of the maxterm expansion.

As the COVID-19 pandemic unfolds and data is being generated at an alarming rate, it is hard to separate the “wheat” from the chafe” when it comes to value in leveraging the amount of data generated.
For this exercise, please read the following 2 articles:
https://www.bruegel.org/2020/03/big-data-versus-covid-19-opportunities-and-privacy-challenges/
https://www.nature.com/articles/s41591-020-0832-5
Then choose one additional article/blog post/podcast of your choice and complete the following:
Write an opinion paper on the value, opportunity, dangers, and potential findings of using big data in this time of crisis.
Paper should be dense, rich, and concise. Paper should be no longer than 2 pages in length, single-spaced.

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)

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?

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

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