Study.com Database Management Final Project FYI

[richland]

Do we need to provide the screen shots that included whole browser? or just the sections that show tables? Can we use arrow or circle to indicate the steps? Thanks!

[fork]

I captured mine then put in Gimp to cut it down to show just the area inside the browser window. I didn't draw any circles or arrows but I'm sure you can do that if you wanted to.

BTW I got mine back and most had 100% points but on prompt 11 they marked some off because I decided to put both tables together to make it fit on one screen for one screen shot. They marked the points off because there were NULL values showing in the table and they thought this was wrong. It was perfectly correct for the SQL I used to combine the tables. Heck it's right in the lesson itself that that would be the result of a full outer join which, BTW, is not available with MySQL so if you want to do it, you have to get creative with other commands, which is what I did AND I made a note of it on my project. I think the people that grade these don't understand what is being worked with. They just go off of a sheet that's provided to them, that would be my guess anyway. Well I got a 94 on the project and 89 in the class overall so I don't care. It's well above a passing grade and I'm moving on!

[richland]

I captured mine then put in Gimp to cut it down to show just the area inside the browser window. I didn't draw any circles or arrows but I'm sure you can do that if you wanted to.

BTW I got mine back and most had 100% points but on prompt 11 they marked some off because I decided to put both tables together to make it fit on one screen for one screen shot. They marked the points off because there were NULL values showing in the table and they thought this was wrong. It was perfectly correct for the SQL I used to combine the tables. Heck it's right in the lesson itself that that would be the result of a full outer join which, BTW, is not available with MySQL so if you want to do it, you have to get creative with other commands, which is what I did AND I made a note of it on my project. I think the people that grade these don't understand what is being worked with. They just go off of a sheet that's provided to them, that would be my guess anyway. Well I got a 94 on the project and 89 in the class overall so I don't care. It's well above a passing grade and I'm moving on!

Thank you! This is very helpful.

[richland]

I got my score back, I thought I was failed for the first try of the project, surprisedly I score 93. I only submitted result tables for each prompt not step by step, and they took some points off on prompt 3 because I didn't show complete tables. Fork was right about the final, it's a curve ball, which I didn't do well. I passed it with total score of 80. I am happy with that, keep moving on for the next challenging courses. Thanks y'all!

[MNomadic]

I know this is an old thread, but I just submitted this assignment. I took plenty of screen captures(hopefully). Will update if there's any odd grading going on, though I only need 30% to get my pass and move on(100% on quizzes & 80% on final).

[rachel83az]

I wish I'd seen this post before I did my assignment. The course still has the same kind of issues. Even a couple of years later. I got something like 80/100 on the assignment because it is worded vaguely. But that's "good enough" so I didn't bother to try to redo it at all.

[doom]

May I ask you if graders were nit-picky regarding alphanumeric data types? Did you use all VARCHARs or CHARs too?

[rachel83az]

Okay, I just opened the feedback (which I hadn't done before) and I actually got 87/100.  I followed the steps EXACTLY as I saw them written. I got 9/10 on 4, 5/10 on 5, 5/10 on 7 and 8/10 on 8. The actual feedback I received is:

Grader Notes:

• Good job on this assignment... just a few updates needed.
  
• For Prompt 4, I would chose a different index, e.g., pid so we can keep the indexes straight.
  
• Please show the SQL statements for Prompt 5 as well; the result is correct, we just need the SQL (full statements please)
  
• The same is true for #7
  
• On Prompt 8, what could go wrong if we left it as-is? What integrity issues does this pose?
  

So I didn't get dinged for CHAR vs. VARCHAR but I did get dinged for not showing the SQL statement AND the table. I honestly can't remember if I used CHAR or VARCHAR either.

[doom]

Okay, I just opened the feedback (which I hadn't done before) and I actually got 87/100.  I followed the steps EXACTLY as I saw them written. I got 9/10 on 4, 5/10 on 5, 5/10 on 7 and 8/10 on 8. The actual feedback I received is:

Grader Notes:

• Good job on this assignment... just a few updates needed.
  
• For Prompt 4, I would chose a different index, e.g., pid so we can keep the indexes straight.
  
• Please show the SQL statements for Prompt 5 as well; the result is correct, we just need the SQL (full statements please)
  
• The same is true for #7
  
• On Prompt 8, what could go wrong if we left it as-is? What integrity issues does this pose?
  

So I didn't get dinged for CHAR vs. VARCHAR but I did get dinged for not showing the SQL statement AND the table. I honestly can't remember if I used CHAR or VARCHAR either.

Thanks for sharing, I had initially followed the steps exactly as you did, but after reading this thread I think I will enrich the content a little bit...

[MNomadic]

I know this is an old thread, but I just submitted this assignment. I took plenty of screen captures(hopefully). Will update if there's any odd grading going on, though I only need 30% to get my pass and move on(100% on quizzes & 80% on final).

Wow that was quick grading! I just got it back with a 97/100. I basically just sent multiple screen captures of intermediate steps and multiple tables to ensure I sent more than enough. Prompt 11, I modified my input from what the assignment asks and it worked.

For me, the hardest part was somehow I messed up installing MySQL, and then when I uninstalled and reinstalled, it wasn't working right. I figured it out in the end.