CS520 HW3

Homework 3
CS520, Spring 2013

Due: Thursday, April 25

Package all the source files of your project into a zip file as you did in Homework 2 and upload the zip file to CSNS. Note that file uploading will be disabled automatically after 11:59PM of the due date, so please turn in your work on time.

[Readings]

Pro JPA 2 - Mastering the Java Persistence API

Chapter 1-2, 4-5, 8

Hibernate Annotations

Chapter 2.2 Mapping with JPA

[BVVO]

Follow Step 3 in Spring and Hibernate From Scratch to add Hibernate to the BVVO application you created in Homework 2.

[Model and ORM] (45pt)

Add model classes for BVVO based on the requirements described in Homework 1. Use JPA annotations to map the model classes to a relational schema.

Add Hbm2ddl.java to BVVO and run it to create a src/main/scripts/bvvo.ddl file which should contain the relational database schema generated from the annotations.

[Database Scripts] (15pt)

Based on bvvo.ddl generated in the previous exercise, create two SQL scripts for BVVO:

src/main/scripts/bvvo-create.sql - create all the tables and other schema elements (e.g. constraints, indexes, and so on).
src/main/scripts/bvvo-drop.sql - drop all the tables and other schema elements.

[Subversion]

Commit all the changes to your Subversion repository, and create a tag called cs520-hw3.