Tonatiuh Paredes

The Most important takeaway would be MySQL. When I first started I was really lost and I thought I was never going to understand how to actually write a single command. I thought it was a completely new language, but after re-watching, all the class captures I got a grip on everything. The way I would explain this to an employer would be by simply…[Read more]

Question to ask would be how much leftover food should I have at the end of Thanksgiving so the fam doesn’t complain that I sent them with none. data collected would be the number of guests, and the amount each of them ate at past Thanksgiving dinners then cluster in the amounts. After that, just cook more and send everyone off happy.

A decision tree could be used by Apple to answer a question such as, Who will buy the new iPhone X and be able to pay it off? the data collected would be age, gender, income, if a person owned an iPhone before or not, and if a person is subjected to upgrade their iPhone every time a new one comes out, and what phone carrier’s they’re in because…[Read more]

A data cube could be used to store data on Samsung’s promotion payouts. The dimensions of the cube would include promotion ID, date the promotion started, date the promotion ended, customer ID, date costumer made purchase, type of promotion applied to the costumers purchase, quantity of purchased items by costumer. The question to be asked- what…[Read more]

An example of data that can be represented in two different ways would be miles per hour and kilometers per hour. In the US we use miles per hour and literally everywhere else in the world Kilometers per hour is used. Maybe it would be easier if we all agreed to use one method rather than get all confused by using two different methods. Or maybe…[Read more]

The graphic I chose is titled The Dark Web; Link http://coolinfographics.com/blog/2017/9/26/the-dark-web.html. I decided to choose this graphic because I after I only took a glance at it, it allowed me to understand what it was talking about right away. I was quickly informed on what illegal drugs and non-drug related sales are done through the…[Read more]

A situation in which you would join two tables would be in a wholesale distributor database, wherein one table you would have the restaurant’s in the US and on the other table, you would have the shipping orders. By joining these two tables you could figure out what shipping orders are being shipped to restaurants in Pa.

The part of creating an ERD, that I find the most challenging is finding the correct entities without getting confused with nouns that are not entities at all. During the exercises, and assignments that we have done I have realized that I get somewhat confused with which nouns are entities. The most efficient way that I have found to work for me…[Read more]

An example of raw data being turned into information would be that of a mechanic shop, they, for instance, have customers who come in for tune-ups. The mechanics do the tune up on the car and log the data on their computers, at this moment the computer knows who the customer is, what type of car the customer drives, and by gathering this data the…[Read more]