3.) Thomas works for a newspaper in the MIS department, the newspaper has a CUST

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 ( 5.) Goldey Beacom College is (hypothetically) thinking about opening another campus in the San Diego area. The students attending that campus would be mostly using information services there, as well as the faculty and staff. The billing systems would remain in Delaware, and there would be a need to have daily refreshed data from the main servers on the Delaware campus. This is a new endeavor for GBC, and they have hired you as a consultant, how would you advise them to accomplish this task to ensure the highest level of efficiency, and still provide reasonably current data? (Again, I am looking for your analysis approach, not an in-depth analysis.) 6.) Several years ago, the college developed an “in-house” enrollment system; it was developed for client-server and had all of the database control and logic built into the application. When it was designed the college had 1/5 of its current student population. During student enrollment periods (October, August), when there are several people entering records the system simply “locks up”, and no one can enter any additional information. Eventually, the system will release and most of the users get a cryptic “Your changes were not saved; another users' changes have overwritten yours.” The situation has become critical, and the college President and the VP of MIS wants to understand what is happening. They have hired you to assess the situation, what do you think is happening? 7.) You have been hired as a database administrator for a local financial services company. There are several analysts who have written queries against the transaction table for you company. It has millions of records. The analysts are complaining that their queries have gotten progressively slower over the past year. Please provide me with three suggestions on what you could do to help them improve their query performance?