Reference no: EM13328727

You can use any source you prefer, the text, Internet, etc. The answers should not take more than 1 - 2 paragraphs of text, please submit a word processing document, please make sure it's compatible with MS Word.

This is an INDIVIDUAL effort, I want each student to complete the questions on their own, you cannot solicit help, nor can you collaborate on the answers.

ANY RECOGNIZED SHARED ANSWER WILL MERIT A -0- FOR ALL PARTIES INVOLVED.

1.) In order to build a report for her manager, Mary needs to access data contained within the company's Oracle database. She would like to use MS Access to create the report presentation, because she's an expert developer, and the reporting interface is very robust.
The report will need to be refreshed each morning. She's come to you for questions regarding connectivity to the Oracle database, which method would you advise her to use to connect to the Oracle database?

2.) 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.)