|
Problem Set 2
Assigned: 9/9/09
Due: 5:00PM 9/16/09, email to the T.A. (Stan), place "CS 347 PS2" in the subject line, or hardcopy in class. (please do not be late.)
Homework objective: Part 1 of 2 homeworks where
- you will create models that encompass each of the major vocabulary elements of UML class diagrams, as such diagrams pertain to data modeling.
- determine how to use Rational Rose to capture and compile the concept
- learn the underlying relational implementation by examining the compiled results.
Required Reading:
- Jewett, (on-line text), UML Design, from the beginning through subclasses. Links as follows:
UML design
Problems:
For the following text questions,
- students and classes, http://www.tomjewett.com/
dbdesign/dbdesign.php?page= student.php - auto repair,
http://www.tomjewett.com/
- employee timecards
http://www.tomjewett.com/
- Plant species
http://www.tomjewett.com/
- Degrees
http://www.tomjewett.com/
- software list
http://www.tomjewett.com/
- Use Rose to develop a UML class diagram. (You need only write out the other parts of the text question as you need it help you through the design process). Per the Rose Notes handout, if you want one or more of your attributes to serve as the primary key, you must declare the attribute as contributing to the object identity.
- Compile the logical model to a physical model. Place the physical diagrams on the same sheet as the logical diagrams so that you may inspect the changes.
- Compile the physical model to SQL DDL.
For each problem, hand in a screen capture of the logical and physical models, (i.e. the answer to part b).
The intention here is for you to use Rose to create the relation schema asked for in the text question, AND, for you to examine and understand those details. (i.e. The intention is not for you to have Rose compile and produce the result, and have you think to yourself, sweet, this software will do some of my homework for me, so I can skip what I would learn if I were assigned to do it all by hand.)