UMBC logo

CMSC 461, Database Management Systems, Spring 2018

 

Homework 1 DUE Wed 2/7/2018 at 11:00 PM


Submit this homework assignment through Blackboard.

Please refresh your mind regarding homework policies by reading both the syllabus and the homework page.

    This assignment will consist of four screen captures. Include them all in a single PDF document. You can use Google docs to paste the screen captures in a document and then export as a PDF file. Submit the PDF document using Blackboard.
  1. Install and setup a MySQL database server on a machine that you have access to. Please use the MySQL Community Server 5.7. (MySQL Guide). Create a new database named with your UMBC GL username on your server. Submit a screen capture of the MySQL workbench showing that you connected to the database or a screen capture of the terminal showing that you connected to the database. (10 points)
  2. Write a "Hello World" python program that includes the version of python printed to the terminal or inside of an appropriate IDE. Submit a screen capture of the execution of this program with the output that includes the version. (10 points)
  3. Choose a program that you will use to perform entity relationship modeling. Create a simple relationship that involves the department and instructor entities. See pages 18 and 1272. Submit a screen capture of this output. (10 points)
  4. Choose a program that you will use to perform relational modeling. Create a model that includes the department and instructor tables as defined in the book. See page 1271. Submit a screen capture of this output. (10 points)
Document which contains the screen captures referenced in question 3 and question 4.
NOTE: You are not being graded on modeling for this homework. You are being graded on your ability to setup your environment that you will use this semester. Take this time to explore MySQL workbench and other tools that might be useful in assisting you with the database design.