Please answers all questions blew with short answer, thank you so much. 1. View
ID: 3753989 • Letter: P
Question
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.
Explanation / Answer
3. MS Access all functionalities done by GUI Interface and SQL Queries are not needed for those. SQL Db Queries are not Needed and Accessability in MS Access will be thru 'Click and Proceed'.
4. Write SQL 5 separate queries ,
**Create Database
Query 1: CREATE DATABASE orderInfo;
**Create Table with the given colums
Query 2 : CREATE TABLE Orders(OrderID BIGINT NOT NULL, OrderDate VARCHAR(4000), CustomerID INTEGER NOT NULL, ShippingDate VARCHAR(3000),OrderStatus VARCHAR(1000), PRIMARY KEY (OrderID),PRIMARY KEY (CustomerID));
Query 3 : CREATE TABLE Products(ProductID BIGINT NOT NULL, Name VARCHAR(1000), Description VARCHAR(2000), Quantity INTEGER NOT NULL, UnitPrice BIGINT, PRIMARY KEY (ProductID), PRIMARY KEY(Quantity));
Query 4: CREATE TABLE OrderDetails(OrderID BIGINT,FOREIGN KEY (OrderID) REFERENCES Orders(OrderID), ProductID BIGINT, FOREIGN KEY (ProductID) REFERENCES Products(ProductID), Quantity INTEGER, FOREIGN KEY (Quantity) REFERENCES Products(Quantity), LineNumber INTEGER);
**Fetch Values for Order Table
Query 5: SELECT * FROM Orders;