I would say that the most important takeaway from this course was the introduction to SQL and SAS. I feel like I am going to be using these tools in the near future and it was important to learn them in 2502. If I […]

When it comes to developing a new database, it is smart decision to adopt an existing standard to avoid any unneeded problems. Savvy businesses follow a “best practice” formula when venturing into something that […]

tue60084

I’ve already had previous experience with Pivot Tables, but I found the lectures informative. The greatest thing about Pivot Table is how easy you can convert data into facts. Small companies and even large […]

When I designed a website for a local spa, they asked the question,”How profitable are our hair products?” For this question we had to put together all the hair products that were sold at the spa and gather […]

1. Joining a table is necessary when the information extracted require data from one or more tables. For example, a database for a retailer may contain a product table, an order table, and a product-order table. […]

If two competing resorts shared critical information with each other, the costs of compensation would increase for both companies. As each company’s data is critical to maintaining a personable and unique […]

Questions 2,

Bad Cardinality can cause redundancy within a database and also limits a system’s ability to perform at optimum efficiency.

For example, a database designed by Newegg.com specify that a […]

2) I use to develop websites for small business and one of them in particular used a MySQL Database along with a Content Management System that controlled user information. As I was not familiar (at the time) with […]

Here is the link to my E-portfolio.

http://community.mis.temple.edu/hpham/