Diagram a distributed database environment in Microsoft Visio. Include the following in your diagram:-A production database-A data warehouse-Two data marts -Security and maintenance elements annotated

THE DREAM HOME SQL QUERY

Query 1

SELECT DISTINCT property. prop_num, property.rent, property.city

FROM property

WHERE (((property. Rent) ˂=450) AND ((property. City) = [enter city]))

AND prop_num not in

(SELECT prop_num

From lease

ORDER BY property.rent DESC);

Query 2

SELECT client.f_name + + client.l.name AS ClientFullName, client.phone,

FROM client, propclient, property

WHERE client.client_num = propclient.client_num

AND propclient.prop_num = property,prop_num

AND propclient.prop_num = [enter property number]

AND accom is null;

Query 3

SELECT client.f_name + + client.l.name AS ClientFullName, client.phone,

property.city, lease_num, lease.end_date

FROM client, lease, property

WHERE client.client_num = lease.client_num

AND lease.prop_num = property,prop_num

AND property.city = [enter city name]

AND month (lease.end_date) = month (DateAdd (‘m’, 1, now()));

Query 4

SELECT DISTINCT view_date, prop_num, client.client_num, accom

FROM propclient, client

WHERE client.client_num = propclient_num

AND prop_num = [enter property number]

ORDER BY view_date DESC;