IS 341: Project 1 Solution
30 HW points, 20 PDP points

Homework

• I wanted you all to change your password for the grading database. If you didn't, do so now. And then check that the grades I've put in the DB agree with what you should be getting.

  As a general rule, never use default passwords, you're just inviting someone to hack into your system. Last fall, a number problem arose with Microsoft SQL server, and it turned out that most database administrators just accepted the default system account password (which was to have no password at all), so malicious users could easily log into just about any SQL Server database out there and do anything they wanted to. Amazing. Amazing the the admin didn't change the password, and amazing that Microsoft let it happen.

• Information system questions:
• The grading DB is a relational DB, but you can't tell that for sure from looking at the interface. You must, rather, infer that from the fact that just about every new database out there is a relational database.
• Here's the info structure I would have created:

  

• There are always ethical and social issues related to storing personal information in databases and then making it available over the web. Never underestimate them.

If you have any questions on my grading, please feel free to talk to me, email me, or bring them up in class.

Personal Database Project

I accepted just about everything here. If you have questions about your project, or are considering switching projects, just let me know and we'll work something out.