You have two tables with identical structure, CUSTOMER and CUSTOMER_2. (Field names: custID, CFName, CLName, CAddr1, CAddr2, CCity, CST, CZip). Create the SQL statements that would 1)list the combined rows from both tables, 2)list the matching rows in both tables, 3)list the rows in CUSTOMER that do not exist in CUSTOMER_2, and 4)list the rows in CUSTOMER_2 that do not exist in CUSTOMER. Only list the SQL, you do not need to include any results.

 

3.) Thomas works for a newspaper in the MIS department, the newspaper has a CUSTOMER table (Field names: custID, CFName, CLName, CAddr1, CAddr2, CCity, CST, CZip). Currently, when a new customer is added to the CUSTOMER table, a record is manually created in the BILLING table. The database is SQL Server 2008. How would you advise Thomas so that this occurs automatically each time a new record is added to the CUSTOMER table (I am not looking for any SQL code, just a verbal description will be adequate)

 

4.) For Gwen's Beauty Consortium, you have the logical design complete, and are ready to build the physical model. She is still unsure which DBMS system to purchase, she wants database level security, as well as column-level security (she does not want her stylists to be able to easily see what each other earns). Her company is small (<25 employees), and the transaction volume is low. She is looking to you for direction and advice, what would you recommend? (You do not need to make a specific product suggestion, I am looking for a formal approach to analyze her specific situation.)

SophiaPretty

(5)

Status NEW Posted 01 Nov 2017 06:11 AM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer