-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Here is the answer key for the in-class exercise from Friday.
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Hello all, on Wednesday and Friday this week, we will be working on the next in-class assignment: SQL In. This will help you understand how to create, modify (i.e., add, remove and change columns) and delete […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Hello everyone,
Some things you should remember when answering questions for the SQL Out assignment (I guess you can call them Hints):
First: any time you have a query that involves multiple tables (e.g., to […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
So this is only tangentially related to the class, but a couple of you were asking me it on Friday (well, not exactly this, but implicitly). Where is all the hardware, who hosts all the websites, etc. Well, here […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Hello everyone,
Here are the results of the anonymous feedback questionnaire I asked you to fill out on Friday. I have highlighted the top three positives and negative aspects you reported about this course. […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
You might be interested to know just how popular MySQL is in the real world. What companies are running MySQL? Well, the list is quite long (see here), but here are some heavy hitters…
Telecomm: Comcast, […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Hello everyone,
Just a heads up, my TA (Magen Sheeran) will be available tomorrow to answer questions about Assignment 2 (SQL Out). She will be in the MIS Mobile Computing lab (Alter 603) from 2:30pm to […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Apologies for the delay. The class capture system is sort of “broken” at the moment. I have to wait for the capture to be manually published to the media server by our tech folks, who then e-mail me the link. As […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Answer one of the following questions as a comment on this post.
Submit your contribution by 3:00 PM on Friday, September 28.
Describe a situation where you’d need to use a join to retrieve information from […]
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
Yep, very good point. This again goes directly to the response I just posted to Kalsoom’s comment, below. Setting expectations with your customers about data sharing is key these days. Not only can you lose […]
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
That’s a great point Kalsoom. A lot of this depends on whether customers have an expectation of privacy. There is a sort of social contract there. If you violate that contract, as a service provider, your […]
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
That’s a good point, Kiet. It is interesting to note that, in recent years, customers have become more sensitive to what their data is being used for. If you read privacy terms on most websites these days (e.g., […]
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
Very good answer, Anthony. That is definitely one of the clearest distinctions between the two diagrams. Foreign keys simply are not represented anywhere in an ER diagram.
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
That’s right, Marisol. I would like to make one clarification though. Regardless of whether a relationship has an attribute tied to it, if it is many-to-many, it will become a separate table in the Schema diagram. […]
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
That’s a good point, Bob. The threat of competition is of course always a concern when it comes to something like this. This actually comes up a lot for me, when I am getting data from companies to do research. […]
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
That’s correct Jack. More generally though, you will need to create a new table (called an associative entity) whenever there is a many-to-many relationship.
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
You got it, Sviatlana. And of course the same is also true of many-to-many-to-many relationships, etc., like the Doctor-Patient-Procedure relationships we had in the first assignment.
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
That’s also a good point, Austin. Further, maybe they could try and understand things like market potential in areas where Trump is operating, yet where MGM has yet to setup shop?
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
Right, Dip. Probably the trickiest thing to understand is the conversion from a many:many relationship in an ER diagram, into an actual table structure (i.e., the associative entity; the additional table that gets […]
- Load More