QUE: 1 Identify 5 main differences between Transactional System and Business Data Warehouse.

QUE: 2 Identify the TRANSACTIONAL systems from the below list:

(A)Inventory System at Retail.

(B)Healthcare Claim Analytics.

(C) system to issue tickets at a local railway station.

(D)Reporting system to identify late appointments at doctors office.

(E)Ticketing system at a movie theatre.

(F) system to identify top-selling DVDs at local store.

(G) system to issue books at a library.

(H) ATM Machine.

QUE: 3 Using the below two SQL queries and comments below, provide an explanation on why the output count varies and which SQL yield correct result.

- Both SQLs are joining two tables.

- Both SQLs are syntactically correct.

- Query #1 returns about 19614 rows versus Query #2 returns 3550134.

QUE : 4

A business user is analyzing most travelled flight routes in Mid-west area. He is coming up with the count of passengers who flew from one city to another city and total amount (as part of revenue). There are about 120 routes that he is analyzing. He is analyzing flight data month wise for past 6 years.

Assuming that the above requirements are complete and will be used for creating a report, identify all the Dimensions and Facts. (Hint: There is 2 fact.)

Query #1: select * from person . Address addr inner join person. StateProvince prov on addr.StateProvinceID prov.StateProvinceID Query #2 : select * from person.Address addr,person. StateProvince prov