Please answers all questions blew with short answer, thank you so much.

1. View the video production at the link shown below ( or similar video ) and list five facts that you learned concerning these two information systems.

https://www.youtube.com/watch?v=q5f1xOA9IQQ

2.

Using one or more of the business or organizational entities listed below discuss a multi - dimensional analysis that can be performed on the entities with any or all of the above operations.

Business / Organizational Entities

a global parcel shipping company a sports memorabilia firm

a nationwide college or university an office supply superstore

a talent agency a vitamin and health shop

3.

You have been assigned the task of scrubbing an MS Access database table, which is used for data maintenance purposes. Explain how you would use MS Access to perform each of these scrubbing tasks.

(a) Locate any fields that contain two spaces and replace the two spaces with one space.

(b) Locate any duplicate records.

(c) Eliminate any records that have a particular field having a number value.

(d) Eliminate any records that have a field having an alpha - numeric value.

(e) Update any records that have any non - printing characters.

4.

Examine these tables their attributes and their relationships.

Orders {OrderID, OrderDate, CustomerID, ShippingDate, OrderStatus}

OrderDetails {OrderID, ProductID, Quantity, LineNumber}

Products {ProductID, Name, Description, Quantity, UnitPrice}

Without writing any SQL code statements, discuss five separate queries that would be useful to ascertain information regarding this database schema.